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_DELEGATE_BOOKINGS

Line 61: from ota_delegate_bookings tdb

57: l_tdb_total_places number;
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

Line 163: from ota_delegate_bookings odb

159: l_no_of_int_waitlist_can number;
160:
161: cursor c_check_waitlist_candidates is
162: select count(rowid)
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

Line 173: from ota_delegate_bookings odb

169:
170:
171: cursor c_check_int_waitlist_can is
172: select count(rowid)
173: from ota_delegate_bookings odb
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