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_FLEET_FORECAST_PVT dependencies on AHL_MR_HEADERS_V

Line 449: FROM ahl_fleet_reconfig_mrs frm, ahl_mr_headers_v mrh

445: CURSOR get_reconfig_mrs(c_fleet_header_id NUMBER, c_src_operations_type_code VARCHAR2)
446: IS
447: SELECT frm.fleet_reconfig_mr_id, mrh.mr_header_id, frm.mr_title,
448: frm.src_operations_type_code, frm.compliance_lead_time
449: FROM ahl_fleet_reconfig_mrs frm, ahl_mr_headers_v mrh
450: WHERE frm.fleet_header_id = c_fleet_header_id
451: AND frm.mr_title = mrh.title
452: AND trunc(nvl(mrh.effective_to, SYSDATE +1))>trunc(SYSDATE)
453: AND mrh.mr_status_code = 'COMPLETE'

Line 459: FROM ahl_mr_headers_v

455:
456: CURSOR get_mr_header_id(c_mr_title VARCHAR2)
457: IS
458: SELECT mr_header_id
459: FROM ahl_mr_headers_v
460: WHERE trunc(nvl( effective_to, SYSDATE +1))>trunc(SYSDATE)
461: AND mr_status_code = 'COMPLETE'
462: AND title = c_mr_title;
463: