VIEW: OTA.OTA_DELEGATE_BOOKINGS#

Source

View Text - Preformatted

select BOOKING_ID BOOKING_ID, BOOKING_STATUS_TYPE_ID BOOKING_STATUS_TYPE_ID, DELEGATE_PERSON_ID DELEGATE_PERSON_ID, CONTACT_ID CONTACT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EVENT_ID EVENT_ID, PERSON_ADDRESS_ID PERSON_ADDRESS_ID, DELEGATE_CONTACT_ID DELEGATE_CONTACT_ID, DELEGATE_CONTACT_EMAIL DELEGATE_CONTACT_EMAIL, THIRD_PARTY_EMAIL THIRD_PARTY_EMAIL, PERSON_ADDRESS_TYPE PERSON_ADDRESS_TYPE, DELEGATE_ASSIGNMENT_ID DELEGATE_ASSIGNMENT_ID, ORGANIZATION_ID ORGANIZATION_ID, SPONSOR_PERSON_ID SPONSOR_PERSON_ID, SPONSOR_ASSIGNMENT_ID SPONSOR_ASSIGNMENT_ID, CUSTOMER_ID CUSTOMER_ID, AUTHORIZER_PERSON_ID AUTHORIZER_PERSON_ID, DATE_BOOKING_PLACED DATE_BOOKING_PLACED, INTERNAL_BOOKING_FLAG INTERNAL_BOOKING_FLAG, NUMBER_OF_PLACES NUMBER_OF_PLACES, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ADMINISTRATOR ADMINISTRATOR, ATTENDANCE_RESULT ATTENDANCE_RESULT, BOOKING_PRIORITY BOOKING_PRIORITY, COMMENTS COMMENTS, CONTACT_ADDRESS_ID CONTACT_ADDRESS_ID, CORESPONDENT CORESPONDENT, DATE_STATUS_CHANGED DATE_STATUS_CHANGED, DELEGATE_CONTACT_FAX DELEGATE_CONTACT_FAX, DELEGATE_CONTACT_PHONE DELEGATE_CONTACT_PHONE, FAILURE_REASON FAILURE_REASON, LANGUAGE_ID LANGUAGE_ID, SOURCE_OF_BOOKING SOURCE_OF_BOOKING, SPECIAL_BOOKING_INSTRUCTIONS SPECIAL_BOOKING_INSTRUCTIONS, SUCCESSFUL_ATTENDANCE_FLAG SUCCESSFUL_ATTENDANCE_FLAG, THIRD_PARTY_ADDRESS_ID THIRD_PARTY_ADDRESS_ID, THIRD_PARTY_CONTACT_FAX THIRD_PARTY_CONTACT_FAX, THIRD_PARTY_CONTACT_ID THIRD_PARTY_CONTACT_ID, THIRD_PARTY_CONTACT_PHONE THIRD_PARTY_CONTACT_PHONE, THIRD_PARTY_CUSTOMER_ID THIRD_PARTY_CUSTOMER_ID, 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, TDB_INFORMATION_CATEGORY TDB_INFORMATION_CATEGORY, TDB_INFORMATION1 TDB_INFORMATION1, TDB_INFORMATION2 TDB_INFORMATION2, TDB_INFORMATION3 TDB_INFORMATION3, TDB_INFORMATION4 TDB_INFORMATION4, TDB_INFORMATION5 TDB_INFORMATION5, TDB_INFORMATION6 TDB_INFORMATION6, TDB_INFORMATION7 TDB_INFORMATION7, TDB_INFORMATION8 TDB_INFORMATION8, TDB_INFORMATION9 TDB_INFORMATION9, TDB_INFORMATION10 TDB_INFORMATION10, TDB_INFORMATION11 TDB_INFORMATION11, TDB_INFORMATION12 TDB_INFORMATION12, TDB_INFORMATION13 TDB_INFORMATION13, TDB_INFORMATION14 TDB_INFORMATION14, TDB_INFORMATION15 TDB_INFORMATION15, TDB_INFORMATION16 TDB_INFORMATION16, TDB_INFORMATION17 TDB_INFORMATION17, TDB_INFORMATION18 TDB_INFORMATION18, TDB_INFORMATION19 TDB_INFORMATION19, TDB_INFORMATION20 TDB_INFORMATION20, LINE_ID LINE_ID, ORG_ID ORG_ID, DAEMON_FLAG DAEMON_FLAG, DAEMON_TYPE DAEMON_TYPE, OLD_EVENT_ID OLD_EVENT_ID, QUOTE_LINE_ID QUOTE_LINE_ID, INTERFACE_SOURCE INTERFACE_SOURCE, TOTAL_TRAINING_TIME TOTAL_TRAINING_TIME, CONTENT_PLAYER_STATUS CONTENT_PLAYER_STATUS, SCORE SCORE, COMPLETED_CONTENT COMPLETED_CONTENT, TOTAL_CONTENT TOTAL_CONTENT, BOOKING_JUSTIFICATION_ID BOOKING_JUSTIFICATION_ID, IS_HISTORY_FLAG IS_HISTORY_FLAG, IS_MANDATORY_ENROLLMENT IS_MANDATORY_ENROLLMENT, SIGN_EVAL_STATUS SIGN_EVAL_STATUS from "OTA"."OTA_DELEGATE_BOOKINGS"

View Text - HTML Formatted

