View: MTL_ONHAND_ATP

Product:	INV - Inventory
Description:	This view would be used by Planning to calculate the ATPable quantity for an item.
Implementation/DBA Data:	APPS.MTL_ONHAND_ATP

View Text

SELECT MOQ.INVENTORY_ITEM_ID
, MOQ.ORGANIZATION_ID
, MOQ.DATE_RECEIVED
, MOQ.PRIMARY_TRANSACTION_QUANTITY
, MOQ.SECONDARY_TRANSACTION_QUANTITY
, MOQ.SUBINVENTORY_CODE
, MOQ.REVISION
, MOQ.LOCATOR_ID
, MOQ.LOT_NUMBER
, MOQ.LPN_ID
FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ
, MTL_SECONDARY_INVENTORIES MSI
WHERE ((MOQ.LOT_NUMBER IS NOT NULL
AND EXISTS( SELECT 1
FROM MTL_LOT_NUMBERS MLN
WHERE MLN.INVENTORY_ITEM_ID = MOQ.INVENTORY_ITEM_ID
AND MLN.LOT_NUMBER = MOQ.LOT_NUMBER
AND MLN.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND MLN.INVENTORY_ATP_CODE = 1)) OR MOQ.LOT_NUMBER IS NULL)
AND ( ( MOQ.LOCATOR_ID IS NOT NULL
AND EXISTS( SELECT 1
FROM MTL_ITEM_LOCATIONS MIL
WHERE MIL.INVENTORY_LOCATION_ID = MOQ.LOCATOR_ID
AND MIL.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND MIL.INVENTORY_ATP_CODE = 1 )) OR MOQ.LOCATOR_ID IS NULL)
AND ( MSI.SECONDARY_INVENTORY_NAME = MOQ.SUBINVENTORY_CODE
AND MSI.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND MSI.INVENTORY_ATP_CODE = 1)

Columns