VIEW: APPS.PA_REQMNT_COMPETENCES_AMG_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)