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.PER_ZA_WSP_ARCHIVE_PKG dependencies on OTA_BOOKING_STATUS_TYPES

Line 2993: ,ota_booking_status_types obst

2989: select oav.activity_version_id, oav.version_name
2990: from ota_events oe
2991: ,ota_activity_versions oav
2992: ,ota_delegate_bookings odb
2993: ,ota_booking_status_types obst
2994: where odb.delegate_person_id = p_person_id
2995: and odb.event_id = oe.event_id
2996: and oe.event_type in ( 'SCHEDULED', 'SELFPACED')
2997: and oe.activity_version_id = oav.activity_version_id

Line 3630: ,ota_booking_status_types obst

3626: select oav.activity_version_id, oav.version_name, odb.date_status_changed ,obst.name "status"
3627: from ota_events oe
3628: ,ota_activity_versions oav
3629: ,ota_delegate_bookings odb
3630: ,ota_booking_status_types obst
3631: where odb.delegate_person_id = p_person_id
3632: and odb.event_id = oe.event_id
3633: and oe.event_type in ( 'SCHEDULED', 'SELFPACED')
3634: and oe.activity_version_id = oav.activity_version_id