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_VIEWS_PKG dependencies on OTA_TDB_BUS

Line 24: and ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1

20: into l_places_booked
21: from ota_delegate_bookings db
22: , ota_booking_status_types bst
23: where bst.booking_status_type_id = db.booking_status_type_id
24: and ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1
25: and db.event_id = p_event_id ;
26:
27: select nvl(sum(db.number_of_places),0)
28: into l_place_wait

Line 41: and ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1

37: into l_internal_places_booked
38: from ota_delegate_bookings db
39: , ota_booking_status_types bst
40: where bst.booking_status_type_id = db.booking_status_type_id
41: and ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1
42: and db.internal_booking_flag='Y'
43: and db.event_id = p_event_id ;
44:
45: select nvl(maximum_attendees,0)