View: PA_PROJ_ROLE_COMPETENCES_V

Product:	PA - Projects
Description:	This view returns the competences for a Project role
Implementation/DBA Data:	APPS.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