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_VWP_PRICE_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 1094: FROM AHL_OPERATIONS_B_KFV

1090: AND OP.revision_status_code='COMPLETE'
1091: AND RO.route_id=c_route_id
1092: AND OP.revision_number IN
1093: ( SELECT MAX(revision_number)
1094: FROM AHL_OPERATIONS_B_KFV
1095: WHERE concatenated_segments=OP.concatenated_segments
1096: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1097: TRUNC(NVL(end_date_active,SYSDATE+1))
1098: )

Line 1307: FROM AHL_OPERATIONS_B_KFV

1303: AND OP.revision_status_code='COMPLETE'
1304: AND RO.route_id=c_route_id
1305: AND OP.revision_number IN
1306: ( SELECT MAX(revision_number)
1307: FROM AHL_OPERATIONS_B_KFV
1308: WHERE concatenated_segments=OP.concatenated_segments
1309: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1310: TRUNC(NVL(end_date_active,SYSDATE+1))
1311: )

Line 1334: from ahl_operations_b_kfv op,

1330: and msiv.inventory_item_id = br.billable_item_id
1331: and msiv.organization_id = c_org_id
1332: and ar.object_id in
1333: ( select ro.operation_id
1334: from ahl_operations_b_kfv op,
1335: ahl_route_operations ro
1336: where op.operation_id=ro.operation_id
1337: and op.revision_status_code='COMPLETE'
1338: and ro.route_id=c_route_id

Line 1341: from ahl_operations_b_kfv

1337: and op.revision_status_code='COMPLETE'
1338: and ro.route_id=c_route_id
1339: and op.revision_number in
1340: ( select max(revision_number)
1341: from ahl_operations_b_kfv
1342: where concatenated_segments=op.concatenated_segments
1343: and trunc(sysdate) between trunc(start_date_active)
1344: and trunc(nvl(end_date_active,sysdate+1))
1345: )