[Home] [Help]
View: PA_PROJ_ROLE_COMPETENCES_V
View Text
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 (+)
Columns
Name |
ROW_ID |
PROJECT_ROLE_ID |
OBJECT_VERSION_NUMBER |
COMPETENCE_ID |
COMPETENCE_ELEMENT_ID |
COMPETENCE_ALIAS |
COMPETENCE_NAME |
DESCRIPTION |
RATING_LEVEL_ID |
RATING_LEVEL_VALUE |
MANDATORY |
LAST_UPDATE_DATE |