SELECT BOOKING_ID BOOKING_ID
, BOOKING_STATUS_TYPE_ID BOOKING_STATUS_TYPE_ID
, DELEGATE_PERSON_ID DELEGATE_PERSON_ID
, CONTACT_ID CONTACT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EVENT_ID EVENT_ID
, PERSON_ADDRESS_ID PERSON_ADDRESS_ID
, DELEGATE_CONTACT_ID DELEGATE_CONTACT_ID
, DELEGATE_CONTACT_EMAIL DELEGATE_CONTACT_EMAIL
, THIRD_PARTY_EMAIL THIRD_PARTY_EMAIL
, PERSON_ADDRESS_TYPE PERSON_ADDRESS_TYPE
, DELEGATE_ASSIGNMENT_ID DELEGATE_ASSIGNMENT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SPONSOR_PERSON_ID SPONSOR_PERSON_ID
, SPONSOR_ASSIGNMENT_ID SPONSOR_ASSIGNMENT_ID
, CUSTOMER_ID CUSTOMER_ID
, AUTHORIZER_PERSON_ID AUTHORIZER_PERSON_ID
, DATE_BOOKING_PLACED DATE_BOOKING_PLACED
, INTERNAL_BOOKING_FLAG INTERNAL_BOOKING_FLAG
, NUMBER_OF_PLACES NUMBER_OF_PLACES
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ADMINISTRATOR ADMINISTRATOR
, ATTENDANCE_RESULT ATTENDANCE_RESULT
, BOOKING_PRIORITY BOOKING_PRIORITY
, COMMENTS COMMENTS
, CONTACT_ADDRESS_ID CONTACT_ADDRESS_ID
, CORESPONDENT CORESPONDENT
, DATE_STATUS_CHANGED DATE_STATUS_CHANGED
, DELEGATE_CONTACT_FAX DELEGATE_CONTACT_FAX
, DELEGATE_CONTACT_PHONE DELEGATE_CONTACT_PHONE
, FAILURE_REASON FAILURE_REASON
, LANGUAGE_ID LANGUAGE_ID
, SOURCE_OF_BOOKING SOURCE_OF_BOOKING
, SPECIAL_BOOKING_INSTRUCTIONS SPECIAL_BOOKING_INSTRUCTIONS
, SUCCESSFUL_ATTENDANCE_FLAG SUCCESSFUL_ATTENDANCE_FLAG
, THIRD_PARTY_ADDRESS_ID THIRD_PARTY_ADDRESS_ID
, THIRD_PARTY_CONTACT_FAX THIRD_PARTY_CONTACT_FAX
, THIRD_PARTY_CONTACT_ID THIRD_PARTY_CONTACT_ID
, THIRD_PARTY_CONTACT_PHONE THIRD_PARTY_CONTACT_PHONE
, THIRD_PARTY_CUSTOMER_ID THIRD_PARTY_CUSTOMER_ID
, 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
, TDB_INFORMATION_CATEGORY TDB_INFORMATION_CATEGORY
, TDB_INFORMATION1 TDB_INFORMATION1
, TDB_INFORMATION2 TDB_INFORMATION2
, TDB_INFORMATION3 TDB_INFORMATION3
, TDB_INFORMATION4 TDB_INFORMATION4
, TDB_INFORMATION5 TDB_INFORMATION5
, TDB_INFORMATION6 TDB_INFORMATION6
, TDB_INFORMATION7 TDB_INFORMATION7
, TDB_INFORMATION8 TDB_INFORMATION8
, TDB_INFORMATION9 TDB_INFORMATION9
, TDB_INFORMATION10 TDB_INFORMATION10
, TDB_INFORMATION11 TDB_INFORMATION11
, TDB_INFORMATION12 TDB_INFORMATION12
, TDB_INFORMATION13 TDB_INFORMATION13
, TDB_INFORMATION14 TDB_INFORMATION14
, TDB_INFORMATION15 TDB_INFORMATION15
, TDB_INFORMATION16 TDB_INFORMATION16
, TDB_INFORMATION17 TDB_INFORMATION17
, TDB_INFORMATION18 TDB_INFORMATION18
, TDB_INFORMATION19 TDB_INFORMATION19
, TDB_INFORMATION20 TDB_INFORMATION20
, LINE_ID LINE_ID
, ORG_ID ORG_ID
, DAEMON_FLAG DAEMON_FLAG
, DAEMON_TYPE DAEMON_TYPE
, OLD_EVENT_ID OLD_EVENT_ID
, QUOTE_LINE_ID QUOTE_LINE_ID
, INTERFACE_SOURCE INTERFACE_SOURCE
, TOTAL_TRAINING_TIME TOTAL_TRAINING_TIME
, CONTENT_PLAYER_STATUS CONTENT_PLAYER_STATUS
, SCORE SCORE
, COMPLETED_CONTENT COMPLETED_CONTENT
, TOTAL_CONTENT TOTAL_CONTENT
, BOOKING_JUSTIFICATION_ID BOOKING_JUSTIFICATION_ID
, IS_HISTORY_FLAG IS_HISTORY_FLAG
, IS_MANDATORY_ENROLLMENT IS_MANDATORY_ENROLLMENT
, SIGN_EVAL_STATUS SIGN_EVAL_STATUS
FROM "OTA"."OTA_DELEGATE_BOOKINGS"