VIEW: OTA.OTA_EVENTS#

Source

View Text - Preformatted

select EVENT_ID EVENT_ID, VENDOR_ID VENDOR_ID, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, PARENT_EVENT_ID PARENT_EVENT_ID, EVENT_TYPE EVENT_TYPE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TITLE TITLE, ACTUAL_COST ACTUAL_COST, BUDGET_COST BUDGET_COST, BUDGET_CURRENCY_CODE BUDGET_CURRENCY_CODE, CENTRE CENTRE, COMMENTS COMMENTS, COURSE_END_DATE COURSE_END_DATE, COURSE_END_TIME COURSE_END_TIME, COURSE_START_DATE COURSE_START_DATE, COURSE_START_TIME COURSE_START_TIME, DURATION DURATION, DURATION_UNITS DURATION_UNITS, ENROLMENT_END_DATE ENROLMENT_END_DATE, ENROLMENT_START_DATE ENROLMENT_START_DATE, LANGUAGE_ID LANGUAGE_ID, PUBLIC_EVENT_FLAG PUBLIC_EVENT_FLAG, USER_STATUS USER_STATUS, DEVELOPMENT_EVENT_TYPE DEVELOPMENT_EVENT_TYPE, EVENT_STATUS EVENT_STATUS, PRICE_BASIS PRICE_BASIS, SECURE_EVENT_FLAG SECURE_EVENT_FLAG, BOOK_INDEPENDENT_FLAG BOOK_INDEPENDENT_FLAG, CURRENCY_CODE CURRENCY_CODE, MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES, MAXIMUM_INTERNAL_ATTENDEES MAXIMUM_INTERNAL_ATTENDEES, MINIMUM_ATTENDEES MINIMUM_ATTENDEES, STANDARD_PRICE STANDARD_PRICE, CATEGORY_CODE CATEGORY_CODE, 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, EVT_INFORMATION_CATEGORY EVT_INFORMATION_CATEGORY, EVT_INFORMATION1 EVT_INFORMATION1, EVT_INFORMATION2 EVT_INFORMATION2, EVT_INFORMATION3 EVT_INFORMATION3, EVT_INFORMATION4 EVT_INFORMATION4, EVT_INFORMATION5 EVT_INFORMATION5, EVT_INFORMATION6 EVT_INFORMATION6, EVT_INFORMATION7 EVT_INFORMATION7, EVT_INFORMATION8 EVT_INFORMATION8, EVT_INFORMATION9 EVT_INFORMATION9, EVT_INFORMATION10 EVT_INFORMATION10, EVT_INFORMATION11 EVT_INFORMATION11, EVT_INFORMATION12 EVT_INFORMATION12, EVT_INFORMATION13 EVT_INFORMATION13, EVT_INFORMATION14 EVT_INFORMATION14, EVT_INFORMATION15 EVT_INFORMATION15, EVT_INFORMATION16 EVT_INFORMATION16, EVT_INFORMATION17 EVT_INFORMATION17, EVT_INFORMATION18 EVT_INFORMATION18, EVT_INFORMATION19 EVT_INFORMATION19, EVT_INFORMATION20 EVT_INFORMATION20, PROJECT_ID PROJECT_ID, OWNER_ID OWNER_ID, LINE_ID LINE_ID, ORG_ID ORG_ID, TRAINING_CENTER_ID TRAINING_CENTER_ID, LOCATION_ID LOCATION_ID, OFFERING_ID OFFERING_ID, TIMEZONE TIMEZONE, PARENT_OFFERING_ID PARENT_OFFERING_ID, DATA_SOURCE DATA_SOURCE, EVENT_AVAILABILITY EVENT_AVAILABILITY from "OTA"."OTA_EVENTS"

View Text - HTML Formatted

SELECT EVENT_ID EVENT_ID
, VENDOR_ID VENDOR_ID
, ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PARENT_EVENT_ID PARENT_EVENT_ID
, EVENT_TYPE EVENT_TYPE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TITLE TITLE
, ACTUAL_COST ACTUAL_COST
, BUDGET_COST BUDGET_COST
, BUDGET_CURRENCY_CODE BUDGET_CURRENCY_CODE
, CENTRE CENTRE
, COMMENTS COMMENTS
, COURSE_END_DATE COURSE_END_DATE
, COURSE_END_TIME COURSE_END_TIME
, COURSE_START_DATE COURSE_START_DATE
, COURSE_START_TIME COURSE_START_TIME
, DURATION DURATION
, DURATION_UNITS DURATION_UNITS
, ENROLMENT_END_DATE ENROLMENT_END_DATE
, ENROLMENT_START_DATE ENROLMENT_START_DATE
, LANGUAGE_ID LANGUAGE_ID
, PUBLIC_EVENT_FLAG PUBLIC_EVENT_FLAG
, USER_STATUS USER_STATUS
, DEVELOPMENT_EVENT_TYPE DEVELOPMENT_EVENT_TYPE
, EVENT_STATUS EVENT_STATUS
, PRICE_BASIS PRICE_BASIS
, SECURE_EVENT_FLAG SECURE_EVENT_FLAG
, BOOK_INDEPENDENT_FLAG BOOK_INDEPENDENT_FLAG
, CURRENCY_CODE CURRENCY_CODE
, MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES
, MAXIMUM_INTERNAL_ATTENDEES MAXIMUM_INTERNAL_ATTENDEES
, MINIMUM_ATTENDEES MINIMUM_ATTENDEES
, STANDARD_PRICE STANDARD_PRICE
, CATEGORY_CODE CATEGORY_CODE
, 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
, EVT_INFORMATION_CATEGORY EVT_INFORMATION_CATEGORY
, EVT_INFORMATION1 EVT_INFORMATION1
, EVT_INFORMATION2 EVT_INFORMATION2
, EVT_INFORMATION3 EVT_INFORMATION3
, EVT_INFORMATION4 EVT_INFORMATION4
, EVT_INFORMATION5 EVT_INFORMATION5
, EVT_INFORMATION6 EVT_INFORMATION6
, EVT_INFORMATION7 EVT_INFORMATION7
, EVT_INFORMATION8 EVT_INFORMATION8
, EVT_INFORMATION9 EVT_INFORMATION9
, EVT_INFORMATION10 EVT_INFORMATION10
, EVT_INFORMATION11 EVT_INFORMATION11
, EVT_INFORMATION12 EVT_INFORMATION12
, EVT_INFORMATION13 EVT_INFORMATION13
, EVT_INFORMATION14 EVT_INFORMATION14
, EVT_INFORMATION15 EVT_INFORMATION15
, EVT_INFORMATION16 EVT_INFORMATION16
, EVT_INFORMATION17 EVT_INFORMATION17
, EVT_INFORMATION18 EVT_INFORMATION18
, EVT_INFORMATION19 EVT_INFORMATION19
, EVT_INFORMATION20 EVT_INFORMATION20
, PROJECT_ID PROJECT_ID
, OWNER_ID OWNER_ID
, LINE_ID LINE_ID
, ORG_ID ORG_ID
, TRAINING_CENTER_ID TRAINING_CENTER_ID
, LOCATION_ID LOCATION_ID
, OFFERING_ID OFFERING_ID
, TIMEZONE TIMEZONE
, PARENT_OFFERING_ID PARENT_OFFERING_ID
, DATA_SOURCE DATA_SOURCE
, EVENT_AVAILABILITY EVENT_AVAILABILITY
FROM "OTA"."OTA_EVENTS"