View: CSF_RESOURCE_SKILLS_V

Product:	CSF - Field Service
Description:	CONVENIENCE VIEW REsource skills
Implementation/DBA Data:	APPS.CSF_RESOURCE_SKILLS_V

View Text

SELECT R.ROWID ROW_ID
, R.RESOURCE_SKILL_ID
, R.SKILL_TYPE_ID
, R.SKILL_ID
, T.NAME SKILL_TYPE_NAME
, T.DESCRIPTION SKILL_TYPE_DESCRIPTION
, R.RESOURCE_TYPE
, R.RESOURCE_ID
, R.SKILL_LEVEL_ID
, L.NAME||' ('||TO_CHAR(L.STEP_VALUE)||')' SKILL_LEVEL_NAME
, L.DESCRIPTION SKILL_LEVEL_DESCRIPTION
, R.START_DATE_ACTIVE
, R.END_DATE_ACTIVE
, R.OBJECT_VERSION_NUMBER
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
, R.ATTRIBUTE_CATEGORY
FROM CSF_RESOURCE_SKILLS_B R
, CSF_SKILL_TYPES_VL T
, CSF_SKILL_LEVELS_VL L
WHERE R.SKILL_TYPE_ID = T.SKILL_TYPE_ID
AND R.SKILL_LEVEL_ID = L.SKILL_LEVEL_ID

Columns