DBA Data[Home] [Help]

APPS.MRP_VALIDATE_FLOW_SCHEDULE dependencies on MTL_ITEM_LOCATIONS

Line 498: FROM mtl_item_locations

494: BEGIN
495:
496: SELECT 'VALID'
497: INTO l_dummy
498: FROM mtl_item_locations
499: WHERE organization_id = l_flow_schedule_rec.organization_id
500: AND subinventory_code = l_flow_schedule_rec.completion_subinventory
501: AND (disable_date > sysdate or disable_date is null)
502: AND inventory_location_id =