APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_RT_OPER_RESOURCES

Line 3266: FROM AHL_RT_OPER_RESOURCES

3262: /*
3263: CURSOR get_max_rt_resource_duration( c_route_id NUMBER )
3264: IS
3265: SELECT MAX( duration )
3266: FROM AHL_RT_OPER_RESOURCES
3267: WHERE association_type_code = 'ROUTE'
3268: AND object_id = c_route_id
3269: AND scheduled_type_id = 1;
3270: */

Line 3274: FROM AHL_RT_OPER_RESOURCES

3270: */
3271: CURSOR get_max_rt_resource_duration( c_route_id NUMBER )
3272: IS
3273: SELECT SUM(MAX(duration))
3274: FROM AHL_RT_OPER_RESOURCES
3275: WHERE association_type_code = 'ROUTE'
3276: AND object_id = c_route_id
3277: GROUP BY schedule_seq ;
3278: -- Bug # 7644260 (FP for ER # 6998882) -- end

Line 3286: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS

3282: /*
3283: CURSOR get_max_op_resource_duration( c_route_id NUMBER )
3284: IS
3285: SELECT MAX( RES.duration )
3286: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS
3287: WHERE RES.association_type_code = 'OPERATION'
3288: AND RES.object_id = ASS.operation_id
3289: AND NVL( OPER.end_date_active , TRUNC( SYSDATE ) + 1 ) > TRUNC( SYSDATE )
3290: AND OPER.operation_id = ASS.operation_id

Line 3299: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS

3295: IS
3296: SELECT SUM(OPR_DURATION)
3297: FROM
3298: (SELECT RES.object_id,RES.schedule_seq, MAX(duration) "OPR_DURATION"
3299: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS
3300: WHERE RES.association_type_code = 'OPERATION'
3301: AND RES.object_id = ASS.operation_id
3302: AND NVL( OPER.end_date_active , TRUNC( SYSDATE ) + 1 ) > TRUNC( SYSDATE )
3303: AND OPER.operation_id = ASS.operation_id

Line 3445: FROM AHL_RT_OPER_RESOURCES

3441: -- Fix for bug# 6512803. Consider only scheduled resources.
3442: CURSOR get_op_max_duration( c_operation_id NUMBER )
3443: IS
3444: SELECT MAX( duration )
3445: FROM AHL_RT_OPER_RESOURCES
3446: WHERE association_type_code = 'OPERATION'
3447: AND scheduled_type_id = 1
3448: AND object_id = c_operation_id;
3449: