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_UTIL_PKG dependencies on AHL_SIMULATION_PLANS_B

Line 116: from ahl_visits_b vst1, ahl_simulation_plans_b sim

112: -- 11.5.10CU2: Ignore simulation visits.
113: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
114: SELECT vst.start_date_time, vst.visit_id, tsk.status_code
115: FROM ahl_visit_tasks_b tsk, (select vst1.*
116: from ahl_visits_b vst1, ahl_simulation_plans_b sim
117: where vst1.simulation_plan_id = sim.simulation_plan_id
118: and sim.primary_plan_flag = 'Y'
119: UNION ALL
120: select vst1.*

Line 227: from ahl_visits_b vst1, ahl_simulation_plans_b sim

223: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
224:
225: SELECT decode(vst.status_code,'CLOSED', vst.status_code, tsk.status_code)
226: FROM ahl_visit_tasks_b tsk, (select vst1.*
227: from ahl_visits_b vst1, ahl_simulation_plans_b sim
228: where vst1.simulation_plan_id = sim.simulation_plan_id
229: and sim.primary_plan_flag = 'Y'
230: UNION ALL
231: select vst1.*

Line 1607: FROM AHL_SIMULATION_PLANS_B

1603:
1604:
1605: CURSOR get_primary_plan IS
1606: SELECT simulation_plan_id
1607: FROM AHL_SIMULATION_PLANS_B
1608: WHERE primary_plan_flag = 'Y'
1609: AND status_code = 'ACTIVE'
1610: AND nvl(simulation_type,'UMP') = 'UMP';
1611: