VIEW: APPS.MTL_ONHAND_ATP

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)