APPS.AHL_UMP_NONROUTINES_PVT dependencies on WIP_DISCRETE_JOBS

Line 3371: from ahl_workorders wo, ahl_visit_tasks_b tsk, wip_discrete_jobs wdj,

3367: CURSOR GetWoName(p_ue_id IN NUMBER)
3368: Is
3369: Select wo.workorder_name, tsk.visit_id,
3370: wdj.scheduled_start_date, vst.close_date_time
3371: from ahl_workorders wo, ahl_visit_tasks_b tsk, wip_discrete_jobs wdj,
3372: ahl_visits_b vst
3373: where wo.visit_task_id = tsk.visit_task_id
3374: and tsk.visit_id = vst.visit_id
3375: and wdj.wip_entity_id = wo.wip_entity_id