APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on AHL_WORKORDERS

Line 61: FROM ahl_schedule_materials asm,ahl_workorders awo, ahl_visits_b vst

57: IS
58: SELECT asm.inventory_item_id, asm.visit_id, asm.visit_task_id,
59: asm.requested_quantity, awo.workorder_id, awo.wip_entity_id, awo.workorder_name
60: , vst.item_instance_id,asm.organization_id
61: FROM ahl_schedule_materials asm,ahl_workorders awo, ahl_visits_b vst
62: WHERE asm.status = 'ACTIVE'
63: AND asm.AOG_FLAG = 'Y'
64: AND asm.visit_task_id = awo.visit_task_id
65: AND awo.status_code in ('1','3','6')

Line 107: FROM ahl_visit_tasks_b vts, ahl_workorders awo, ahl_workorder_operations wop

103:
104: CURSOR get_wo_det(c_sr_id NUMBER, c_visit_id NUMBER)
105: IS
106: SELECT vts.visit_task_id, awo.workorder_id , awo.wip_entity_id, wop.operation_sequence_num, wop.workorder_operation_id, vts.start_date_time, awo.workorder_name
107: FROM ahl_visit_tasks_b vts, ahl_workorders awo, ahl_workorder_operations wop
108: WHERE vts.visit_task_id = awo.visit_task_id
109: AND awo.workorder_id = wop.workorder_id
110: AND vts.task_type_code = 'PLANNED'
111: AND vts.service_request_id = c_sr_id

Line 620: FROM AHL_WORKORDERS WO

616:
617: CURSOR c_visit_task_csr(c_nonroutine_wo_id IN NUMBER)
618: IS
619: SELECT WO.visit_task_id
620: FROM AHL_WORKORDERS WO
621: WHERE WO.workorder_id = c_nonroutine_wo_id;
622:
623: CURSOR get_sr_details(c_sr_incident_id NUMBER)
624: IS

Line 874: FROM ahl_workorders

870:
871: -- Input to the update Workorder - Workorder Id
872: BEGIN
873: SELECT workorder_id INTO l_temp_wo_id
874: FROM ahl_workorders
875: WHERE visit_task_id =
876: ( SELECT visit_task_id
877: FROM ahl_visit_tasks_b
878: WHERE service_request_id = l_create_task_tbl(1).service_request_id