VIEW: APPS.PA_PROJ_ROLE_COMPETENCES_V

Source

View Text - Preformatted

SELECT comp_ele.rowid, comp_ele.object_id, comp_ele.object_version_number, comp_ele.competence_id, comp_ele.competence_element_id, comp.competence_alias, comp.name, comp.description, comp_ele.proficiency_level_id, rl.step_value, comp_ele.mandatory , comp_ele.last_update_date FROM per_competence_elements comp_ele, per_competences comp, per_rating_levels rl WHERE comp_ele.object_name = 'PROJECT_ROLE' AND comp_ele.competence_id = comp.competence_id AND comp_ele.proficiency_level_id = rl.rating_level_id (+)

View Text - HTML Formatted

SELECT COMP_ELE.ROWID
, COMP_ELE.OBJECT_ID
, COMP_ELE.OBJECT_VERSION_NUMBER
, COMP_ELE.COMPETENCE_ID
, COMP_ELE.COMPETENCE_ELEMENT_ID
, COMP.COMPETENCE_ALIAS
, COMP.NAME
, COMP.DESCRIPTION
, COMP_ELE.PROFICIENCY_LEVEL_ID
, RL.STEP_VALUE
, COMP_ELE.MANDATORY
, COMP_ELE.LAST_UPDATE_DATE
FROM PER_COMPETENCE_ELEMENTS COMP_ELE
, PER_COMPETENCES COMP
, PER_RATING_LEVELS RL
WHERE COMP_ELE.OBJECT_NAME = 'PROJECT_ROLE'
AND COMP_ELE.COMPETENCE_ID = COMP.COMPETENCE_ID
AND COMP_ELE.PROFICIENCY_LEVEL_ID = RL.RATING_LEVEL_ID (+)