VIEW: AMS.AMS_SETUP_TYPES#

Source

View Text - Preformatted

select SETUP_TYPE_ID SETUP_TYPE_ID, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OBJECT_TYPE OBJECT_TYPE, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, DISPLAY_SEQUENCE_NO DISPLAY_SEQUENCE_NO, SETUP_ATTRIBUTE SETUP_ATTRIBUTE, MANDATORY_FLAG MANDATORY_FLAG, USER_INTERFACE_FUNCTION USER_INTERFACE_FUNCTION, SECURITY_GROUP_ID SECURITY_GROUP_ID, FUNCTION_NAME FUNCTION_NAME, PARENT_DISPLAY_SEQUENCE PARENT_DISPLAY_SEQUENCE, PARENT_FUNCTION_NAME PARENT_FUNCTION_NAME, PARENT_SETUP_ATTRIBUTE PARENT_SETUP_ATTRIBUTE, SHOW_IN_REPORT SHOW_IN_REPORT, SHOW_IN_CUE_CARD SHOW_IN_CUE_CARD, RELATED_AK_ATTRIBUTE RELATED_AK_ATTRIBUTE, APPLICATION_ID APPLICATION_ID, COPY_ALLOWED_FLAG COPY_ALLOWED_FLAG, ESSENTIAL_SEQ_NUM ESSENTIAL_SEQ_NUM, USAGE USAGE, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_SETUP_TYPES"

View Text - HTML Formatted

SELECT SETUP_TYPE_ID SETUP_TYPE_ID
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OBJECT_TYPE OBJECT_TYPE
, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE
, DISPLAY_SEQUENCE_NO DISPLAY_SEQUENCE_NO
, SETUP_ATTRIBUTE SETUP_ATTRIBUTE
, MANDATORY_FLAG MANDATORY_FLAG
, USER_INTERFACE_FUNCTION USER_INTERFACE_FUNCTION
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, FUNCTION_NAME FUNCTION_NAME
, PARENT_DISPLAY_SEQUENCE PARENT_DISPLAY_SEQUENCE
, PARENT_FUNCTION_NAME PARENT_FUNCTION_NAME
, PARENT_SETUP_ATTRIBUTE PARENT_SETUP_ATTRIBUTE
, SHOW_IN_REPORT SHOW_IN_REPORT
, SHOW_IN_CUE_CARD SHOW_IN_CUE_CARD
, RELATED_AK_ATTRIBUTE RELATED_AK_ATTRIBUTE
, APPLICATION_ID APPLICATION_ID
, COPY_ALLOWED_FLAG COPY_ALLOWED_FLAG
, ESSENTIAL_SEQ_NUM ESSENTIAL_SEQ_NUM
, USAGE USAGE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_SETUP_TYPES"