VIEW: APPS.BOM_OPERATION_SKILLS_V

Source

View Text - Preformatted

SELECT BOSK.ROWID ROW_ID, BOSK.LEVEL_ID, BOSK.STANDARD_OPERATION_ID, BOSK.ORGANIZATION_ID, BOSK.OPERATION_SEQUENCE_ID, BOSK.RESOURCE_ID, BOSK.COMPETENCE_ID, PC.name COMPETENCE, BOSK.RATING_LEVEL_ID, decode(to_char(PRL.step_value)||'-'||PRL.name,'-' ,null,to_char(PRL.step_value)||'-'||PRL.name) SKILL_LEVEL, BOSK.QUALIFICATION_TYPE_ID, PQT.name QUALIFICATION, BOSK.LAST_UPDATE_DATE, BOSK.LAST_UPDATED_BY, BOSK.LAST_UPDATE_LOGIN, BOSK.CREATION_DATE, BOSK.CREATED_BY FROM PER_QUALIFICATION_TYPES PQT,PER_RATING_LEVELS PRL,PER_COMPETENCES PC,BOM_OPERATION_SKILLS BOSK WHERE BOSK.COMPETENCE_ID = PC.COMPETENCE_ID(+) AND BOSK.RATING_LEVEL_ID = PRL.RATING_LEVEL_ID(+) AND BOSK.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 BOSK.ROWID ROW_ID
, BOSK.LEVEL_ID
, BOSK.STANDARD_OPERATION_ID
, BOSK.ORGANIZATION_ID
, BOSK.OPERATION_SEQUENCE_ID
, BOSK.RESOURCE_ID
, BOSK.COMPETENCE_ID
, PC.NAME COMPETENCE
, BOSK.RATING_LEVEL_ID
, DECODE(TO_CHAR(PRL.STEP_VALUE)||'-'||PRL.NAME
, '-'
, NULL
, TO_CHAR(PRL.STEP_VALUE)||'-'||PRL.NAME) SKILL_LEVEL
, BOSK.QUALIFICATION_TYPE_ID
, PQT.NAME QUALIFICATION
, BOSK.LAST_UPDATE_DATE
, BOSK.LAST_UPDATED_BY
, BOSK.LAST_UPDATE_LOGIN
, BOSK.CREATION_DATE
, BOSK.CREATED_BY
FROM PER_QUALIFICATION_TYPES PQT
, PER_RATING_LEVELS PRL
, PER_COMPETENCES PC
, BOM_OPERATION_SKILLS BOSK
WHERE BOSK.COMPETENCE_ID = PC.COMPETENCE_ID(+)
AND BOSK.RATING_LEVEL_ID = PRL.RATING_LEVEL_ID(+)
AND BOSK.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)