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') |