APPS.AHL_INV_RESERVATIONS_GRP dependencies on AHL_WORKORDERS

Line 306: FROM ahl_visit_tasks_b vt, ahl_workorders aw

302: AND Operation_sequence = c_oper_seq_num
303: AND status = 'ACTIVE'
304: AND requested_quantity <>0
305: AND visit_task_id = ( SELECT aw.visit_task_id
306: FROM ahl_visit_tasks_b vt, ahl_workorders aw
307: WHERE vt.status_code IN ('PLANNING','RELEASED')
308: AND aw.wip_entity_id = c_wip_entity_id
309: AND aw.status_code in ('1','3')
310: AND aw.visit_task_id= vt.visit_task_id );