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_MR_ROUTE_SEQUENCES_APP_V

Line 1854: SELECT COUNT(*) FROM AHL_MR_ROUTE_SEQUENCES_APP_V

1850:
1851: -- Define local variables
1852: -- To find out the count for the relationship with MR Route Id
1853: CURSOR c_route_seq_ct (x_route_id IN NUMBER) IS
1854: SELECT COUNT(*) FROM AHL_MR_ROUTE_SEQUENCES_APP_V
1855: WHERE MR_ROUTE_ID = x_route_id;
1856:
1857: -- To find out the the relationship between MR Route Id and Related MR Route Id
1858: CURSOR c_route_seq (x_route_id IN NUMBER) IS

Line 1859: SELECT MR_ROUTE_ID, RELATED_MR_ROUTE_ID FROM AHL_MR_ROUTE_SEQUENCES_APP_V

1855: WHERE MR_ROUTE_ID = x_route_id;
1856:
1857: -- To find out the the relationship between MR Route Id and Related MR Route Id
1858: CURSOR c_route_seq (x_route_id IN NUMBER) IS
1859: SELECT MR_ROUTE_ID, RELATED_MR_ROUTE_ID FROM AHL_MR_ROUTE_SEQUENCES_APP_V
1860: WHERE MR_ROUTE_ID = x_route_id;
1861: c_route_seq_rec c_route_seq%ROWTYPE;
1862:
1863: -- To find out the tasks with tasktype code as planned for visits