Oracle Apps Technical

Friday, February 8, 2013

Language set in toad

BEGIN
fnd_client_info.set_org_context('185');DBMS_SESSION.set_nls ('NLS_LANGUAGE', 'AMERICAN');
end;






 
at February 08, 2013
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2024 (7)
    • ►  September (1)
    • ►  July (3)
    • ►  April (1)
    • ►  February (2)
  • ►  2016 (5)
    • ►  July (1)
    • ►  February (3)
    • ►  January (1)
  • ▼  2013 (11)
    • ►  November (2)
    • ►  September (1)
    • ►  April (1)
    • ►  March (3)
    • ▼  February (4)
      • Date format in reports
      • Query for flex_value valueset
      • Update expense account for the item in mtl_system_...
      • Language set in toad
  • ►  2012 (5)
    • ►  September (1)
    • ►  June (4)
  • ►  2011 (1)
    • ►  June (1)
  • ►  2010 (9)
    • ►  December (3)
    • ►  November (1)
    • ►  May (5)
  • ►  2009 (5)
    • ►  June (1)
    • ►  March (3)
    • ►  February (1)
  • ►  2008 (7)
    • ►  November (7)
  • query for item onhand quantity & Lot wise query
    SELECT  msi.segment1 item_name,mq.subinventory_code, b.SEGMENT1||'.'||b.SEGMENT2||'.'||b.SEGMENT3||'.'||b.SEGMENT4 ...
  • hr_assignment_api.update_emp_asg in HRMS
    create table xx_gosi_update ( emp_no varchar2(240) ,gosi  varchar2(240) ,status varchar2(240) ) Below is the script for update the as...
  • Query for PR PO Receipt Invoice Payments
    --PR and PO (Standard) select distinct prha.requisition_header_id,          prha.segment1 pr_number,          trunc(prha.creation_da...
Simple theme. Powered by Blogger.

Price List API

CREATE OR REPLACE PACKAGE BODY apps."XXABC_AUS_PRICE_LOAD_PKG" AS /*+-------------------------------------------------------------...