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_ROUTE_SEQNCE_PVT dependencies on AHL_ROUTES_APP_V

Line 486: From AHL_ROUTES_APP_V

482: as
483: CURSOR get_route_frm(c_route_no VARCHAR2, c_revision_number NUMBER)
484: IS
485: Select ROUTE_ID
486: From AHL_ROUTES_APP_V
487: WHERE UPPER(LTRIM(RTRIM(ROUTE_NO)))=UPPER(LTRIM(RTRIM(C_ROUTE_NO)))
488: AND NVL(END_DATE_ACTIVE,SYSDATE+1) >SYSDATE
489: AND revision_number = c_revision_number;
490:

Line 723: FROM AHL_ROUTES_APP_V

719: CURSOR get_mr_route_id_type(p_mr_header_id NUMBER, p_route_no VARCHAR2, p_route_revision NUMBER) IS
720: SELECT mr_route_id
721: FROM AHL_MR_ROUTES_APP_V
722: WHERE route_id = (SELECT route_id
723: FROM AHL_ROUTES_APP_V
724: WHERE route_no = p_route_no
725: AND revision_number = p_route_revision)
726: AND mr_header_id = p_mr_header_id;
727: