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 329: FROM AHL_ROUTES_B

325: STAGE
326: FROM AHL_MR_ROUTES A
327: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
328: AND ROUTE_ID IN (SELECT ROUTE_ID
329: FROM AHL_ROUTES_B
330: WHERE ROUTE_ID=A.ROUTE_ID
331: AND NVL(END_DATE_ACTIVE,sysdate+1)>SYSDATE
332: AND REVISION_STATUS_CODE='COMPLETE'
333: );

Line 374: FROM AHL_ROUTES_B

370: FROM AHL_MR_ROUTES A
371: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
372: AND MR_ROUTE_ID=C.RELATED_MR_ROUTE_ID
373: AND ROUTE_ID IN (SELECT ROUTE_ID
374: FROM AHL_ROUTES_B
375: WHERE ROUTE_ID=A.ROUTE_ID
376: AND NVL(END_DATE_ACTIVE,sysdate+1)>SYSDATE
377: AND REVISION_STATUS_CODE='COMPLETE'
378: )