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 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ▼  2024 (7)
    • ▼  September (1)
      • Price List API
    • ►  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)
  • ►  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 ...
  • 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...
  • 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...
Simple theme. Powered by Blogger.

Price List API

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