[Home] [Help]
View: MTL_QOH_ITEM_V
View Text
SELECT DISTINCT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.TOTAL_QOH
, A.RESERVED_QOH
, A.AVAILABLE_QOH
, B.DESCRIPTION ITEM_DESCRIPTION
, A.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, D.NAME ORGANIZATION_NAME
FROM MTL_QOH_ITEM_TMP A
, MTL_SYSTEM_ITEMS B
, MTL_PARAMETERS C
, HR_ORGANIZATION_UNITS D
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.ORGANIZATION_ID = D.ORGANIZATION_ID
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
TOTAL_QOH |
RESERVED_QOH |
AVAILABLE_QOH |
ITEM_DESCRIPTION |
PRIMARY_UOM_CODE |
ORGANIZATION_CODE |
ORGANIZATION_NAME |