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_LTP_REQST_MATRL_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1512: ahl_visit_tasks_vl vt,

1508: vt.instance_id,
1509: NVL(vt.start_date_time,vs.start_date_time) start_date_time,
1510: mr.route_id
1511: FROM ahl_visits_vl vs,
1512: ahl_visit_tasks_vl vt,
1513: ahl_mr_routes_app_v mr
1514: WHERE vs.visit_id = vt.visit_id
1515: AND vt.mr_route_id = mr.mr_route_id
1516: AND vt.unit_effectivity_id = nvl2(p_ue_id,-1,vt.unit_effectivity_id)

Line 1527: ahl_visit_tasks_vl vt,

1523: vt.instance_id,
1524: NVL(vt.start_date_time,vs.start_date_time) start_date_time,
1525: mr.route_id
1526: FROM ahl_visits_vl vs,
1527: ahl_visit_tasks_vl vt,
1528: ahl_mr_routes_app_v mr
1529: WHERE vs.visit_id = vt.visit_id
1530: AND vt.mr_route_id = mr.mr_route_id
1531: AND vt.unit_effectivity_id IN

Line 2650: ahl_visit_tasks_vl vt

2646: SELECT vs.visit_id,
2647: vs.organization_id,
2648: vt.visit_task_id
2649: FROM ahl_visits_vl vs,
2650: ahl_visit_tasks_vl vt
2651: WHERE vs.visit_id = vt.visit_id
2652: AND vs.visit_id = c_visit_id
2653: AND vt.visit_task_id = c_visit_task_id;
2654: --To Retrieve visit task planned materials