DBA Data[Home] [Help]

APPS.AHL_MM_RESERVATIONS_PVT dependencies on WIP_DISCRETE_JOBS

Line 57: FROM ahl_schedule_materials asmt, ahl_workorders aw, wip_discrete_jobs wdj

53: GROUP BY mr.demand_source_line_detail
54: ) reserved_quantity,
55: nvl(asmt.completed_quantity,0) completed_quantity, asmt.workorder_operation_id, asmt.operation_sequence,
56: aw.wip_entity_id,aw.workorder_id,wdj.project_id, wdj.task_id
57: FROM ahl_schedule_materials asmt, ahl_workorders aw, wip_discrete_jobs wdj
58: WHERE asmt.scheduled_material_id = c_scheduled_material_id
59: AND asmt.visit_task_id = aw.visit_task_id
60: AND aw.wip_entity_id = wdj.wip_entity_id
61: AND asmt.visit_id = aw.visit_id