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_OPERATIONS_B

Line 11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,

7: PROCEDURE validate_operation
8: (
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,
12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE
13: )
14: IS
15:

Line 12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE

8: (
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_concatenated_segments IN AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE,
12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE
13: )
14: IS
15:
16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;

Line 16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;

12: p_x_operation_id IN OUT NOCOPY AHL_OPERATIONS_B.operation_id%TYPE
13: )
14: IS
15:
16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;
17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id

Line 18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )

14: IS
15:
16: l_operation_id AHL_OPERATIONS_B.operation_id%TYPE;
17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;

Line 21: FROM AHL_OPERATIONS_B_KFV

17:
18: CURSOR get_rec_from_value ( c_concatenated_segments AHL_OPERATIONS_B_KFV.concatenated_segments%TYPE )
19: IS
20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;
23:
24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )
25: IS

Line 24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )

20: SELECT DISTINCT operation_id
21: FROM AHL_OPERATIONS_B_KFV
22: WHERE concatenated_segments = c_concatenated_segments;
23:
24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )
25: IS
26: SELECT DISTINCT operation_id
27: FROM AHL_OPERATIONS_B
28: WHERE operation_id = c_operation_id;

Line 27: FROM AHL_OPERATIONS_B

23:
24: CURSOR get_rec_from_id ( c_operation_id AHL_OPERATIONS_B.operation_id%TYPE )
25: IS
26: SELECT DISTINCT operation_id
27: FROM AHL_OPERATIONS_B
28: WHERE operation_id = c_operation_id;
29:
30: BEGIN
31: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3345: FROM ahl_operations_b

3341: IS
3342:
3343: CURSOR get_operation_status(c_operation_id number) IS
3344: SELECT revision_status_code
3345: FROM ahl_operations_b
3346: WHERE operation_id = c_operation_id;
3347: l_operation_status_code VARCHAR2(30);
3348:
3349: BEGIN

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 3457: FROM ahl_operations_b oper ,

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
3457: FROM ahl_operations_b oper ,
3458: ahl_route_operations ass ,
3459: ahl_routes_app_v rou
3460: WHERE
3461: (

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 3641: AHL_OPERATIONS_B oper

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: )
3645: AND TRUNC ( NVL ( RT.end_date_active , SYSDATE + 1 ) ) > TRUNC( SYSDATE )

Line 3722: AHL_OPERATIONS_B oper

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
3726: TRUNC(NVL(oper.end_date_active, rou.start_date_active + 1)) > TRUNC(rou.start_date_active)

Line 3803: FROM AHL_OPERATIONS_B_KFV A, AHL_OPERATIONS_B_KFV B

3799:
3800: CURSOR get_op_latest_start_date( c_operation_id NUMBER )
3801: IS
3802: SELECT MAX( A.start_date_active )
3803: FROM AHL_OPERATIONS_B_KFV A, AHL_OPERATIONS_B_KFV B
3804: WHERE A.concatenated_segments = B.concatenated_segments
3805: AND A.operation_id <> c_operation_id
3806: AND B.operation_id = c_operation_id;
3807: