APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_RT_OPER_RESOURCES

Line 3399: FROM AHL_RT_OPER_RESOURCES

3395: /*
3396: CURSOR get_max_rt_resource_duration( c_route_id NUMBER )
3397: IS
3398: SELECT MAX( duration )
3399: FROM AHL_RT_OPER_RESOURCES
3400: WHERE association_type_code = 'ROUTE'
3401: AND object_id = c_route_id
3402: AND scheduled_type_id = 1;
3403: */

Line 3407: FROM AHL_RT_OPER_RESOURCES

3403: */
3404: CURSOR get_max_rt_resource_duration( c_route_id NUMBER )
3405: IS
3406: SELECT SUM(MAX(duration))
3407: FROM AHL_RT_OPER_RESOURCES
3408: WHERE association_type_code = 'ROUTE'
3409: AND object_id = c_route_id
3410: GROUP BY schedule_seq ;
3411: -- Bug # 7644260 (FP for ER # 6998882) -- end

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

3415: /*
3416: CURSOR get_max_op_resource_duration( c_route_id NUMBER )
3417: IS
3418: SELECT MAX( RES.duration )
3419: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS
3420: WHERE RES.association_type_code = 'OPERATION'
3421: AND RES.object_id = ASS.operation_id
3422: AND NVL( OPER.end_date_active , TRUNC( SYSDATE ) + 1 ) > TRUNC( SYSDATE )
3423: AND OPER.operation_id = ASS.operation_id

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

3429: IS
3430: SELECT SUM(OPR_DURATION)
3431: FROM
3432: (SELECT RES.object_id,RES.schedule_seq, MAX(duration) "OPR_DURATION"
3433: FROM AHL_RT_OPER_RESOURCES RES, AHL_OPERATIONS_B OPER, AHL_ROUTE_OPERATIONS ASS
3434: WHERE RES.association_type_code = 'OPERATION'
3435: AND RES.object_id = ASS.operation_id
3436: AND NVL( OPER.end_date_active , TRUNC( SYSDATE ) + 1 ) > TRUNC( SYSDATE )
3437: AND OPER.operation_id = ASS.operation_id

Line 3452: FROM ahl_rt_oper_resources res

3448: FROM ( SELECT SUM(RES_DURATION) OPER_DURATION,
3449: object_id
3450: FROM (SELECT MAX(res.duration) RES_DURATION,
3451: res.object_id
3452: FROM ahl_rt_oper_resources res
3453: WHERE res.association_type_code = 'OPERATION'
3454: AND res.scheduled_type_id = 1
3455: AND res.object_id IN
3456: (SELECT oper.operation_id

Line 3481: FROM ahl_rt_oper_resources res

3477: IS
3478: SELECT route_operation_id, oper_duration
3479: FROM ( SELECT SUM(RES_DURATION) OPER_DURATION, object_id
3480: FROM (SELECT MAX(res.duration) RES_DURATION, res.object_id
3481: FROM ahl_rt_oper_resources res
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

Line 3740: FROM AHL_RT_OPER_RESOURCES

3736: CURSOR get_op_max_duration( c_operation_id NUMBER )
3737: IS
3738: SELECT NVL(SUM(RES_DURATION),0)
3739: FROM ( SELECT MAX( duration ) RES_DURATION
3740: FROM AHL_RT_OPER_RESOURCES
3741: WHERE association_type_code = 'OPERATION'
3742: AND scheduled_type_id = 1
3743: AND object_id = c_operation_id
3744: GROUP BY schedule_seq