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_RM_ROUTE_PVT dependencies on AHL_ROUTES_APP_V

Line 1620: from ahl_routes_app_v

1616:
1617: cursor validate_route_ovn
1618: is
1619: select 'x'
1620: from ahl_routes_app_v
1621: where route_id = p_route_rec.route_id and
1622: object_version_number = p_route_rec.object_version_number;
1623:
1624: l_dummy VARCHAR2(1);

Line 1787: FROM AHL_ROUTES_APP_V

1783:
1784: CURSOR get_dup_rec( c_route_no VARCHAR2 , c_revision_number NUMBER )
1785: IS
1786: SELECT route_id
1787: FROM AHL_ROUTES_APP_V
1788: WHERE UPPER(TRIM(route_no)) = UPPER(TRIM(c_route_no))
1789: AND revision_number = nvl(c_revision_number,1);
1790:
1791: BEGIN

Line 2547: from ahl_routes_app_v

2543:
2544: cursor validate_route_ovn
2545: is
2546: select 'x'
2547: from ahl_routes_app_v
2548: where route_id = p_route_id and
2549: object_version_number = p_object_version_number;
2550:
2551: --bachandr Enigma Phase I changes -- start

Line 2885: FROM AHL_ROUTES_APP_V

2881:
2882: CURSOR get_latest_revision( c_route_no VARCHAR2 )
2883: IS
2884: SELECT MAX( revision_number )
2885: FROM AHL_ROUTES_APP_V
2886: WHERE UPPER(TRIM(route_no)) = UPPER(TRIM(c_route_no));
2887:
2888: CURSOR get_doc_associations( c_route_id NUMBER )
2889: IS