eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ROUTE_OPERATIONS

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 3458: ahl_route_operations ass ,

3454: AND res.scheduled_type_id = 1
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)

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 3497: ) res, ahl_route_operations ro

3493: AND oper.operation_id = ass.operation_id
3494: AND ass.route_id = c_route_id
3495: ) GROUP BY res.object_id, res.schedule_seq
3496: ) GROUP BY object_id
3497: ) res, ahl_route_operations ro
3498: WHERE res.object_id = ro.operation_id
3499: AND ro.route_id = c_route_id ;
3500:
3501: -- Balaji modified dependency_code from 3 to STARTSAFTEREND for Bug # 13770494

Line 3508: FROM ahl_route_operations

3504: SELECT SYS_CONNECT_BY_PATH(from_rt_op_id,'|')||'|'||to_rt_op_id Path
3505: FROM ahl_rt_oper_dependencies od
3506: WHERE dependency_code = 'STARTSAFTEREND' AND from_rt_op_id
3507: IN ( SELECT route_operation_id
3508: FROM ahl_route_operations
3509: WHERE ROUTE_ID =c_route_id
3510: AND route_operation_id =od.from_rt_op_id
3511: )
3512: START WITH from_rt_op_id = c_from_rt_op_id

Line 3640: AHL_ROUTE_OPERATIONS ASS,

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)
3644: )