APPS.AHL_INV_RESERVATIONS_GRP dependencies on AHL_VISIT_TASKS_B

Line 83: ahl_workorders wo, ahl_visit_tasks_b vts

79: --It also validates workorder's RTS flag, WO state, and reservation for this WO as valid supply in mtl_reservation table.
80: CURSOR get_workorder_quantity(c_wip_entity_id IN NUMBER, c_source_type IN NUMBER) IS
81: SELECT 1
82: FROM
83: ahl_workorders wo, ahl_visit_tasks_b vts
84: WHERE
85: wo.wip_entity_id = c_wip_entity_id
86: AND wo.status_code NOT IN (7, 22, 17, 12, 18, 21, 4, 5) -- cancelled, deleted, draft, closed,Deffered,Pending Defer/Cancel Approval, Complete, Complete No-charge
87: AND vts.visit_task_id = wo.visit_task_id

Line 375: FROM ahl_visit_tasks_b vt

371: AND rt_oper_material_id = c_rt_oper_material_id
372: AND status = 'ACTIVE'
373: AND requested_quantity <>0
374: AND EXISTS ( SELECT 1
375: FROM ahl_visit_tasks_b vt
376: WHERE vt.status_code = 'PLANNING'
377: AND vt.visit_task_id = c_visit_task_id);
378: -- Validating the details if it is of type WIP
379: CURSOR get_mtl_dtls_wip_cur ( c_scheduled_material_id IN NUMBER,

Line 394: FROM ahl_visit_tasks_b vt, ahl_workorders aw

390: AND Operation_sequence = c_oper_seq_num
391: AND status = 'ACTIVE'
392: AND requested_quantity <>0
393: AND visit_task_id = ( SELECT aw.visit_task_id
394: FROM ahl_visit_tasks_b vt, ahl_workorders aw
395: WHERE vt.status_code IN ('PLANNING','RELEASED')
396: AND aw.wip_entity_id = c_wip_entity_id
397: AND aw.status_code in ('1','3')
398: AND aw.visit_task_id= vt.visit_task_id );

Line 410: ahl_workorders wo, ahl_visit_tasks_b vts, wip_discrete_jobs wdj

406: */
407: CURSOR validate_wip_supply(c_wip_entity_id IN NUMBER, c_item_id IN NUMBER, c_organization_id IN NUMBER, c_source_type IN NUMBER) IS
408: SELECT 'X'
409: FROM
410: ahl_workorders wo, ahl_visit_tasks_b vts, wip_discrete_jobs wdj
411: WHERE
412: wdj.wip_entity_id = c_wip_entity_id
413: AND wo.wip_entity_id = wdj.wip_entity_id
414: AND wo.status_code NOT IN (7, 22, 17, 12, 18, 21, 4, 5) -- cancelled, deleted, draft, closed,Deffered,Pending Defer/Cancel Approval, Complete, Complete No-charge