APPS.AHL_CMP_UTIL_PKG dependencies on AHL_WORKORDERS

Line 462: FROM AHL_WORKORDERS

458: -- Cursor to check if the given repair batch has atleast one open RTS workorder
459: CURSOR Chk_Rts_Workorder(c_repair_batch VARCHAR2, c_ins_id NUMBER)
460: IS
461: SELECT 'x'
462: FROM AHL_WORKORDERS
463: WHERE status_code NOT IN ('7','12','17','22' ) -- Cancelled,Closed,Draft and Deleted
464: AND visit_task_id IN
465: (SELECT vt.visit_task_id
466: FROM AHL_VISIT_TASKS_B vt

Line 597: AHL_WORKORDERS WO

593: CURSOR Get_Ins_Qty(C_VISIT_TASK_ID NUMBER)
594: IS
595: SELECT CII.QUANTITY
596: FROM CSI_ITEM_INSTANCES CII,
597: AHL_WORKORDERS WO
598: where WO.visit_task_id = c_visit_task_id
599: AND CII.location_type_code = 'WIP'
600: and CII.wip_job_id = WO.wip_entity_id
601: AND TRUNC(NVL(CII.ACTIVE_START_DATE, SYSDATE)) <= TRUNC(SYSDATE)

Line 760: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ

756: p_start_date DATE,
757: p_end_date DATE,
758: p_comp_visit_flag VARCHAR2) IS
759: SELECT SUM(task.quantity) plan_qty, task.instance_id FROM ahl_visit_tasks_b task,
760: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ
761: WHERE
762: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
763: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
764: AND WO.STATUS_CODE IN (1,3,6,17,19,20)

Line 786: ahl_workorders wo,WIP_DISCRETE_JOBS WDJ

782: p_start_date DATE,
783: p_end_date DATE,
784: p_comp_visit_flag VARCHAR2) IS
785: SELECT 'Y' FROM ahl_visit_tasks_b task,
786: ahl_workorders wo,WIP_DISCRETE_JOBS WDJ
787: WHERE
788: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
789: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
790: AND WO.STATUS_CODE IN (1,3,6,17,19,20)

Line 871: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ

867: p_start_date DATE,
868: p_end_date DATE,
869: p_comp_visit_flag VARCHAR2) IS
870: SELECT SUM(task.quantity) sched_qty FROM ahl_visit_tasks_b task,
871: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ
872: WHERE
873: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
874: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
875: AND WO.STATUS_CODE IN (1,3,6,17,19,20)

Line 939: FROM AHL_WORKORDERS

935: -- Cursor to check if all the workorders associated to a given repair batch are Complete.
936: CURSOR Chk_Complete_Workorders(c_repair_batch VARCHAR2, c_ins_id NUMBER)
937: IS
938: SELECT 'x'
939: FROM AHL_WORKORDERS
940: WHERE status_code NOT IN ('4','12','7','5','17' ) -- Complete,Closed,Cancelled,Complete-No-Charge and Draft
941: AND visit_task_id IN
942: (SELECT visit_task_id
943: FROM AHL_VISIT_TASKS_B vt