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_VWP_RULES_PVT dependencies on AHL_ROUTES_VL

Line 1160: FROM ahl_routes_vl ar, ahl_mr_routes mrr

1156: /*Bug 5758813 - rnahata - Route title and route remarks should be passed
1157: to visit as visit task name and visit task description*/
1158: CURSOR c_route_title(c_mr_route_id IN NUMBER) IS
1159: SELECT substr(ar.title,1,80), ar.remarks
1160: FROM ahl_routes_vl ar, ahl_mr_routes mrr
1161: WHERE mrr.mr_route_id = c_mr_route_id
1162: AND mrr.route_id = ar.route_id;
1163:
1164: -- Local variables defined for the procedure

Line 1180: l_description ahl_routes_vl.remarks%TYPE; --Bug 5758813

1176: l_item_org_id NUMBER;
1177: l_serial_id NUMBER;
1178: l_mr_id NUMBER;
1179: l_mr_route_id NUMBER;
1180: l_description ahl_routes_vl.remarks%TYPE; --Bug 5758813
1181:
1182: BEGIN
1183: IF (l_log_procedure >= l_log_current_level) THEN
1184: fnd_log.string(l_log_procedure,