VIEW: APPS.CSF_RESOURCE_SKILLS_V

Source

View Text - Preformatted

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 , csf_resources_v csf_r WHERE r.skill_type_id = t.skill_type_id and r.skill_level_id = l.skill_level_id and csf_r.resource_id = r.resource_id and csf_r.resource_type = r.resource_type and (sysdate >= trunc(csf_r.resource_start_date_active) or csf_r.resource_start_date_active is null) and (sysdate <= trunc(csf_r.resource_end_date_active) + 1 or csf_r.resource_end_date_active is null)

View Text - HTML Formatted

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
, CSF_RESOURCES_V CSF_R
WHERE R.SKILL_TYPE_ID = T.SKILL_TYPE_ID
AND R.SKILL_LEVEL_ID = L.SKILL_LEVEL_ID
AND CSF_R.RESOURCE_ID = R.RESOURCE_ID
AND CSF_R.RESOURCE_TYPE = R.RESOURCE_TYPE
AND (SYSDATE >= TRUNC(CSF_R.RESOURCE_START_DATE_ACTIVE) OR CSF_R.RESOURCE_START_DATE_ACTIVE IS NULL)
AND (SYSDATE <= TRUNC(CSF_R.RESOURCE_END_DATE_ACTIVE) + 1 OR CSF_R.RESOURCE_END_DATE_ACTIVE IS NULL)