eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: EGO.EGO_ATTR_GROUP_COLS_INTF#

Source

View Text - Preformatted


select SET_PROCESS_ID SET_PROCESS_ID, ATTR_ID ATTR_ID, APPLICATION_ID APPLICATION_ID, ATTR_GROUP_TYPE ATTR_GROUP_TYPE, ATTR_GROUP_ID ATTR_GROUP_ID, ATTR_GROUP_NAME ATTR_GROUP_NAME, INTERNAL_NAME INTERNAL_NAME, DISPLAY_NAME DISPLAY_NAME, DESCRIPTION DESCRIPTION, SEQUENCE SEQUENCE, APPLICATION_COLUMN_NAME APPLICATION_COLUMN_NAME, DATA_TYPE DATA_TYPE, SEARCH_FLAG SEARCH_FLAG, UNIQUE_KEY_FLAG UNIQUE_KEY_FLAG, INFO_1 INFO_1, UOM_CLASS UOM_CLASS, CONTROL_LEVEL CONTROL_LEVEL, VIEW_IN_HIERARCHY_CODE VIEW_IN_HIERARCHY_CODE, EDIT_IN_HIERARCHY_CODE EDIT_IN_HIERARCHY_CODE, CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL, READ_ONLY_FLAG READ_ONLY_FLAG, ENABLED_FLAG ENABLED_FLAG, REQUIRED_FLAG REQUIRED_FLAG, SECURITY_ENABLED_FLAG SECURITY_ENABLED_FLAG, DISPLAY_CODE DISPLAY_CODE, DEFAULT_VALUE DEFAULT_VALUE, ATTRIBUTE_CODE ATTRIBUTE_CODE, MAXIMUM_DESCRIPTION_LEN MAXIMUM_DESCRIPTION_LEN, CONCATENATION_DESCRIPTION_LEN CONCATENATION_DESCRIPTION_LEN, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID, FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME, TRANSACTION_ID TRANSACTION_ID, PROCESS_STATUS PROCESS_STATUS, TRANSACTION_TYPE TRANSACTION_TYPE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "EGO"."EGO_ATTR_GROUP_COLS_INTF"

View Text - HTML Formatted

SELECT SET_PROCESS_ID SET_PROCESS_ID
, ATTR_ID ATTR_ID
, APPLICATION_ID APPLICATION_ID
, ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, ATTR_GROUP_ID ATTR_GROUP_ID
, ATTR_GROUP_NAME ATTR_GROUP_NAME
, INTERNAL_NAME INTERNAL_NAME
, DISPLAY_NAME DISPLAY_NAME
, DESCRIPTION DESCRIPTION
, SEQUENCE SEQUENCE
, APPLICATION_COLUMN_NAME APPLICATION_COLUMN_NAME
, DATA_TYPE DATA_TYPE
, SEARCH_FLAG SEARCH_FLAG
, UNIQUE_KEY_FLAG UNIQUE_KEY_FLAG
, INFO_1 INFO_1
, UOM_CLASS UOM_CLASS
, CONTROL_LEVEL CONTROL_LEVEL
, VIEW_IN_HIERARCHY_CODE VIEW_IN_HIERARCHY_CODE
, EDIT_IN_HIERARCHY_CODE EDIT_IN_HIERARCHY_CODE
, CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL
, READ_ONLY_FLAG READ_ONLY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, REQUIRED_FLAG REQUIRED_FLAG
, SECURITY_ENABLED_FLAG SECURITY_ENABLED_FLAG
, DISPLAY_CODE DISPLAY_CODE
, DEFAULT_VALUE DEFAULT_VALUE
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, MAXIMUM_DESCRIPTION_LEN MAXIMUM_DESCRIPTION_LEN
, CONCATENATION_DESCRIPTION_LEN CONCATENATION_DESCRIPTION_LEN
, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, TRANSACTION_ID TRANSACTION_ID
, PROCESS_STATUS PROCESS_STATUS
, TRANSACTION_TYPE TRANSACTION_TYPE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "EGO"."EGO_ATTR_GROUP_COLS_INTF"