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_UA_COMMON_PVT dependencies on AHL_UNIT_SCHEDULES_V

Line 410: from ahl_unit_schedules_v

406: p_start_time date
407: )
408: is
409: select *
410: from ahl_unit_schedules_v
411: where unit_config_header_id = p_unit_config_id
412: --Modifying to capture preceding overlapping flights too...
413: --and nvl(actual_arrival_time, est_arrival_time) <= p_start_time
414: --order by nvl(actual_arrival_time, est_arrival_time) desc;

Line 426: from ahl_unit_schedules_v

422: p_start_time date
423: )
424: is
425: select *
426: from ahl_unit_schedules_v
427: where unit_config_header_id = p_unit_config_id
428: --Modifying to capture preceding overlapping flights too...
429: --and est_arrival_time <= p_start_time
430: --order by est_arrival_time desc;

Line 1802: from ahl_unit_schedules_v

1798: p_end_time date
1799: )
1800: is
1801: select *
1802: from ahl_unit_schedules_v
1803: where unit_config_header_id = p_unit_config_id
1804: and nvl(actual_departure_time, est_departure_time) > p_end_time
1805: order by nvl(actual_departure_time, est_departure_time) asc, nvl(actual_arrival_time, est_arrival_time) asc;
1806:

Line 1815: from ahl_unit_schedules_v

1811: p_end_time date
1812: )
1813: is
1814: select *
1815: from ahl_unit_schedules_v
1816: where unit_config_header_id = p_unit_config_id
1817: and est_departure_time > p_end_time
1818: order by est_departure_time asc, est_arrival_time asc;
1819: