Oracle Apps Technical Stuff
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....
Oracle Fusion SQL : SQL to Extract Transfer Order details
›
SELECT d.header_number , e.line_number , so.organization_code source_inv_org , do.organization_code dest_inv_org ...
‹
›
Home
View web version