Showing posts with label Oracle Fusion Order Management. Show all posts
Showing posts with label Oracle Fusion Order Management. Show all posts
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: 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...
Tuesday, July 20, 2021

FA:OM:SQL To List EFF Segments and attribute Columns mapping for Specific Context

›
 SELECT DISTINCT fdcb.context_code               , fdcb.context_identifier               , fdcb.enabled_flag               , fdsb.segment_co...
Tuesday, July 6, 2021

FA:RCV:SQL to get RMA Receipts Details in Oracle Fusion

›
 REM RMA Receipts Details SELECT DHA.SOURCE_ORDER_NUMBER      , HDR_LKP.MEANING ORDER_TYPE      , DFLA.SOURCE_LINE_NUMBER      , LINE_LKP.ME...
Friday, February 26, 2021

SQL to get the RMA Details In Oracle Fusion (Inventory/Order Management)

›
SELECT DISTINCT iop.organization_code warehouse_code               , haotl.name warehouse_name               , rt.subinventory              ...