APPS.AHL_UMP_UTIL_PKG dependencies on WIP_DISCRETE_JOBS
Line 132: FROM wip_discrete_jobs
128:
129: -- added to get MWO dates when UE is on the shop floor.
130: CURSOR get_wo_dt (p_unit_effectivity_id IN NUMBER) IS
131: SELECT max(scheduled_completion_date) 132: FROM wip_discrete_jobs 133: WHERE wip_entity_id IN (select wip_entity_id
134: from ahl_workorders awo, ahl_visit_tasks_b tsk
135: where awo.visit_task_id = tsk.visit_task_id
136: and tsk.task_type_code <> 'SUMMARY'