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_EVT_BUS2 dependencies on OTA_BOOKING_STATUS_TYPES

Line 62: , ota_booking_status_types bst

58: --
59: cursor get_total_places is
60: select nvl(sum(number_of_places),0)
61: from ota_delegate_bookings tdb
62: , ota_booking_status_types bst
63: , ota_events evt
64: where tdb.event_id = p_event_id
65: and evt.event_id = p_event_id
66: and tdb.booking_status_type_id = bst.booking_status_type_id

Line 167: from ota_booking_status_types

163: from ota_delegate_bookings odb
164: where event_id = p_event_id and
165: booking_status_type_id in
166: (select booking_status_type_id
167: from ota_booking_status_types
168: where type = 'W');
169:
170:
171: cursor c_check_int_waitlist_can is

Line 178: from ota_booking_status_types

174: where event_id = p_event_id and
175: internal_booking_flag = 'Y' and
176: booking_status_type_id in
177: (select booking_status_type_id
178: from ota_booking_status_types
179: where type = 'W' );
180:
181: --
182: begin