eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_WORKORDERS

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

Line 3483: l_wo_name ahl_workorders.workorder_name%TYPE;

3479: l_msg_count NUMBER;
3480: l_msg_data VARCHAR2(2000);
3481: l_summary VARCHAR2(2000); --cs_incidents_all_b.summary%TYPE;
3482:
3483: l_wo_name ahl_workorders.workorder_name%TYPE;
3484: l_individual_owner NUMBER;
3485: l_group_owner NUMBER;
3486: l_individual_type VARCHAR2(30);
3487: