APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on AHL_VISIT_TASKS_B

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 799: FROM ahl_visit_tasks_b

795: END IF;
796: -- Get the Planned task to ADD RTS FLAG
797: BEGIN
798: SELECT visit_task_id,object_version_number INTO l_upd_rts_task_tbl(1).visit_task_id,l_upd_rts_task_tbl(1).object_version_number
799: FROM ahl_visit_tasks_b
800: WHERE service_request_id = l_create_task_tbl(1).service_request_id
801: AND task_type_code = 'PLANNED';
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN

Line 877: FROM ahl_visit_tasks_b

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
879: AND task_type_code = 'PLANNED'
880: );
881: EXCEPTION