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_VISITS_VL

Line 1164: FROM ahl_visits_vl

1160:
1161: CURSOR Visit_Valid_Cur(c_visit_id IN NUMBER)
1162: IS
1163: SELECT 1
1164: FROM ahl_visits_vl
1165: WHERE visit_id = C_VISIT_ID
1166: AND (organization_id IS NULL
1167: OR start_date_time IS NULL);
1168:

Line 1490: FROM ahl_visits_vl vs,

1486: vt.instance_id,
1487: nvl(vt.start_date_time,vs.start_date_time) start_date_time,
1488: mr.route_id
1489:
1490: FROM ahl_visits_vl vs,
1491: ahl_visit_tasks_vl vt,
1492: ahl_mr_routes_app_v mr
1493: WHERE vs.visit_id = vt.visit_id
1494: AND vt.mr_route_id = mr.mr_route_id

Line 2636: FROM ahl_visits_vl vs,

2632: IS
2633: SELECT vs.visit_id,
2634: vs.organization_id,
2635: vt.visit_task_id
2636: FROM ahl_visits_vl vs,
2637: ahl_visit_tasks_vl vt
2638: WHERE vs.visit_id = vt.visit_id
2639: AND vs.visit_id = c_visit_id
2640: AND vt.visit_task_id = c_visit_task_id;