VIEW: OKC.OKC_MLP_TEMPLATE_USAGES#

Source

View Text - Preformatted

select DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_ID DOCUMENT_ID, TEMPLATE_ID TEMPLATE_ID, DOC_NUMBERING_SCHEME DOC_NUMBERING_SCHEME, DOCUMENT_NUMBER DOCUMENT_NUMBER, ARTICLE_EFFECTIVE_DATE ARTICLE_EFFECTIVE_DATE, CONFIG_HEADER_ID CONFIG_HEADER_ID, CONFIG_REVISION_NUMBER CONFIG_REVISION_NUMBER, VALID_CONFIG_YN VALID_CONFIG_YN, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LOCK_TERMS_FLAG LOCK_TERMS_FLAG, LOCKED_BY_USER_ID LOCKED_BY_USER_ID, PRIMARY_TEMPLATE PRIMARY_TEMPLATE from "OKC"."OKC_MLP_TEMPLATE_USAGES"

View Text - HTML Formatted

SELECT DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_ID DOCUMENT_ID
, TEMPLATE_ID TEMPLATE_ID
, DOC_NUMBERING_SCHEME DOC_NUMBERING_SCHEME
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, ARTICLE_EFFECTIVE_DATE ARTICLE_EFFECTIVE_DATE
, CONFIG_HEADER_ID CONFIG_HEADER_ID
, CONFIG_REVISION_NUMBER CONFIG_REVISION_NUMBER
, VALID_CONFIG_YN VALID_CONFIG_YN
, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE
, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1
, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LOCK_TERMS_FLAG LOCK_TERMS_FLAG
, LOCKED_BY_USER_ID LOCKED_BY_USER_ID
, PRIMARY_TEMPLATE PRIMARY_TEMPLATE
FROM "OKC"."OKC_MLP_TEMPLATE_USAGES"