VIEW: APPS.CSF_SKILL_LEVELS_VL

Source

View Text - Preformatted

SELECT b.rowid row_id , b.skill_level_id , b.rating_scale_id , t.name , t.description , b.step_value , b.correction_factor , b.start_date_active , b.end_date_active , b.seeded_flag , b.object_version_number , b.created_by , b.creation_date , b.last_updated_by , b.last_update_date , b.last_update_login , b.attribute1 , b.attribute2 , b.attribute3 , b.attribute4 , b.attribute5 , b.attribute6 , b.attribute7 , b.attribute8 , b.attribute9 , b.attribute10 , b.attribute11 , b.attribute12 , b.attribute13 , b.attribute14 , b.attribute15 , b.attribute_category from csf_skill_levels_b b , csf_skill_levels_tl t WHERE b.skill_level_id = t.skill_level_id and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.SKILL_LEVEL_ID
, B.RATING_SCALE_ID
, T.NAME
, T.DESCRIPTION
, B.STEP_VALUE
, B.CORRECTION_FACTOR
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.SEEDED_FLAG
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE_CATEGORY
FROM CSF_SKILL_LEVELS_B B
, CSF_SKILL_LEVELS_TL T
WHERE B.SKILL_LEVEL_ID = T.SKILL_LEVEL_ID
AND T.LANGUAGE = USERENV('LANG')