QA_CS_GROUPS_VL

Details

• Schema: FUSION

• Object owner: QA

• Object type: VIEW

Columns

Name
CS_GROUP_ID OBJECT_VERSION_NUMBER CS_GROUP_CODE NAME DESCRIPTION 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 qcgb.cs_group_id, qcgb.object_version_number, qcgb.cs_group_code, qcgt.NAME, qcgt.description, qcgb.enabled_flag, qcgb.start_date_active, qcgb.end_date_active, qcgb.created_by, qcgb.creation_date, qcgb.last_updated_by, qcgb.last_update_date, qcgb.last_update_login FROM qa_cs_groups_b qcgb, qa_cs_groups_tl qcgt WHERE qcgb.cs_group_id = qcgt.cs_group_id AND qcgt.language = userenv('LANG')