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.

[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 1648: FROM AHL_MR_HEADERS_APP_V

1644: SELECT MR_HEADER_ID, RELATED_MR_HEADER_ID
1645: FROM AHL_MR_RELATIONSHIPS
1646: START WITH MR_HEADER_ID = (
1647: SELECT MR_HEADER_ID
1648: FROM AHL_MR_HEADERS_APP_V
1649: WHERE MR_HEADER_ID = x_MR_id)
1650: CONNECT BY PRIOR RELATED_MR_HEADER_ID = MR_HEADER_ID;
1651: relation_rec c_relationship%ROWTYPE;
1652:

Line 2238: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV

2234:
2235: -- To find any visit task exists for the retrieve Serial Number, Unit Effectivity ID and MR Route ID and other info
2236: CURSOR c_task_chk (x_id IN NUMBER, x_mr_id IN NUMBER, x_serial_id in NUMBER) IS
2237: SELECT AMHV.Title
2238: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV
2239: WHERE AVTB.MR_ID = AMHV.MR_HEADER_ID
2240: AND AVTB.MR_Id = x_mr_id
2241: AND AVTB.Instance_Id = x_serial_id
2242: AND AVTB.VISIT_ID = x_id