Showing posts with label AOL And Generic SQLs. Show all posts
Showing posts with label AOL And Generic SQLs. Show all posts
Thursday, June 23, 2022

FA:OM:SQL: To get the RMA Order receipt details along with the Serial numbers

›
 WITH sn_tbl as (  SELECT dha.header_id                             , dla.line_id                             , dfla.fulfill_line_id        ...
Tuesday, May 24, 2022

Fusion: SQL: Query to Extract the Business Units and its related Inventory Organizations, Business Units and Costing Organizations

›
    SELECT hou.organization_id        , hou.name organization_name        , iop.organization_code organization_code        , lgr.ledger_id s...
Wednesday, April 13, 2022

FA:SCM:CST: SQL to Get Item Standard Cost

›
 SELECT houft.name cost_organization_name        , esi.item_number        , csc.total_cost        , uom.uom_code        , cvu.val_unit_code ...
Tuesday, May 2, 2017

Script to Submit the Request Set using API in Oracle

›
Using below script One can submit the request set. But to execute the below script successfully define the Concurrent program for the follo...
Friday, April 28, 2017

How to Pass Parameters from One Program to the Next Program in a Request Set

›
How to Pass Parameters from One Program to the Next Program in a Request Set (Doc ID 239808.1) APPLIES TO...
Friday, January 9, 2015

Script to Create New FND_USER and Assign Responsilities and also Update/Create Profile For ICX_FORMS_LAUNCHER

›
------------------------------------------------------------------------------------------------ -- Replace the Value for l_user_name for c...
1 comment:
Thursday, December 4, 2014

SQL query to get the details of Scheduled Concurrent Requests in Oracle applications

›
  SELECT r.request_id        , p.user_concurrent_program_name          || NVL2 (r.description                 , ' ('           ...
Saturday, August 23, 2014

Script to Compile Invalid Objects in a Schema

›
This procedure recompile invalid objects in a given schema or all invalid objects in the database. Parameter :  schema     (IN) - Schem...
Tuesday, August 19, 2014

How to use comma separated string build dynamically and pass to IN clause of select statement

›
In some cases, we get a comma separated string as output (say from another select statement) that we would need to pass to the IN claus...
Monday, July 7, 2014

Function to convert number to Word

›
FUNCTION to_word_i( amount IN NUMBER)    RETURN VARCHAR2 AS    v_length                                     INTEGER := 0;    v_num2   ...
Friday, March 21, 2014

Script to Set the Global Info (FND_GLOBAL.APPS_INITIALIZE)

›
PROCEDURE set_global_info(    p_responsibility_id      IN             NUMBER := fnd_api.g_miss_num  , p_user_id                IN        ...