Product: | OTA - Learning Management |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: | APPS.OTFV_ACTIVITY_CATEGORIES |
SELECT HR_BIS.BIS_DECODE_LOOKUP('ACTIVITY_CATEGORY'
, ACI.ACTIVITY_CATEGORY) CATEGORY_NAME
, ACI.START_DATE_ACTIVE ACT_CAT_INCLUSION_FROM
, ACI.END_DATE_ACTIVE ACT_CAT_INCLUSION_TO
, DECODE(ACI.PRIMARY_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ACI.PRIMARY_FLAG)) PRIMARY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('CATEGORY_TYPE'
, TCU.TYPE) CATEGORY_TYPE
, TAD.NAME ACTIVITY_TYPE
, TAV.VERSION_NAME ACTIVITY_NAME
, TAV.DESCRIPTION ACTIVITY_DESCRIPTION
, EVT.TITLE EVENT_TITLE
, EVT.TIMEZONE TIME_ZONE
, '_DF:OTA:OTA_ACT_CAT_INCLUSIONS:ACI'
, 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
, OFFERING_ID OFFERING_ID
FROM OTA_ACT_CAT_INCLUSIONS ACI
, OTA_CATEGORY_USAGES TCU
, OTA_EVENTS EVT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_DEFINITIONS TAD
WHERE TAV.ACTIVITY_VERSION_ID = ACI.ACTIVITY_VERSION_ID
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
AND ACI.EVENT_ID = EVT.EVENT_ID (+)
AND ACI.CATEGORY_USAGE_ID = TCU.CATEGORY_USAGE_ID (+) WITH READ ONLY