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.OTA_UTILITY dependencies on OTA_BOOKING_STATUS_HISTORIES

Line 3304: FROM ota_booking_status_histories bsh

3300:
3301: cursor crs_enrollment_change_reason
3302: is
3303: SELECT bsh.comments
3304: FROM ota_booking_status_histories bsh
3305: WHERE bsh.booking_id = p_booking_id
3306: AND bsh.start_date =
3307: (SELECT MAX(start_date)
3308: FROM ota_booking_status_histories

Line 3308: FROM ota_booking_status_histories

3304: FROM ota_booking_status_histories bsh
3305: WHERE bsh.booking_id = p_booking_id
3306: AND bsh.start_date =
3307: (SELECT MAX(start_date)
3308: FROM ota_booking_status_histories
3309: WHERE booking_id = p_booking_id);
3310:
3311: CURSOR crs_enr_change_reason_lang(p_lookup_code in varchar2) IS
3312: SELECT meaning