APPS.PJM_MASS_TRANSFER_PUB dependencies on MTL_LOT_NUMBERS

Line 664: FROM mtl_lot_numbers

660: AND mil.project_id = P_From_Project_ID
661: AND nvl(mil.task_id , 0) = nvl(P_From_Task_ID , 0)
662: AND NOT EXISTS (
663: SELECT 'Expired lot'
664: FROM mtl_lot_numbers
665: WHERE organization_id = moq.organization_id
666: AND inventory_item_id = moq.inventory_item_id
667: AND lot_number = moq.lot_number
668: AND expiration_date < sysdate )