DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 8761: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ

8757: AND ((l_rsv_rec.project_id IS NULL) OR (l_rsv_rec.task_id IS NULL)) THEN
8758: BEGIN
8759: SELECT wdj.project_id, WDJ.TASK_ID
8760: INTO l_project_id, l_task_id
8761: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ
8762: WHERE asmt.scheduled_material_id = l_rsv_rec.demand_source_line_detail
8763: AND asmt.visit_task_id = aw.visit_task_id
8764: AND ASMT.VISIT_ID = AW.VISIT_ID
8765: AND aw.wip_entity_id = wdj.wip_entity_id

Line 10479: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ

10475:
10476: BEGIN
10477: SELECT wdj.project_id, WDJ.TASK_ID
10478: INTO l_project_id, l_task_id
10479: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ
10480: WHERE asmt.scheduled_material_id = l_to_rsv_rec.demand_source_line_detail
10481: AND asmt.visit_task_id = aw.visit_task_id
10482: AND ASMT.VISIT_ID = AW.VISIT_ID
10483: AND aw.wip_entity_id = wdj.wip_entity_id

Line 13639: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ

13635: ELSE
13636: BEGIN
13637: SELECT wdj.project_id, WDJ.TASK_ID
13638: INTO l_project_id, l_task_id
13639: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ
13640: WHERE asmt.scheduled_material_id = l_to_rsv_rec.demand_source_line_detail
13641: AND asmt.visit_task_id = aw.visit_task_id
13642: AND ASMT.VISIT_ID = AW.VISIT_ID
13643: AND aw.wip_entity_id = wdj.wip_entity_id