Oracle Apps Technical Stuff
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...
Monday, February 21, 2022
Oralce Fusion: SQL to Get Concatenated Address example
›
Inventory Organization Location ================================= SELECT z.organization_code, z.organization_name, b.location_...
‹
›
Home
View web version