QA_CHARACTERISTICS_VL

Details

• Schema: FUSION

• Object owner: QA

• Object type: VIEW

Columns

Name

CHARACTERISTIC_ID OBJECT_VERSION_NUMBER CHARACTERISTIC_CODE NAME DESCRIPTION CHARACTERISTIC_TYPE CONTEXT_TYPE ITEM_CLASS_ID ATTRIBUTE_GROUP_TARGET ATTRIBUTE_TARGET ATTRIBUTE_GROUP_MINIMUM ATTRIBUTE_MINIMUM ATTRIBUTE_GROUP_MAXIMUM ATTRIBUTE_MAXIMUM VALUE_SET_ID DATA_TYPE DEFAULT_VALUE UOM_CODE DECIMAL_PRECISION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN TARGET_VALUE_DATE ATTRIBUTE_MINIMUM_DATE ATTRIBUTE_MAXIMUM_DATE

Query

SQL_Statement

SELECT qcb.CHARACTERISTIC_ID, qcb.OBJECT_VERSION_NUMBER, qcb.CHARACTERISTIC_CODE, qct.NAME, qct.DESCRIPTION, qcb.CHARACTERISTIC_TYPE, qcb.CONTEXT_TYPE, qcb.ITEM_CLASS_ID, qcb.ATTRIBUTE_GROUP_TARGET, qcb.ATTRIBUTE_TARGET, qcb.ATTRIBUTE_GROUP_MINIMUM, qcb.ATTRIBUTE_MINIMUM, qcb.ATTRIBUTE_GROUP_MAXIMUM, qcb.ATTRIBUTE_MAXIMUM, qcb.VALUE_SET_ID, qcb.DATA_TYPE, qcb.DEFAULT_VALUE, qcb.UOM_CODE, qcb.DECIMAL_PRECISION, qcb.ENABLED_FLAG, qcb.START_DATE_ACTIVE, qcb.END_DATE_ACTIVE, qcb.CREATED_BY, qcb.CREATION_DATE, qcb.LAST_UPDATED_BY, qcb.LAST_UPDATE_DATE, qcb.LAST_UPDATE_LOGIN, qcb.TARGET_VALUE_DATE, qcb.ATTRIBUTE_MINIMUM_DATE, qcb.ATTRIBUTE_MAXIMUM_DATE FROM QA_CHARACTERISTICS_B qcb, QA_CHARACTERISTICS_TL qct WHERE qcb.CHARACTERISTIC_ID = qct.CHARACTERISTIC_ID AND qct.LANGUAGE = USERENV('LANG')