APPS.AHL_INV_RESERVATIONS_GRP dependencies on AHL_VISIT_TASKS_B

Line 287: FROM ahl_visit_tasks_b vt

283: AND rt_oper_material_id = c_rt_oper_material_id
284: AND status = 'ACTIVE'
285: AND requested_quantity <>0
286: AND EXISTS ( SELECT 1
287: FROM ahl_visit_tasks_b vt
288: WHERE vt.status_code = 'PLANNING'
289: AND vt.visit_task_id = c_visit_task_id);
290: -- Validating the details if it is of type WIP
291: CURSOR get_mtl_dtls_wip_cur ( c_scheduled_material_id IN NUMBER,

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 );