VIEW: INV.MTL_ITEM_ATTRIBUTES#

Source

View Text - Preformatted

select ATTRIBUTE_NAME ATTRIBUTE_NAME, USER_ATTRIBUTE_NAME USER_ATTRIBUTE_NAME, USER_ATTRIBUTE_NAME_GUI USER_ATTRIBUTE_NAME_GUI, ATTRIBUTE_GROUP_ID ATTRIBUTE_GROUP_ID, ATTRIBUTE_GROUP_ID_GUI ATTRIBUTE_GROUP_ID_GUI, CONTROL_LEVEL CONTROL_LEVEL, DATA_TYPE DATA_TYPE, SEQUENCE SEQUENCE, SEQUENCE_GUI SEQUENCE_GUI, LEVEL_UPDATEABLE_FLAG LEVEL_UPDATEABLE_FLAG, STATUS_CONTROL_CODE STATUS_CONTROL_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, VALIDATION_CODE VALIDATION_CODE, PREFIELD_FLAG PREFIELD_FLAG, POST_CHANGE_FLAG POST_CHANGE_FLAG, POST_FIELD_FLAG POST_FIELD_FLAG, MANDATORY_FLAG MANDATORY_FLAG, UPDATE_MESSAGE_NAME UPDATE_MESSAGE_NAME, REQUIRED_MESSAGE_NAME REQUIRED_MESSAGE_NAME, ZD_EDITION_NAME ZD_EDITION_NAME from "INV"."MTL_ITEM_ATTRIBUTES"

View Text - HTML Formatted

SELECT ATTRIBUTE_NAME ATTRIBUTE_NAME
, USER_ATTRIBUTE_NAME USER_ATTRIBUTE_NAME
, USER_ATTRIBUTE_NAME_GUI USER_ATTRIBUTE_NAME_GUI
, ATTRIBUTE_GROUP_ID ATTRIBUTE_GROUP_ID
, ATTRIBUTE_GROUP_ID_GUI ATTRIBUTE_GROUP_ID_GUI
, CONTROL_LEVEL CONTROL_LEVEL
, DATA_TYPE DATA_TYPE
, SEQUENCE SEQUENCE
, SEQUENCE_GUI SEQUENCE_GUI
, LEVEL_UPDATEABLE_FLAG LEVEL_UPDATEABLE_FLAG
, STATUS_CONTROL_CODE STATUS_CONTROL_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VALIDATION_CODE VALIDATION_CODE
, PREFIELD_FLAG PREFIELD_FLAG
, POST_CHANGE_FLAG POST_CHANGE_FLAG
, POST_FIELD_FLAG POST_FIELD_FLAG
, MANDATORY_FLAG MANDATORY_FLAG
, UPDATE_MESSAGE_NAME UPDATE_MESSAGE_NAME
, REQUIRED_MESSAGE_NAME REQUIRED_MESSAGE_NAME
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "INV"."MTL_ITEM_ATTRIBUTES"