Product: | WIP - Work in Process |
---|---|
Description: | This view is based on WIP_OPERATION_COMPETENCIES table. |
Implementation/DBA Data: | APPS.WIP_OPERATION_SKILLS_V |
SELECT WOSK.ROWID ROW_ID
, 3 LEVEL_ID
, WOSK.WIP_ENTITY_ID
, WOSK.OPERATION_SEQ_NUM
, WOSK.ORGANIZATION_ID
, WOSK.RESOURCE_ID
, WOSK.COMPETENCE_ID
, PC.NAME COMPETENCE
, PC.CERTIFICATION_REQUIRED
, WOSK.RATING_LEVEL_ID
, DECODE(TO_CHAR(PRL.STEP_VALUE)||'-'||PRL.NAME
, '-'
, NULL
, TO_CHAR(PRL.STEP_VALUE)||'-'||PRL.NAME) SKILL_LEVEL
, WOSK.QUALIFICATION_TYPE_ID
, PQT.NAME QUALIFICATION
, WOSK.LAST_UPDATE_DATE
, WOSK.LAST_UPDATED_BY
, WOSK.LAST_UPDATE_LOGIN
, WOSK.CREATION_DATE
, WOSK.CREATED_BY
FROM WIP_OPERATION_COMPETENCIES WOSK
, PER_COMPETENCES PC
, PER_RATING_LEVELS PRL
, PER_QUALIFICATION_TYPES PQT
WHERE WOSK.COMPETENCE_ID = PC.COMPETENCE_ID(+)
AND WOSK.RATING_LEVEL_ID = PRL.RATING_LEVEL_ID(+)
AND WOSK.QUALIFICATION_TYPE_ID = PQT.QUALIFICATION_TYPE_ID(+)
AND (((PRL.RATING_SCALE_ID = PC.RATING_SCALE_ID) OR (PRL.COMPETENCE_ID = PC.COMPETENCE_ID )) OR PC.COMPETENCE_ID IS NULL OR PRL.RATING_LEVEL_ID IS NULL)