APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_ROUTES_APP_V

Line 4103: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr

4099:
4100: -- To find Route related Information
4101: CURSOR c_route (c_id IN NUMBER) IS
4102: SELECT ra.*
4103: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr
4104: WHERE ra.route_id = mrr.route_id AND
4105: mrr.mr_route_id = c_id AND
4106: ra.revision_status_code = 'COMPLETE';
4107:

Line 4300: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr

4296:
4297: -- To find Route related Information
4298: CURSOR c_route (c_id IN NUMBER) IS
4299: SELECT ra.*
4300: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr
4301: WHERE ra.route_id = mrr.route_id AND
4302: mrr.mr_route_id = c_id AND
4303: ra.revision_status_code = 'COMPLETE';
4304:

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

4547: c_mr_header_rec c_mr_header%ROWTYPE;
4548:
4549: -- To find route related information
4550: /* CURSOR c_route (x_id IN NUMBER) IS
4551: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
4552: WHERE T1.ROUTE_ID = T2.ROUTE_ID
4553: AND T2.MR_ROUTE_ID = x_id
4554: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4555: */

Line 4558: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

4554: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4555: */
4556: CURSOR c_route (x_id IN NUMBER) IS
4557: SELECT T1.START_DATE_ACTIVE,T1.END_DATE_ACTIVE
4558: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
4559: WHERE T1.ROUTE_ID = T2.ROUTE_ID
4560: AND T2.MR_ROUTE_ID = x_id
4561: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4562: c_route_rec c_route%ROWTYPE;

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

4574: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED','CLOSED')
4575: AND VT.MR_Route_ID IS NOT NULL
4576: AND NOT EXISTS (
4577: SELECT 1
4578: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B
4579: WHERE T1.MR_ROUTE_ID = VT.MR_ROUTE_ID
4580: AND T1.MR_HEADER_ID = B.MR_HEADER_ID
4581: AND T1.ROUTE_ID = T2.ROUTE_ID
4582: AND T2.REVISION_STATUS_CODE = 'COMPLETE');