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

Line 1107: FROM AHL_OPERATIONS_B_KFV

1103: AND TRUNC(NVL(op.end_date_active,SYSDATE+1))
1104: AND op.revision_status_code='COMPLETE'
1105: AND op.revision_number IN
1106: ( SELECT MAX(revision_number)
1107: FROM AHL_OPERATIONS_B_KFV
1108: WHERE concatenated_segments=op.concatenated_segments
1109: AND revision_status_code='COMPLETE'
1110: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1111: TRUNC(NVL(end_date_active,SYSDATE+1))

Line 1165: FROM AHL_OPERATIONS_B_KFV

1161: AND TRUNC(NVL(op.end_date_active,SYSDATE+1))
1162: AND op.revision_status_code='COMPLETE'
1163: AND op.revision_number IN
1164: ( SELECT MAX(revision_number)
1165: FROM AHL_OPERATIONS_B_KFV
1166: WHERE concatenated_segments=op.concatenated_segments
1167: AND revision_status_code='COMPLETE'
1168: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1169: TRUNC(NVL(end_date_active,SYSDATE+1))

Line 1251: FROM AHL_OPERATIONS_B_KFV

1247: AND TRUNC(NVL(op.end_date_active,SYSDATE+1))
1248: AND op.revision_status_code='COMPLETE'
1249: AND op.revision_number IN
1250: ( SELECT MAX(revision_number)
1251: FROM AHL_OPERATIONS_B_KFV
1252: WHERE concatenated_segments=op.concatenated_segments
1253: AND revision_status_code='COMPLETE'
1254: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1255: TRUNC(NVL(end_date_active,SYSDATE+1))