Showing posts with label Oracle Fusion Inventory Management. Show all posts
Showing posts with label Oracle Fusion Inventory Management. Show all posts
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...
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    ...
Sunday, February 27, 2022

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...
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              ...

SQL to get Material Transaction Details (Oracle Fusion Inventory Management)

›
 SQL to get Material Transaction Details SELECT iop.organization_code warehouse_code      , ittv.transaction_type_name      , flva.meaning t...