POQ_SUPPLIER_ATTRIBUTES_VL

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name
SUPPLIER_ATTRIBUTE_CODE SUPPLIER_ATTRIBUTE_NAME CATEGORY_CODE ATTRIBUTE_ACTIVE_FLAG QUESTION_LEVEL QUESTION_TYPE RESPONSE_TYPE SYNC_REQ_FLAG RULE_SET_ATTR_CODE REG_READ_ONLY_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.SUPPLIER_ATTRIBUTE_CODE , T.SUPPLIER_ATTRIBUTE_NAME , B.CATEGORY_CODE , B.ATTRIBUTE_ACTIVE_FLAG , B.QUESTION_LEVEL , B.QUESTION_TYPE , B.RESPONSE_TYPE , B.SYNC_REQ_FLAG , B.RULE_SET_ATTR_CODE , B.REG_READ_ONLY_FLAG , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.OBJECT_VERSION_NUMBER , B.LAST_UPDATE_LOGIN FROM POQ_SUPPLIER_ATTRIBUTES_B B, POQ_SUPPLIER_ATTRIBUTES_TL T WHERE B.SUPPLIER_ATTRIBUTE_CODE = T.SUPPLIER_ATTRIBUTE_CODE AND T.LANGUAGE = USERENV('LANG')