View: MTL_AVAILABLE_INVENTORY_V

Product:	INV - Inventory
Description:	View of select available inventory
Implementation/DBA Data:	APPS.MTL_AVAILABLE_INVENTORY_V

View Text

SELECT PKLT.LOCATOR_ID
, LOT.LOT_NUMBER
, PKLT.SUBINVENTORY_CODE
, INV_PROJECT.GET_LOCATOR(PKLT.LOCATOR_ID
, PKLT.ORGANIZATION_ID)
, LOT.CREATION_DATE
, LOT.EXPIRATION_DATE
, PKLT.GRADE_CODE
, PKLT.TRANSACTION_TEMP_ID
, PKLT.REASON_ID
, RSN.REASON_NAME
, DECODE(PKLT.TRANSACTION_TEMP_ID
, 0
, 0
, SUM(TRANSACTION_QTY)) TRANS_QTY
, DECODE(PKLT.TRANSACTION_TEMP_ID
, 0
, 0
, SUM(SECONDARY_TRANSACTION_QTY)) TRANS_QTY2
, PKLT.TRANSACTION_UOM
, PKLT.SECONDARY_UOM
, PKLT.REVISION
, PKLT.LPN_ID
, PKLT.ORDER_BY
, PKLT.WMS_RULE_ID
FROM MTL_AVAILABLE_INVENTORY_TEMP PKLT
, MTL_LOT_NUMBERS LOT
, MTL_ITEM_LOCATIONS_KFV LOCT
, MTL_TRANSACTION_REASONS RSN
WHERE PKLT.LOT_NUMBER = LOT.LOT_NUMBER (+)
AND PKLT.LOCATOR_ID = LOCT.INVENTORY_LOCATION_ID(+)
AND PKLT.REASON_ID = RSN.REASON_ID(+)
AND PKLT.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_ID(+)
AND PKLT.ORGANIZATION_ID = LOT.ORGANIZATION_ID(+) GROUP BY PKLT.LOCATOR_ID
, LOT.LOT_NUMBER
, PKLT.SUBINVENTORY_CODE
, INV_PROJECT.GET_LOCATOR(PKLT.LOCATOR_ID
, PKLT.ORGANIZATION_ID)
, LOT.CREATION_DATE
, LOT.EXPIRATION_DATE
, PKLT.GRADE_CODE
, PKLT.TRANSACTION_TEMP_ID
, PKLT.REASON_ID
, RSN.REASON_NAME
, PKLT.TRANSACTION_UOM
, PKLT.SECONDARY_UOM
, PKLT.REVISION
, PKLT.LPN_ID
, PKLT.ORDER_BY
, PKLT.WMS_RULE_ID ORDER BY ORDER_BY

Columns