Product: | OTA - Learning Management |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: | APPS.OTFV_TRAINING_EVENT_SESSIONS |
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, EVT.TITLE SESSION_NAME
, EVT.COURSE_START_DATE SESSION_DATE
, EVT.COURSE_START_TIME SESSION_START_TIME
, EVT.COURSE_END_TIME SESSION_END_TIME
, EVT2.TITLE EVENT_NAME
, EVT2.COURSE_START_DATE EVENT_START_DATE
, EVT2.COURSE_START_TIME EVENT_START_TIME
, EVT2.TIMEZONE TIME_ZONE
, ORGT1.NAME TRAINING_CENTRE
, TAD.NAME ACTIVITY_TYPE
, TAV.VERSION_NAME ACTIVITY_NAME
, '_DF:OTA:OTA_EVENTS:EVT'
, EVT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TAD.ACTIVITY_ID ACTIVITY_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, EVT.EVENT_ID EVENT_ID
, EVT.PARENT_EVENT_ID PARENT_EVENT_ID
, EVT.TRAINING_CENTER_ID TRAINING_CENTER_ID
, TAV.RCO_ID RCO_ID
, EVT.OFFERING_ID OFFERING_ID
FROM HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_EVENTS EVT2
, OTA_EVENTS EVT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT1
WHERE EVT.EVENT_TYPE = 'SESSION'
AND EVT.TRAINING_CENTER_ID = ORGT1.ORGANIZATION_ID (+)
AND DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, ORGT1.LANGUAGE)= DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, USERENV('LANG'))
AND EVT2.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID (+)
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID (+)
AND EVT.PARENT_EVENT_ID = EVT2.EVENT_ID
AND EVT2.EVENT_TYPE = 'SCHEDULED'
AND EVT.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND EVT.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY