View: OTFV_EVENT_COMPETENCES

Product:	OTA - Learning Management
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.OTFV_EVENT_COMPETENCES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, COMP.NAME COMPETENCE_NAME
, DECODE(ELE.COMPETENCE_TYPE
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('COMPETENCE_TYPE'
, ELE.COMPETENCE_TYPE)) COMPETENCE_TYPE
, EVT.TITLE EVENT_NAME
, TAD.NAME ACTIVITY_TYPE
, TAV.VERSION_NAME ACTIVITY_NAME
, TAV.DESCRIPTION DESCRIPTION
, RAL.STEP_VALUE || DECODE(RAL.NAME
, ''
, ''
, ' - ' || RAL.NAME) PROFICIENCY
, '_DF:PER:PER_COMPETENCE_ELEMENTS:COMP'
, TAV.ACTIVITY_ID ACTIVITY_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, EVT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, COMP.COMPETENCE_ID COMPETENCE_ID
, ELE.COMPETENCE_ELEMENT_ID COMPETENCE_ELEMENT_ID
, TAV.CONTROLLING_PERSON_ID CONTROLLING_PERSON_ID
, EVT.EVENT_ID EVENT_ID
, ELE.PROFICIENCY_LEVEL_ID PROFICIENCY_LEVEL_ID
, TAV.RCO_ID RCO_ID
, EVT.OFFERING_ID OFFERING_ID
FROM OTA_EVENTS EVT
, PER_RATING_LEVELS RAL
, HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_COMPETENCE_ELEMENTS ELE
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_DEFINITIONS TAD
, PER_COMPETENCES COMP
WHERE COMP.COMPETENCE_ID = ELE.COMPETENCE_ID
AND ELE.TYPE = 'DELIVERY'
AND ELE.PROFICIENCY_LEVEL_ID = RAL.RATING_LEVEL_ID(+)
AND TAV.ACTIVITY_VERSION_ID = ELE.ACTIVITY_VERSION_ID
AND TAV.ACTIVITY_VERSION_ID = EVT.ACTIVITY_VERSION_ID
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
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

Columns