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_FMP_MR_REVISION_PVT dependencies on AHL_ROUTES_B

Line 337: FROM AHL_ROUTES_B

333: STAGE
334: FROM AHL_MR_ROUTES A
335: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
336: AND ROUTE_ID IN (SELECT ROUTE_ID
337: FROM AHL_ROUTES_B
338: WHERE ROUTE_ID=A.ROUTE_ID
339: AND NVL(END_DATE_ACTIVE,sysdate+1)>SYSDATE
340: AND REVISION_STATUS_CODE='COMPLETE'
341: );

Line 382: FROM AHL_ROUTES_B

378: FROM AHL_MR_ROUTES A
379: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
380: AND MR_ROUTE_ID=C.RELATED_MR_ROUTE_ID
381: AND ROUTE_ID IN (SELECT ROUTE_ID
382: FROM AHL_ROUTES_B
383: WHERE ROUTE_ID=A.ROUTE_ID
384: AND NVL(END_DATE_ACTIVE,sysdate+1)>SYSDATE
385: AND REVISION_STATUS_CODE='COMPLETE'
386: )