INV Item Cross References (Oracle Fusion SQL)

Supply Chain & Manufacturing (SCM) Inventory (INV-Fusion-SQL's)
1

This INV Item Cross References query displays cross-reference values, descriptions, and units of measure for inventory items across organizations, helping users maintain accurate item mappings and support product traceability.

#sqlquery

SELECT 
 --SQL4Fusion (An Orbit Analytics Project)
 -- Retrieve cross-reference values, descriptions, and units of measure for inventory items across organizations.
  HAOU.NAME ORGANIZATION_NAME,
  ESI.ITEM_NUMBER,
  ESI.INVENTORY_ITEM_STATUS_CODE ITEM_STATUS,
  --ECR.INVENTORY_ITEM_ID,
  ECR.CROSS_REFERENCE_TYPE,
  ECR.DESCRIPTION,
  ECR.REVISION_ID REVISION,
  ECR.UOM_CODE UNIT_OF_MEASURE,
  ECR.CROSS_REFERENCE CROSS_REFERENCE_VALUE
FROM
  EGP_CROSS_REFERENCES ECR,
  EGP_SYSTEM_ITEMS ESI,
  HR_ALL_ORGANIZATION_UNITS HAOU
WHERE
  1 = 1
   AND ECR.INVENTORY_ITEM_ID = ESI.INVENTORY_ITEM_ID
   AND HAOU.ORGANIZATION_ID  = ESI.ORGANIZATION_ID