Oracle Apps Technical Stuff
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 ...
Fusion:SCM:MFG: SQL to Validat the Componenet Issue and WO Completion transactions against Work Order
›
SELECT imt.transaction_id,iop.organization_code warehouse_code , TO_CHAR(imt.creation_date,'DD-MON-YYYY') txn_creation_date ...
Tuesday, March 22, 2022
Fusion: SCM: SQL to get the RMA receipts and order number details
›
SELECT imt.transaction_id , iop.organization_code warehouse_code , To_char(imt.creation_date, 'DD-MON-YYYY') txn_crea...
Sunday, February 27, 2022
Oracle Fusion SQL: SQL to Extract the Sales order Orchestraction Steps with each Step Status details
›
SELECT h.source_order_number , h.header_id , f.fulfill_line_id , f.source_line_number , f.source_line_id , pd....
‹
›
Home
View web version