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

Line 135: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR

131: */
132: CURSOR ue_mr_routes_csr (p_item_indtance_id IN NUMBER) IS
133: SELECT UE.unit_effectivity_id, UE.due_date, MR.mr_route_id, R.route_id, R.start_date_active, R.end_date_active
134: -- FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, AHL_MR_ROUTES_V MR
135: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR
136: WHERE UE.mr_header_id = MR.mr_header_id
137: AND R.route_id = MR.ROUTE_ID
138: --AND MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))
139: AND UE.APPLICATION_USG_CODE = G_APP_MODULE

Line 626: FROM AHL_MR_ROUTES rt, ahl_routes_b R

622:
623: -- get mr_route and route_id for a mr_header.
624: CURSOR ahl_mr_route_csr(p_mr_header_id IN NUMBER) IS
625: SELECT rt.mr_route_id, rt.route_id, R.start_date_active, R.end_date_active
626: FROM AHL_MR_ROUTES rt, ahl_routes_b R
627: WHERE rt.route_id = r.route_id
628: AND rt.mr_header_id = p_mr_header_id;
629:
630: -- get mr headers