VIEW: APPS.PA_RESOURCE_COMPETENCES_V

Source

View Text - Preformatted

SELECT comp_ele.rowid, comp_ele.person_id, comp_ele.competence_id, comp_ele.competence_element_id, comp.competence_alias, comp.name, comp_ele.object_version_number, comp_ele.effective_date_from, comp_ele.effective_date_to, comp.description, comp_ele.proficiency_level_id, rl.step_value, comp_ele.last_update_date, decode(comp.BUSINESS_GROUP_ID,null,'Y','N'), 'N' FROM per_competence_elements comp_ele, per_competences comp, per_rating_levels rl WHERE comp_ele.competence_id = comp.competence_id AND comp_ele.proficiency_level_id = rl.rating_level_id (+) AND comp_ele.person_id IS NOT NULL AND comp_ele.competence_element_id not in (SELECT nvl(COMPETENCE_ELEMENT_ID,-1) FROM PA_COMPETENCE_PROFILES) UNION SELECT comp_tmp.rowid, comp_tmp.person_id, comp_tmp.competence_id, comp_tmp.competence_element_id, comp_tmp.competence_alias, comp_tmp.competence_name, comp_tmp.object_version_number, comp_tmp.effective_date_from, to_date(NULL), comp_tmp.description, comp_tmp.rating_level_id, comp_tmp.rating_level_value, comp_tmp.last_update_date, decode(comp_tmp.BUSINESS_GROUP_ID,null,'Y','N'), 'Y' FROM pa_competence_profiles comp_tmp

View Text - HTML Formatted

SELECT COMP_ELE.ROWID
, COMP_ELE.PERSON_ID
, COMP_ELE.COMPETENCE_ID
, COMP_ELE.COMPETENCE_ELEMENT_ID
, COMP.COMPETENCE_ALIAS
, COMP.NAME
, COMP_ELE.OBJECT_VERSION_NUMBER
, COMP_ELE.EFFECTIVE_DATE_FROM
, COMP_ELE.EFFECTIVE_DATE_TO
, COMP.DESCRIPTION
, COMP_ELE.PROFICIENCY_LEVEL_ID
, RL.STEP_VALUE
, COMP_ELE.LAST_UPDATE_DATE
, DECODE(COMP.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
, 'N'
FROM PER_COMPETENCE_ELEMENTS COMP_ELE
, PER_COMPETENCES COMP
, PER_RATING_LEVELS RL
WHERE COMP_ELE.COMPETENCE_ID = COMP.COMPETENCE_ID
AND COMP_ELE.PROFICIENCY_LEVEL_ID = RL.RATING_LEVEL_ID (+)
AND COMP_ELE.PERSON_ID IS NOT NULL
AND COMP_ELE.COMPETENCE_ELEMENT_ID NOT IN (SELECT NVL(COMPETENCE_ELEMENT_ID
, -1)
FROM PA_COMPETENCE_PROFILES) UNION SELECT COMP_TMP.ROWID
, COMP_TMP.PERSON_ID
, COMP_TMP.COMPETENCE_ID
, COMP_TMP.COMPETENCE_ELEMENT_ID
, COMP_TMP.COMPETENCE_ALIAS
, COMP_TMP.COMPETENCE_NAME
, COMP_TMP.OBJECT_VERSION_NUMBER
, COMP_TMP.EFFECTIVE_DATE_FROM
, TO_DATE(NULL)
, COMP_TMP.DESCRIPTION
, COMP_TMP.RATING_LEVEL_ID
, COMP_TMP.RATING_LEVEL_VALUE
, COMP_TMP.LAST_UPDATE_DATE
, DECODE(COMP_TMP.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
, 'Y'
FROM PA_COMPETENCE_PROFILES COMP_TMP