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)