View: BOM_OPERATION_SKILLS_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.BOM_OPERATION_SKILLS_V

View Text

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 BOM_OPERATION_SKILLS BOSK
, PER_COMPETENCES PC
, PER_RATING_LEVELS PRL
, PER_QUALIFICATION_TYPES PQT
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)

Columns