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 1625: SELECT COUNT(*) FROM AHL_MR_ROUTE_SEQUENCES_APP_V

1621:
1622: -- Define local variables
1623: -- To find out the count for the relationship with MR Route Id
1624: CURSOR c_route_seq_ct (x_route_id IN NUMBER) IS
1625: SELECT COUNT(*) FROM AHL_MR_ROUTE_SEQUENCES_APP_V
1626: WHERE MR_ROUTE_ID = x_route_id;
1627:
1628: -- To find out the the relationship between MR Route Id and Related MR Route Id
1629: CURSOR c_route_seq (x_route_id IN NUMBER) IS

Line 1630: SELECT MR_ROUTE_ID, RELATED_MR_ROUTE_ID FROM AHL_MR_ROUTE_SEQUENCES_APP_V

1626: WHERE MR_ROUTE_ID = x_route_id;
1627:
1628: -- To find out the the relationship between MR Route Id and Related MR Route Id
1629: CURSOR c_route_seq (x_route_id IN NUMBER) IS
1630: SELECT MR_ROUTE_ID, RELATED_MR_ROUTE_ID FROM AHL_MR_ROUTE_SEQUENCES_APP_V
1631: WHERE MR_ROUTE_ID = x_route_id;
1632: c_route_seq_rec c_route_seq%ROWTYPE;
1633:
1634: -- To find out the tasks with tasktype code as planned for visits