View: PA_OPEN_ASGMT_COMPETENCES_V

Product:	PA - Projects
Description:	This view returns the competences for a Requirement
Implementation/DBA Data:	APPS.PA_OPEN_ASGMT_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
, DECODE(COMP_ELE.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N')
, COMP_ELE.LAST_UPDATE_DATE
FROM PER_COMPETENCE_ELEMENTS COMP_ELE
, PER_COMPETENCES COMP
, PER_RATING_LEVELS RL
WHERE COMP_ELE.OBJECT_NAME = 'OPEN_ASSIGNMENT'
AND COMP_ELE.COMPETENCE_ID = COMP.COMPETENCE_ID
AND COMP_ELE.PROFICIENCY_LEVEL_ID = RL.RATING_LEVEL_ID (+)

Columns