VIEW: APPS.WIP_OPERATION_SKILLS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)