VIEW: APPS.CSF_REQUIRED_SKILLS_V

Source

View Text - Preformatted

SELECT r.rowid row_id , r.required_skill_id , r.skill_type_id , r.skill_id , t.name skill_type_name , t.description skill_type_description , r.has_skill_type , r.has_skill_id , r.skill_level_id , l.name||' ('||to_char(l.step_value)||')' skill_level_name , l.description skill_level_description , r.skill_required_flag , r.level_required_flag , r.disabled_flag , 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_required_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

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.REQUIRED_SKILL_ID
, R.SKILL_TYPE_ID
, R.SKILL_ID
, T.NAME SKILL_TYPE_NAME
, T.DESCRIPTION SKILL_TYPE_DESCRIPTION
, R.HAS_SKILL_TYPE
, R.HAS_SKILL_ID
, R.SKILL_LEVEL_ID
, L.NAME||' ('||TO_CHAR(L.STEP_VALUE)||')' SKILL_LEVEL_NAME
, L.DESCRIPTION SKILL_LEVEL_DESCRIPTION
, R.SKILL_REQUIRED_FLAG
, R.LEVEL_REQUIRED_FLAG
, R.DISABLED_FLAG
, 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_REQUIRED_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