DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on WIP_DISCRETE_JOBS

Line 617: wip_discrete_jobs WIP

613: --WO to WO
614: SELECT WIP.scheduled_completion_date AVAILABLE_DATE,
615: RESERVATION.reservation_quantity RESERVED_QTY
616: FROM mtl_reservations RESERVATION,
617: wip_discrete_jobs WIP
618: WHERE WIP.wip_entity_id = RESERVATION.supply_source_header_id
619: AND RESERVATION.supply_source_type_id = 5 /*g_source_type_wip = 5*/
620: AND RESERVATION.demand_source_line_detail = p_scheduled_material_id
621: ) ALL_RESERVATIONS;