View: OTA_EVENTS_V

Product:	OTA - Learning Management
Description:	View to list all Events.
Implementation/DBA Data:	APPS.OTA_EVENTS_V

View Text

SELECT EVT.ROWID
, EVT.EVENT_ID
, EVT.OBJECT_VERSION_NUMBER
, EVT.BUSINESS_GROUP_ID
, ENT.TITLE
, EVT.COURSE_START_DATE
, EVT.COURSE_START_TIME
, EVT.COURSE_END_DATE
, EVT.COURSE_END_TIME
, EVT.DURATION
, EVT.DURATION_UNITS
, EVT.ENROLMENT_START_DATE
, EVT.ENROLMENT_END_DATE
, SUBSTR (OTA_EVT_SHD.RESOURCE_BOOKING_FLAG (EVT.EVENT_ID)
, 1
, 1) RESOURCE_BOOKING_FLAG
, EVT.PUBLIC_EVENT_FLAG
, EVT.MINIMUM_ATTENDEES
, EVT.MAXIMUM_ATTENDEES
, EVT.MAXIMUM_INTERNAL_ATTENDEES
, EVT.STANDARD_PRICE
, EVT.PARENT_EVENT_ID
, EVT.BOOK_INDEPENDENT_FLAG
, EVT.ACTUAL_COST
, EVT.BUDGET_COST
, EVT.BUDGET_CURRENCY_CODE
, EVT.CREATED_BY
, EVT.CREATION_DATE
, EVT.LAST_UPDATED_BY
, EVT.LAST_UPDATE_LOGIN
, EVT.LAST_UPDATE_DATE
, EVT.COMMENTS
, EVT.EVT_INFORMATION_CATEGORY
, EVT.EVT_INFORMATION1
, EVT.EVT_INFORMATION2
, EVT.EVT_INFORMATION3
, EVT.EVT_INFORMATION4
, EVT.EVT_INFORMATION5
, EVT.EVT_INFORMATION6
, EVT.EVT_INFORMATION7
, EVT.EVT_INFORMATION8
, EVT.EVT_INFORMATION9
, EVT.EVT_INFORMATION10
, EVT.EVT_INFORMATION11
, EVT.EVT_INFORMATION12
, EVT.EVT_INFORMATION13
, EVT.EVT_INFORMATION14
, EVT.EVT_INFORMATION15
, EVT.EVT_INFORMATION16
, EVT.EVT_INFORMATION17
, EVT.EVT_INFORMATION18
, EVT.EVT_INFORMATION19
, EVT.EVT_INFORMATION20
, EVT.SECURE_EVENT_FLAG
, EVT.ORGANIZATION_ID
, OTA_GENERAL.HR_ORG_NAME(EVT.ORGANIZATION_ID) ORGANIZATION_NAME
, EVT.CENTRE CENTRE
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('TRAINING_CENTRE'
, EVT.CENTRE ) CENTRE_MEANING
, EVT.CURRENCY_CODE
, EVT.DEVELOPMENT_EVENT_TYPE
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('DEV_EVENT_TYPE'
, EVT.DEVELOPMENT_EVENT_TYPE) DEVELOPMENT_EVENT_TYPE_MEANING
, EVT.LANGUAGE_ID
, OTA_GENERAL.FND_LANG_DESC(EVT.LANGUAGE_ID) LANGUAGE_DESCRIPTION
, EVT.PRICE_BASIS
, EVT.CATEGORY_CODE PROGRAMME_CODE
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('ACTIVITY_CATEGORY'
, EVT.CATEGORY_CODE ) PROGRAMME_CODE_MEANING
, EVT.EVENT_STATUS
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('SCHEDULED_EVENT_STATUS'
, EVT.EVENT_STATUS ) EVENT_STATUS_MEANING
, TAD.NAME ACTIVITY_NAME
, TAV.ACTIVITY_VERSION_ID
, AVT.VERSION_NAME ACTIVITY_VERSION_NAME
, TYP.LOOKUP_CODE EVENT_TYPE
, TYP.MEANING EVENT_TYPE_MEANING
, OTA_EVT_SHD.INVOICED_AMOUNT_TOTAL (EVT.EVENT_ID) INVOICED_AMOUNT
, EVT.USER_STATUS USER_STATUS
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('EVENT_USER_STATUS'
, EVT.USER_STATUS) USER_STATUS_MEANING
, VEN.VENDOR_ID
, VEN.VENDOR_NAME
, EVT.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1 PROJECT_NUMBER
, EVT.LINE_ID
, EVT.ORG_ID
, EVT.OWNER_ID
, EVT.TRAINING_CENTER_ID
, EVT.LOCATION_ID
, EVT.OFFERING_ID
, EVT.TIMEZONE
, TAV.INVENTORY_ITEM_ID
, EVT.PARENT_OFFERING_ID
, EVT.DATA_SOURCE
FROM PO_VENDORS VEN
, HR_LOOKUPS TYP
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL AVT
, OTA_ACTIVITY_DEFINITIONS_TL TAD
, OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, PA_PROJECTS_ALL PPA
WHERE ENT.EVENT_ID = EVT.EVENT_ID
AND ENT.LANGUAGE= USERENV('LANG')
AND TAV.ACTIVITY_VERSION_ID (+) = EVT.ACTIVITY_VERSION_ID
AND AVT.ACTIVITY_VERSION_ID(+) = TAV.ACTIVITY_VERSION_ID
AND AVT.LANGUAGE (+ )= USERENV('LANG')
AND TAD.ACTIVITY_ID (+) = TAV.ACTIVITY_ID
AND TAD.LANGUAGE (+) = USERENV('LANG')
AND TYP.LOOKUP_TYPE = 'TRAINING_EVENT_TYPE'
AND TYP.LOOKUP_CODE = EVT.EVENT_TYPE
AND VEN.VENDOR_ID (+) = EVT.VENDOR_ID
AND EVT.PROJECT_ID = PPA.PROJECT_ID(+)

Columns