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_HEADERS_APP_V

Line 1428: FROM AHL_MR_HEADERS_APP_V

1424: SELECT MR_HEADER_ID, RELATED_MR_HEADER_ID
1425: FROM AHL_MR_RELATIONSHIPS
1426: START WITH MR_HEADER_ID = (
1427: SELECT MR_HEADER_ID
1428: FROM AHL_MR_HEADERS_APP_V
1429: WHERE MR_HEADER_ID = x_MR_id)
1430: CONNECT BY PRIOR RELATED_MR_HEADER_ID = MR_HEADER_ID;
1431: relation_rec c_relationship%ROWTYPE;
1432:

Line 1960: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV

1956:
1957: -- To find any visit task exists for the retrieve Serial Number, Unit Effectivity ID and MR Route ID and other info
1958: CURSOR c_task_chk (x_id IN NUMBER, x_mr_id IN NUMBER, x_serial_id in NUMBER) IS
1959: SELECT AMHV.Title
1960: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV
1961: WHERE AVTB.MR_ID = AMHV.MR_HEADER_ID
1962: AND AVTB.MR_Id = x_mr_id
1963: AND AVTB.Instance_Id = x_serial_id
1964: AND AVTB.VISIT_ID = x_id