VIEW: OKC.OKC_VALUESETS_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_ID INTERFACE_ID, BATCH_NUMBER BATCH_NUMBER, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME, VALIDATION_TYPE VALIDATION_TYPE, PROCESS_STATUS PROCESS_STATUS, ACTION ACTION, FORMAT_TYPE FORMAT_TYPE, MAXIMUM_SIZE MAXIMUM_SIZE, DESCRIPTION DESCRIPTION, MINIMUM_VALUE MINIMUM_VALUE, MAXIMUM_VALUE MAXIMUM_VALUE, NUMBER_PRECISION NUMBER_PRECISION, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, UPPERCASE_ONLY_FLAG UPPERCASE_ONLY_FLAG, NUMBER_ONLY_FLAG NUMBER_ONLY_FLAG from "OKC"."OKC_VALUESETS_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_ID INTERFACE_ID
, BATCH_NUMBER BATCH_NUMBER
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, VALIDATION_TYPE VALIDATION_TYPE
, PROCESS_STATUS PROCESS_STATUS
, ACTION ACTION
, FORMAT_TYPE FORMAT_TYPE
, MAXIMUM_SIZE MAXIMUM_SIZE
, DESCRIPTION DESCRIPTION
, MINIMUM_VALUE MINIMUM_VALUE
, MAXIMUM_VALUE MAXIMUM_VALUE
, NUMBER_PRECISION NUMBER_PRECISION
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, UPPERCASE_ONLY_FLAG UPPERCASE_ONLY_FLAG
, NUMBER_ONLY_FLAG NUMBER_ONLY_FLAG
FROM "OKC"."OKC_VALUESETS_INTERFACE"