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.

[Home] [Help]

VIEW: OTA.OTA_RESOURCE_BOOKINGS#

Source

View Text - Preformatted


select RESOURCE_BOOKING_ID RESOURCE_BOOKING_ID, SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID, EVENT_ID EVENT_ID, DATE_BOOKING_PLACED DATE_BOOKING_PLACED, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATUS STATUS, ABSOLUTE_PRICE ABSOLUTE_PRICE, BOOKING_PERSON_ID BOOKING_PERSON_ID, COMMENTS COMMENTS, CONTACT_NAME CONTACT_NAME, CONTACT_PHONE_NUMBER CONTACT_PHONE_NUMBER, DELEGATES_PER_UNIT DELEGATES_PER_UNIT, QUANTITY QUANTITY, REQUIRED_DATE_FROM REQUIRED_DATE_FROM, REQUIRED_DATE_TO REQUIRED_DATE_TO, REQUIRED_END_TIME REQUIRED_END_TIME, REQUIRED_START_TIME REQUIRED_START_TIME, DELIVER_TO DELIVER_TO, PRIMARY_VENUE_FLAG PRIMARY_VENUE_FLAG, ROLE_TO_PLAY ROLE_TO_PLAY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TRB_INFORMATION_CATEGORY TRB_INFORMATION_CATEGORY, TRB_INFORMATION1 TRB_INFORMATION1, TRB_INFORMATION2 TRB_INFORMATION2, TRB_INFORMATION3 TRB_INFORMATION3, TRB_INFORMATION4 TRB_INFORMATION4, TRB_INFORMATION5 TRB_INFORMATION5, TRB_INFORMATION6 TRB_INFORMATION6, TRB_INFORMATION7 TRB_INFORMATION7, TRB_INFORMATION8 TRB_INFORMATION8, TRB_INFORMATION9 TRB_INFORMATION9, TRB_INFORMATION10 TRB_INFORMATION10, TRB_INFORMATION11 TRB_INFORMATION11, TRB_INFORMATION12 TRB_INFORMATION12, TRB_INFORMATION13 TRB_INFORMATION13, TRB_INFORMATION14 TRB_INFORMATION14, TRB_INFORMATION15 TRB_INFORMATION15, TRB_INFORMATION16 TRB_INFORMATION16, TRB_INFORMATION17 TRB_INFORMATION17, TRB_INFORMATION18 TRB_INFORMATION18, TRB_INFORMATION19 TRB_INFORMATION19, TRB_INFORMATION20 TRB_INFORMATION20, DISPLAY_TO_LEARNER_FLAG DISPLAY_TO_LEARNER_FLAG, BOOK_ENTIRE_PERIOD_FLAG BOOK_ENTIRE_PERIOD_FLAG, FORUM_ID FORUM_ID, CHAT_ID CHAT_ID, TIMEZONE_CODE TIMEZONE_CODE from "OTA"."OTA_RESOURCE_BOOKINGS"

View Text - HTML Formatted

SELECT RESOURCE_BOOKING_ID RESOURCE_BOOKING_ID
, SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
, EVENT_ID EVENT_ID
, DATE_BOOKING_PLACED DATE_BOOKING_PLACED
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATUS STATUS
, ABSOLUTE_PRICE ABSOLUTE_PRICE
, BOOKING_PERSON_ID BOOKING_PERSON_ID
, COMMENTS COMMENTS
, CONTACT_NAME CONTACT_NAME
, CONTACT_PHONE_NUMBER CONTACT_PHONE_NUMBER
, DELEGATES_PER_UNIT DELEGATES_PER_UNIT
, QUANTITY QUANTITY
, REQUIRED_DATE_FROM REQUIRED_DATE_FROM
, REQUIRED_DATE_TO REQUIRED_DATE_TO
, REQUIRED_END_TIME REQUIRED_END_TIME
, REQUIRED_START_TIME REQUIRED_START_TIME
, DELIVER_TO DELIVER_TO
, PRIMARY_VENUE_FLAG PRIMARY_VENUE_FLAG
, ROLE_TO_PLAY ROLE_TO_PLAY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TRB_INFORMATION_CATEGORY TRB_INFORMATION_CATEGORY
, TRB_INFORMATION1 TRB_INFORMATION1
, TRB_INFORMATION2 TRB_INFORMATION2
, TRB_INFORMATION3 TRB_INFORMATION3
, TRB_INFORMATION4 TRB_INFORMATION4
, TRB_INFORMATION5 TRB_INFORMATION5
, TRB_INFORMATION6 TRB_INFORMATION6
, TRB_INFORMATION7 TRB_INFORMATION7
, TRB_INFORMATION8 TRB_INFORMATION8
, TRB_INFORMATION9 TRB_INFORMATION9
, TRB_INFORMATION10 TRB_INFORMATION10
, TRB_INFORMATION11 TRB_INFORMATION11
, TRB_INFORMATION12 TRB_INFORMATION12
, TRB_INFORMATION13 TRB_INFORMATION13
, TRB_INFORMATION14 TRB_INFORMATION14
, TRB_INFORMATION15 TRB_INFORMATION15
, TRB_INFORMATION16 TRB_INFORMATION16
, TRB_INFORMATION17 TRB_INFORMATION17
, TRB_INFORMATION18 TRB_INFORMATION18
, TRB_INFORMATION19 TRB_INFORMATION19
, TRB_INFORMATION20 TRB_INFORMATION20
, DISPLAY_TO_LEARNER_FLAG DISPLAY_TO_LEARNER_FLAG
, BOOK_ENTIRE_PERIOD_FLAG BOOK_ENTIRE_PERIOD_FLAG
, FORUM_ID FORUM_ID
, CHAT_ID CHAT_ID
, TIMEZONE_CODE TIMEZONE_CODE
FROM "OTA"."OTA_RESOURCE_BOOKINGS"