APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ROUTE_OPERATIONS

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 3371: FROM AHL_ROUTES_APP_V RT, AHL_ROUTE_OPERATIONS ASS

3367:
3368: CURSOR get_op_route_time_span( c_operation_id NUMBER )
3369: IS
3370: SELECT MIN( RT.time_span )
3371: FROM AHL_ROUTES_APP_V RT, AHL_ROUTE_OPERATIONS ASS
3372: WHERE TRUNC ( NVL ( RT.end_date_active , SYSDATE + 1 ) ) > TRUNC( SYSDATE )
3373: AND RT.route_id = ASS.route_id
3374: AND ASS.operation_id = c_operation_id;
3375: