Oracle Apps Technical Stuff
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, June 14, 2022
FA:SQL: Query to get inventory organization/inventory organization location and business unit and Legal entity
›
SELECT iod.organization_code, iod.organization_name, iod.business_unit_name, iod.business_unit_id, iod.legal_ent...
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 ...
‹
›
Home
View web version