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 1839: from ahl_routes_app_v

1835:
1836: cursor validate_route_ovn
1837: is
1838: select 'x'
1839: from ahl_routes_app_v
1840: where route_id = p_route_rec.route_id and
1841: object_version_number = p_route_rec.object_version_number;
1842:
1843: l_dummy VARCHAR2(1);

Line 2010: FROM AHL_ROUTES_APP_V

2006:
2007: CURSOR get_dup_rec( c_route_no VARCHAR2 , c_revision_number NUMBER )
2008: IS
2009: SELECT route_id
2010: FROM AHL_ROUTES_APP_V
2011: WHERE UPPER(TRIM(route_no)) = UPPER(TRIM(c_route_no))
2012: AND revision_number = nvl(c_revision_number,1);
2013:
2014: BEGIN

Line 2866: from ahl_routes_app_v

2862:
2863: cursor validate_route_ovn
2864: is
2865: select 'x'
2866: from ahl_routes_app_v
2867: where route_id = p_route_id and
2868: object_version_number = p_object_version_number;
2869:
2870: --bachandr Enigma Phase I changes -- start

Line 3216: FROM AHL_ROUTES_APP_V

3212:
3213: CURSOR get_latest_revision( c_route_no VARCHAR2 )
3214: IS
3215: SELECT MAX( revision_number )
3216: FROM AHL_ROUTES_APP_V
3217: WHERE UPPER(TRIM(route_no)) = UPPER(TRIM(c_route_no));
3218:
3219: CURSOR get_doc_associations( c_route_id NUMBER )
3220: IS