VIEW: APPS.OTA_EVENTS_V

Source

View Text - Preformatted

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 , OFV.LANGUAGE_CODE , ota_utility.get_lang_name(ofv.language_code) 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, OTA_OFFERINGS_VL OFV 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(+) AND evt.parent_offering_id = ofv.offering_id(+)

View Text - HTML Formatted

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
, OFV.LANGUAGE_CODE
, OTA_UTILITY.GET_LANG_NAME(OFV.LANGUAGE_CODE) 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
, OTA_OFFERINGS_VL OFV
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(+)
AND EVT.PARENT_OFFERING_ID = OFV.OFFERING_ID(+)