APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ROUTES_APP_V

Line 3228: FROM ahl_routes_app_v

3224: IS
3225:
3226: CURSOR get_route_status(c_route_id number) IS
3227: SELECT revision_status_code
3228: FROM ahl_routes_app_v
3229: WHERE route_id = c_route_id;
3230: l_route_status_code VARCHAR2(30);
3231:
3232: BEGIN

Line 3459: ahl_routes_app_v rou

3455: AND res.object_id IN
3456: (SELECT oper.operation_id
3457: FROM ahl_operations_b oper ,
3458: ahl_route_operations ass ,
3459: ahl_routes_app_v rou
3460: WHERE
3461: (
3462: TRUNC(nvl(c_rou_start_date,rou.start_date_active)) >= TRUNC(oper.start_date_active)
3463: AND

Line 3486: FROM ahl_operations_b oper, ahl_route_operations ass , ahl_routes_app_v rou

3482: WHERE res.association_type_code = 'OPERATION'
3483: AND res.scheduled_type_id = 1
3484: AND res.object_id IN
3485: (SELECT oper.operation_id
3486: FROM ahl_operations_b oper, ahl_route_operations ass , ahl_routes_app_v rou
3487: WHERE (
3488: TRUNC(nvl(c_rou_start_date,rou.start_date_active)) >= TRUNC(oper.start_date_active)
3489: AND
3490: TRUNC(NVL(oper.end_date_active, nvl(c_rou_start_date,rou.start_date_active) + 1)) > TRUNC(nvl(c_rou_start_date,rou.start_date_active))

Line 3632: FROM AHL_ROUTES_APP_V

3628:
3629: CURSOR get_route_time_span( c_route_id NUMBER )
3630: IS
3631: SELECT time_span
3632: FROM AHL_ROUTES_APP_V
3633: WHERE route_id = c_route_id;
3634:
3635: -- Bug # 8639648 -- start
3636: CURSOR get_op_route_time_span( c_operation_id NUMBER )

Line 3639: FROM AHL_ROUTES_APP_V RT ,

3635: -- Bug # 8639648 -- start
3636: CURSOR get_op_route_time_span( c_operation_id NUMBER )
3637: IS
3638: SELECT MIN( RT.time_span )
3639: FROM AHL_ROUTES_APP_V RT ,
3640: AHL_ROUTE_OPERATIONS ASS,
3641: AHL_OPERATIONS_B oper
3642: WHERE ( TRUNC(RT.start_date_active) >= TRUNC(oper.start_date_active)
3643: AND TRUNC(NVL(oper.end_date_active, RT.start_date_active + 1)) > TRUNC(RT.start_date_active)

Line 3713: FROM AHL_ROUTES_APP_V

3709: /*
3710: CURSOR get_route_time_span( c_route_id NUMBER )
3711: IS
3712: SELECT time_span
3713: FROM AHL_ROUTES_APP_V
3714: WHERE route_id = c_route_id;
3715: */
3716: -- Validate operation duration against route duration only
3717: -- if the operation active start date is after route active start date

Line 3721: FROM AHL_ROUTES_APP_V rou,

3717: -- if the operation active start date is after route active start date
3718: CURSOR get_route_time_span(c_route_id NUMBER, c_operation_id NUMBER)
3719: IS
3720: SELECT rou.time_span
3721: FROM AHL_ROUTES_APP_V rou,
3722: AHL_OPERATIONS_B oper
3723: WHERE (
3724: TRUNC(rou.start_date_active) >= TRUNC(oper.start_date_active)
3725: AND

Line 3795: FROM AHL_ROUTES_APP_V A, AHL_ROUTES_APP_V B

3791:
3792: CURSOR get_rt_latest_start_date( c_route_id NUMBER )
3793: IS
3794: SELECT MAX( A.start_date_active )
3795: FROM AHL_ROUTES_APP_V A, AHL_ROUTES_APP_V B
3796: WHERE A.route_no = B.route_no
3797: AND A.route_id <> c_route_id
3798: AND B.route_id = c_route_id;
3799:

Line 4233: FROM ahl_routes_app_v

4229: -- Cursor for selecting route id.
4230: CURSOR route_name_rev_csr_type (p_route_number IN VARCHAR2, p_route_revision IN NUMBER)
4231: IS
4232: SELECT route_id
4233: FROM ahl_routes_app_v
4234: WHERE UPPER( TRIM(route_no)) = UPPER(TRIM(p_route_number))
4235: AND
4236: revision_number = p_route_revision;
4237: