Oracle Apps Technical Stuff
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 ...
Oracle Fusion SQL: OSQL to Extract Inventory Pending Transactions (Records stuck in Oracle inventory Interface table)
›
SELECT iop.organization_code, iop.organization_name, ittv.transaction_type_name, flva.meaning transaction_action, mti.tRANS...
Oracle Fusion: SQL to extract Inventory Organization Parameters Details
›
SELECT a.organization_id, a.organization_code, g.name organization_name, a.master_organization_id, b.organizat...
‹
›
Home
View web version