DBA Data[Home] [Help]

APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on AHL_WORKORDER_OPERATIONS

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