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

Line 81: ota_booking_status_types bst,

77: tfl.object_version_number tfl_object_version_number,
78: tdb.date_booking_placed ,
79: tdb.internal_booking_flag
80: from ota_delegate_bookings tdb,
81: ota_booking_status_types bst,
82: ota_finance_lines tfl
83: where tfl.booking_id(+) = tdb.booking_id
84: and tdb.booking_status_type_id = bst.booking_status_type_id
85: and bst.type = 'W'

Line 100: ota_booking_status_types bst,

96: tfl.object_version_number tfl_object_version_number,
97: tdb.date_booking_placed ,
98: tdb.internal_booking_flag
99: from ota_delegate_bookings tdb,
100: ota_booking_status_types bst,
101: ota_finance_lines tfl
102: where tfl.booking_id(+)= tdb.booking_id
103: and tdb.booking_status_type_id = bst.booking_status_type_id
104: and bst.type = 'W'

Line 117: ota_booking_status_types b

113:
114: cursor c_places_taken (p_booking_id in number) is
115: select sum(a.number_of_places)
116: from ota_delegate_bookings a,
117: ota_booking_status_types b
118: where a.event_id = p_event_id
119: and a.booking_status_type_id = b.booking_status_type_id
120: and b.type in ('P','A')
121: and a.internal_booking_flag = 'Y'