Product: | OTA - Learning Management |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: | APPS.OTFV_TRAINING_EVENT_CATEGORIES |
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, EVT.TITLE EVENT_NAME
, HR_BIS.BIS_DECODE_LOOKUP('ACTIVITY_CATEGORY'
, ACI.ACTIVITY_CATEGORY) CATEGORY_NAME
, ACI.COMMENTS INCLUSION_COMMENTS
, ACI.START_DATE_ACTIVE START_DATE
, ACI.END_DATE_ACTIVE END_DATE
, DECODE(ACI.PRIMARY_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ACI.PRIMARY_FLAG)) PRIMARY_FLAG
, DECODE(TCU.TYPE
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('CATEGORY_TYPE'
, TCU.TYPE)) CATEGORY_TYPE
, TAD.NAME ACTIVITY_TYPE
, TAV.VERSION_NAME ACTIVITY_NAME
, TAV.DESCRIPTION ACTIVITY_DESCRIPTION
, '_DF:OTA:OTA_ACT_CAT_INCLUSIONS:ACI'
, EVT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TCU.CATEGORY_USAGE_ID CATEGORY_USAGE_ID
, TAV.ACTIVITY_ID ACTIVITY_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, EVT.EVENT_ID EVENT_ID
, TAV.RCO_ID RCO_ID
, EVT.OFFERING_ID OFFERING_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS BGR
, OTA_ACT_CAT_INCLUSIONS ACI
, OTA_CATEGORY_USAGES TCU
, OTA_EVENTS EVT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_DEFINITIONS TAD
WHERE EVT.EVENT_TYPE = 'SCHEDULED' AND TAV.ACTIVITY_VERSION_ID = EVT.ACTIVITY_VERSION_ID AND TAV.ACTIVITY_VERSION_ID = ACI.ACTIVITY_VERSION_ID
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID AND EVT.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND ACI.CATEGORY_USAGE_ID = TCU.CATEGORY_USAGE_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