APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_ROUTES_APP_V

Line 2251: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr

2247:
2248: -- To find Route related Information
2249: CURSOR c_route (c_id IN NUMBER) IS
2250: SELECT ra.*
2251: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr
2252: WHERE ra.route_id = mrr.route_id AND
2253: mrr.mr_route_id = c_id AND
2254: ra.revision_status_code = 'COMPLETE';
2255:

Line 2508: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

2504: c_mr_header_rec c_mr_header%ROWTYPE;
2505:
2506: -- To find route related information
2507: /* CURSOR c_route (x_id IN NUMBER) IS
2508: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
2509: WHERE T1.ROUTE_ID = T2.ROUTE_ID
2510: AND T2.MR_ROUTE_ID = x_id
2511: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
2512: */

Line 2515: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

2511: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
2512: */
2513: CURSOR c_route (x_id IN NUMBER) IS
2514: SELECT T1.START_DATE_ACTIVE,T1.END_DATE_ACTIVE
2515: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
2516: WHERE T1.ROUTE_ID = T2.ROUTE_ID
2517: AND T2.MR_ROUTE_ID = x_id
2518: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
2519: c_route_rec c_route%ROWTYPE;

Line 2532: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B

2528: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED')
2529: AND VT.MR_Route_ID IS NOT NULL
2530: AND NOT EXISTS (
2531: SELECT 1
2532: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B
2533: WHERE T1.MR_ROUTE_ID = VT.MR_ROUTE_ID
2534: AND T1.MR_HEADER_ID = B.MR_HEADER_ID
2535: AND T1.ROUTE_ID = T2.ROUTE_ID
2536: AND T2.REVISION_STATUS_CODE = 'COMPLETE');