VIEW: APPS.MTL_QOH_SUB_ALL_V

Source

View Text - Preformatted

SELECT A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.REVISION , A.SUBINVENTORY_CODE , B.DESCRIPTION , B.REVISION_QTY_CONTROL_CODE , B.PRIMARY_UOM_CODE FROM MTL_ONHAND_QUANTITIES_DETAIL A, MTL_SYSTEM_ITEMS B WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND A.ORGANIZATION_ID = B.ORGANIZATION_ID UNION SELECT C.ORGANIZATION_ID, C.INVENTORY_ITEM_ID, C.REVISION, C.SUBINVENTORY_CODE, D.DESCRIPTION, D.REVISION_QTY_CONTROL_CODE, D.PRIMARY_UOM_CODE FROM MTL_MATERIAL_TRANSACTIONS_TEMP C, MTL_SYSTEM_ITEMS D WHERE C.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID AND C.ORGANIZATION_ID = D.ORGANIZATION_ID

View Text - HTML Formatted

SELECT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.REVISION
, A.SUBINVENTORY_CODE
, B.DESCRIPTION
, B.REVISION_QTY_CONTROL_CODE
, B.PRIMARY_UOM_CODE
FROM MTL_ONHAND_QUANTITIES_DETAIL A
, MTL_SYSTEM_ITEMS B
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID UNION SELECT C.ORGANIZATION_ID
, C.INVENTORY_ITEM_ID
, C.REVISION
, C.SUBINVENTORY_CODE
, D.DESCRIPTION
, D.REVISION_QTY_CONTROL_CODE
, D.PRIMARY_UOM_CODE
FROM MTL_MATERIAL_TRANSACTIONS_TEMP C
, MTL_SYSTEM_ITEMS D
WHERE C.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID
AND C.ORGANIZATION_ID = D.ORGANIZATION_ID