POQ_SUPPLIER_ATTRIBUTES_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POQ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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') |