VIEW: AMS.AMS_LIST_SRC_TYPES#

Source

View Text - Preformatted

select LIST_SOURCE_TYPE_ID LIST_SOURCE_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, LIST_SOURCE_NAME LIST_SOURCE_NAME, LIST_SOURCE_TYPE LIST_SOURCE_TYPE, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME, MASTER_SOURCE_TYPE_FLAG MASTER_SOURCE_TYPE_FLAG, SOURCE_OBJECT_PK_FIELD SOURCE_OBJECT_PK_FIELD, ENABLED_FLAG ENABLED_FLAG, DESCRIPTION DESCRIPTION, SECURITY_GROUP_ID SECURITY_GROUP_ID, VIEW_APPLICATION_ID VIEW_APPLICATION_ID, JAVA_CLASS_NAME JAVA_CLASS_NAME, ARC_ACT_SRC_USED_BY ARC_ACT_SRC_USED_BY, SOURCE_CATEGORY SOURCE_CATEGORY, IMPORT_TYPE IMPORT_TYPE, REMOTE_FLAG REMOTE_FLAG, DATABASE_LINK DATABASE_LINK, SEEDED_FLAG SEEDED_FLAG, BASED_ON_TCA_FLAG BASED_ON_TCA_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "AMS"."AMS_LIST_SRC_TYPES"

View Text - HTML Formatted

SELECT LIST_SOURCE_TYPE_ID LIST_SOURCE_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
, LIST_SOURCE_NAME LIST_SOURCE_NAME
, LIST_SOURCE_TYPE LIST_SOURCE_TYPE
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME
, MASTER_SOURCE_TYPE_FLAG MASTER_SOURCE_TYPE_FLAG
, SOURCE_OBJECT_PK_FIELD SOURCE_OBJECT_PK_FIELD
, ENABLED_FLAG ENABLED_FLAG
, DESCRIPTION DESCRIPTION
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, JAVA_CLASS_NAME JAVA_CLASS_NAME
, ARC_ACT_SRC_USED_BY ARC_ACT_SRC_USED_BY
, SOURCE_CATEGORY SOURCE_CATEGORY
, IMPORT_TYPE IMPORT_TYPE
, REMOTE_FLAG REMOTE_FLAG
, DATABASE_LINK DATABASE_LINK
, SEEDED_FLAG SEEDED_FLAG
, BASED_ON_TCA_FLAG BASED_ON_TCA_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AMS"."AMS_LIST_SRC_TYPES"