VIEW: APPS.MTL_QOH_LOT_V

Source

View Text - Preformatted

SELECT DISTINCT A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.REVISION , A.TOTAL_QOH , A.RESERVED_QOH , A.AVAILABLE_QOH , A.SUBINVENTORY_CODE , A.LOCATOR_ID , A.LOT , B.DESCRIPTION ITEM_DESCRIPTION , A.PRIMARY_UOM_CODE , C.ORGANIZATION_CODE , F.NAME ORGANIZATION_NAME , D.AVAILABILITY_TYPE NET , D.RESERVABLE_TYPE RSV , D.INVENTORY_ATP_CODE ATP , E.EXPIRATION_DATE FROM MTL_QOH_LOT_TMP A, MTL_SYSTEM_ITEMS B, MTL_PARAMETERS C, MTL_SECONDARY_INVENTORIES D, MTL_LOT_NUMBERS E, HR_ORGANIZATION_UNITS F WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND A.SUBINVENTORY_CODE = D.SECONDARY_INVENTORY_NAME AND A.INVENTORY_ITEM_ID = E.INVENTORY_ITEM_ID AND A.LOT = E.LOT_NUMBER AND A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.ORGANIZATION_ID = D.ORGANIZATION_ID AND A.ORGANIZATION_ID = E.ORGANIZATION_ID AND A.ORGANIZATION_ID = F.ORGANIZATION_ID AND (D.SUBINVENTORY_TYPE = 1 OR D.SUBINVENTORY_TYPE IS NULL)

View Text - HTML Formatted

SELECT DISTINCT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.REVISION
, A.TOTAL_QOH
, A.RESERVED_QOH
, A.AVAILABLE_QOH
, A.SUBINVENTORY_CODE
, A.LOCATOR_ID
, A.LOT
, B.DESCRIPTION ITEM_DESCRIPTION
, A.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, F.NAME ORGANIZATION_NAME
, D.AVAILABILITY_TYPE NET
, D.RESERVABLE_TYPE RSV
, D.INVENTORY_ATP_CODE ATP
, E.EXPIRATION_DATE
FROM MTL_QOH_LOT_TMP A
, MTL_SYSTEM_ITEMS B
, MTL_PARAMETERS C
, MTL_SECONDARY_INVENTORIES D
, MTL_LOT_NUMBERS E
, HR_ORGANIZATION_UNITS F
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.SUBINVENTORY_CODE = D.SECONDARY_INVENTORY_NAME
AND A.INVENTORY_ITEM_ID = E.INVENTORY_ITEM_ID
AND A.LOT = E.LOT_NUMBER
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.ORGANIZATION_ID = D.ORGANIZATION_ID
AND A.ORGANIZATION_ID = E.ORGANIZATION_ID
AND A.ORGANIZATION_ID = F.ORGANIZATION_ID
AND (D.SUBINVENTORY_TYPE = 1 OR D.SUBINVENTORY_TYPE IS NULL)