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.HRI_OLTP_DISC_TRAINING dependencies on OTA_DELEGATE_BOOKINGS

Line 364: ,ota_delegate_bookings tdb

360: CURSOR internal_bookings_csr is
361: SELECT NVL(SUM(NVL(tdb.number_of_places,1)),0)
362: FROM
363: ota_booking_status_types bst
364: ,ota_delegate_bookings tdb
365: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
366: AND bst.type = 'A' -- Attended
367: AND tdb.organization_id IS NOT NULL
368: AND tdb.event_id = p_event_id;

Line 423: ,ota_delegate_bookings tdb

419:
420: CURSOR external_bookings_csr is
421: SELECT tdb.booking_id
422: FROM ota_booking_status_types bst
423: ,ota_delegate_bookings tdb
424: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
425: AND bst.type = 'A' -- Attended
426: AND tdb.customer_id is not null
427: AND tdb.event_id = p_event_id;

Line 497: ,ota_delegate_bookings tdb

493:
494: CURSOR internal_bookings_csr is
495: SELECT NVL(SUM(NVL(tdb.number_of_places,1)),0)
496: FROM ota_booking_status_types bst
497: ,ota_delegate_bookings tdb
498: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
499: AND bst.type = 'A' -- AttENDed
500: AND tdb.organization_id IS NOT NULL
501: AND tdb.booking_id = p_booking_id

Line 565: ,ota_delegate_bookings tdb

561:
562: CURSOR external_bookings_csr IS
563: SELECT tdb.booking_id
564: FROM ota_booking_status_types bst
565: ,ota_delegate_bookings tdb
566: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
567: AND bst.type = 'A' -- Attended
568: AND tdb.booking_id = p_booking_id
569: AND tdb.organization_id IS NULL -- bug fix 1432057

Line 644: ,ota_delegate_bookings tdb

640:
641: CURSOR internal_bookings_csr is
642: SELECT NVL(SUM(NVL(tdb.number_of_places,1)),0)
643: FROM ota_booking_status_types bst
644: ,ota_delegate_bookings tdb
645: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
646: AND bst.type IN ('P','C') -- Placed, Cancelled
647: AND tdb.organization_id IS NOT NULL
648: AND tdb.booking_id = p_booking_id

Line 712: ,ota_delegate_bookings tdb

708:
709: CURSOR external_bookings_csr is
710: SELECT tdb.booking_id
711: FROM ota_booking_status_types bst
712: ,ota_delegate_bookings tdb
713: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
714: AND bst.type IN ('P','C') -- Placed, Cancelled
715: AND tdb.booking_id = p_booking_id
716: AND tdb.organization_id IS NULL -- bug fix 1432057