APPS.AHL_CMP_UTIL_PKG dependencies on WIP_DISCRETE_JOBS

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)