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: AMS.AMS_COLUMNS_METADATA#

Source

View Text - Preformatted


select COLUMNS_METADATA_ID COLUMNS_METADATA_ID, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OBJECT_ATTRIBUTE OBJECT_ATTRIBUTE, OBJECT_TYPE OBJECT_TYPE, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, AK_REGION_CODE AK_REGION_CODE, AK_ATTRIBUTE_CODE AK_ATTRIBUTE_CODE, HTML_FORM_PARAM HTML_FORM_PARAM, DB_TABLE_NAME DB_TABLE_NAME, DB_COLUMN_NAME DB_COLUMN_NAME, SEEDED_FLAG SEEDED_FLAG, SEARCH_TYPE SEARCH_TYPE, SEARCH_QUERY SEARCH_QUERY, SEARCH_PARAM1 SEARCH_PARAM1, SEARCH_PARAM2 SEARCH_PARAM2, SEARCH_PARAM3 SEARCH_PARAM3, SEARCH_PARAM4 SEARCH_PARAM4, SEARCH_PARAM5 SEARCH_PARAM5, SEARCH_PARAM6 SEARCH_PARAM6, SEARCH_PARAM7 SEARCH_PARAM7, SEARCH_PARAM8 SEARCH_PARAM8, SEARCH_PARAM9 SEARCH_PARAM9, SEARCH_PARAM10 SEARCH_PARAM10, SEARCH_PARAM11 SEARCH_PARAM11, SEARCH_PARAM12 SEARCH_PARAM12, SEARCH_PARAM13 SEARCH_PARAM13, SEARCH_PARAM14 SEARCH_PARAM14, SEARCH_PARAM15 SEARCH_PARAM15, OBJECT_RULE_ID OBJECT_RULE_ID, SEARCH_DISPLAY_ALLOWED_FLAG SEARCH_DISPLAY_ALLOWED_FLAG, SEARCH_CONDITION_ALLOWED_FLAG SEARCH_CONDITION_ALLOWED_FLAG, SEARCH_GROUP SEARCH_GROUP, SEARCH_EXCLUSION_GROUP SEARCH_EXCLUSION_GROUP, SEARCH_OPERATOR_EXCLUSION_ID SEARCH_OPERATOR_EXCLUSION_ID, SEARCH_COLSPAN SEARCH_COLSPAN, APPLICATION_ID APPLICATION_ID, SEARCH_DISPLAY_SCALE SEARCH_DISPLAY_SCALE, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_COLUMNS_METADATA"

View Text - HTML Formatted

SELECT COLUMNS_METADATA_ID COLUMNS_METADATA_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OBJECT_ATTRIBUTE OBJECT_ATTRIBUTE
, OBJECT_TYPE OBJECT_TYPE
, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE
, AK_REGION_CODE AK_REGION_CODE
, AK_ATTRIBUTE_CODE AK_ATTRIBUTE_CODE
, HTML_FORM_PARAM HTML_FORM_PARAM
, DB_TABLE_NAME DB_TABLE_NAME
, DB_COLUMN_NAME DB_COLUMN_NAME
, SEEDED_FLAG SEEDED_FLAG
, SEARCH_TYPE SEARCH_TYPE
, SEARCH_QUERY SEARCH_QUERY
, SEARCH_PARAM1 SEARCH_PARAM1
, SEARCH_PARAM2 SEARCH_PARAM2
, SEARCH_PARAM3 SEARCH_PARAM3
, SEARCH_PARAM4 SEARCH_PARAM4
, SEARCH_PARAM5 SEARCH_PARAM5
, SEARCH_PARAM6 SEARCH_PARAM6
, SEARCH_PARAM7 SEARCH_PARAM7
, SEARCH_PARAM8 SEARCH_PARAM8
, SEARCH_PARAM9 SEARCH_PARAM9
, SEARCH_PARAM10 SEARCH_PARAM10
, SEARCH_PARAM11 SEARCH_PARAM11
, SEARCH_PARAM12 SEARCH_PARAM12
, SEARCH_PARAM13 SEARCH_PARAM13
, SEARCH_PARAM14 SEARCH_PARAM14
, SEARCH_PARAM15 SEARCH_PARAM15
, OBJECT_RULE_ID OBJECT_RULE_ID
, SEARCH_DISPLAY_ALLOWED_FLAG SEARCH_DISPLAY_ALLOWED_FLAG
, SEARCH_CONDITION_ALLOWED_FLAG SEARCH_CONDITION_ALLOWED_FLAG
, SEARCH_GROUP SEARCH_GROUP
, SEARCH_EXCLUSION_GROUP SEARCH_EXCLUSION_GROUP
, SEARCH_OPERATOR_EXCLUSION_ID SEARCH_OPERATOR_EXCLUSION_ID
, SEARCH_COLSPAN SEARCH_COLSPAN
, APPLICATION_ID APPLICATION_ID
, SEARCH_DISPLAY_SCALE SEARCH_DISPLAY_SCALE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_COLUMNS_METADATA"