Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.AHL_RESOURCE_SKILLS_V |
SELECT AHLRM.RESOURCE_SKILL_ID
, AHLRM.OBJECT_VERSION_NUMBER
, AHLRM.LAST_UPDATE_DATE
, AHLRM.LAST_UPDATED_BY
, AHLRM.CREATION_DATE
, AHLRM.CREATED_BY
, AHLRM.LAST_UPDATE_LOGIN
, AHLRM.AHL_RESOURCE_ID
, RS.NAME
, RS.DESCRIPTION
, AHLRM.COMPETENCE_ID
, CM.NAME
, AHLRM.RATING_LEVEL_ID
, DECODE( AHLRM.RATING_LEVEL_ID
, NULL
, NULL
, TO_CHAR(RT.STEP_VALUE) || '-' || RT.NAME )
, AHLRM.QUALIFICATION_TYPE_ID
, QAL.NAME
, AHLRM.SECURITY_GROUP_ID
, AHLRM.ATTRIBUTE_CATEGORY
, AHLRM.ATTRIBUTE1
, AHLRM.ATTRIBUTE2
, AHLRM.ATTRIBUTE3
, AHLRM.ATTRIBUTE4
, AHLRM.ATTRIBUTE5
, AHLRM.ATTRIBUTE6
, AHLRM.ATTRIBUTE7
, AHLRM.ATTRIBUTE8
, AHLRM.ATTRIBUTE9
, AHLRM.ATTRIBUTE10
, AHLRM.ATTRIBUTE11
, AHLRM.ATTRIBUTE12
, AHLRM.ATTRIBUTE13
, AHLRM.ATTRIBUTE14
, AHLRM.ATTRIBUTE15
FROM AHL_RESOURCE_SKILLS AHLRM
, AHL_RESOURCES RS
, PER_COMPETENCES CM
, PER_RATING_LEVELS RT
, PER_QUALIFICATION_TYPES QAL
WHERE AHLRM.AHL_RESOURCE_ID = RS.RESOURCE_ID (+)
AND AHLRM.COMPETENCE_ID = CM.COMPETENCE_ID (+)
AND AHLRM.RATING_LEVEL_ID = RT.RATING_LEVEL_ID (+)
AND AHLRM.QUALIFICATION_TYPE_ID = QAL.QUALIFICATION_TYPE_ID (+)