View: PA_REQMNT_COMPETENCES_AMG_V

Product:	PA - Projects
Description:	This view shows all competences for a project requirement.
Implementation/DBA Data:	APPS.PA_REQMNT_COMPETENCES_AMG_V

View Text

SELECT COMP_ELE.OBJECT_ID
, ASGMT.ASSIGNMENT_NAME
, ASGMT.START_DATE
, ASGMT.END_DATE
, ASGMT.PROJECT_ID
, PROJ.NAME
, PROJ.SEGMENT1
, COMP_ELE.COMPETENCE_ELEMENT_ID
, COMP_ELE.COMPETENCE_ID
, COMP.NAME
, COMP.COMPETENCE_ALIAS
, COMP_ELE.PROFICIENCY_LEVEL_ID
, RL.STEP_VALUE
, COMP_ELE.MANDATORY
, COMP_ELE.OBJECT_VERSION_NUMBER
, COMP.BUSINESS_GROUP_ID
, COMP_ELE.CREATION_DATE
, COMP_ELE.LAST_UPDATE_DATE
FROM PA_PROJECT_ASSIGNMENTS ASGMT
, PA_PROJECTS_ALL PROJ
, 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.OBJECT_ID = ASGMT.ASSIGNMENT_ID
AND ASGMT.PROJECT_ID = PROJ.PROJECT_ID
AND COMP_ELE.PROFICIENCY_LEVEL_ID = RL.RATING_LEVEL_ID (+)

Columns