QA_CS_VALUES_VL

Details

• Schema: FUSION

• Object owner: QA

• Object type: VIEW

Columns

Name
CS_VALUE_ID CHARACTERISTIC_ID OBJECT_VERSION_NUMBER CS_VALUE_CODE NAME DESCRIPTION DISPLAY_SEQUENCE ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT qcvb.cs_value_id, qcvb.characteristic_id, qcvb.object_version_number, qcvb.cs_value_code, qcvt.NAME, qcvt.description, qcvb.display_sequence, qcvb.enabled_flag, qcvb.start_date_active, qcvb.end_date_active, qcvb.created_by, qcvb.creation_date, qcvb.last_updated_by, qcvb.last_update_date, qcvb.last_update_login FROM qa_cs_values_b qcvb, qa_cs_values_tl qcvt WHERE qcvb.cs_value_id = qcvt.cs_value_id AND qcvt.language = userenv('LANG')