VIEW: OKC.OKC_TERMS_TEMPLATES_ALL#

Source

View Text - Preformatted

select TEMPLATE_ID TEMPLATE_ID, TEMPLATE_NAME TEMPLATE_NAME, INTENT INTENT, STATUS_CODE STATUS_CODE, START_DATE START_DATE, END_DATE END_DATE, GLOBAL_FLAG GLOBAL_FLAG, INSTRUCTION_TEXT INSTRUCTION_TEXT, DESCRIPTION DESCRIPTION, WORKING_COPY_FLAG WORKING_COPY_FLAG, PARENT_TEMPLATE_ID PARENT_TEMPLATE_ID, CONTRACT_EXPERT_ENABLED CONTRACT_EXPERT_ENABLED, TEMPLATE_MODEL_ID TEMPLATE_MODEL_ID, TMPL_NUMBERING_SCHEME TMPL_NUMBERING_SCHEME, PRINT_TEMPLATE_ID PRINT_TEMPLATE_ID, APPROVAL_WF_KEY APPROVAL_WF_KEY, CZ_EXPORT_WF_KEY CZ_EXPORT_WF_KEY, 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, ORG_ID ORG_ID, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HIDE_YN HIDE_YN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, XPRT_REQUEST_ID XPRT_REQUEST_ID, XPRT_CLAUSE_MANDATORY_FLAG XPRT_CLAUSE_MANDATORY_FLAG, XPRT_SCN_CODE XPRT_SCN_CODE, LANGUAGE LANGUAGE, TRANSLATED_FROM_TMPL_ID TRANSLATED_FROM_TMPL_ID, CLS_ENABLED CLS_ENABLED from "OKC"."OKC_TERMS_TEMPLATES_ALL"

View Text - HTML Formatted

SELECT TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_NAME TEMPLATE_NAME
, INTENT INTENT
, STATUS_CODE STATUS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, GLOBAL_FLAG GLOBAL_FLAG
, INSTRUCTION_TEXT INSTRUCTION_TEXT
, DESCRIPTION DESCRIPTION
, WORKING_COPY_FLAG WORKING_COPY_FLAG
, PARENT_TEMPLATE_ID PARENT_TEMPLATE_ID
, CONTRACT_EXPERT_ENABLED CONTRACT_EXPERT_ENABLED
, TEMPLATE_MODEL_ID TEMPLATE_MODEL_ID
, TMPL_NUMBERING_SCHEME TMPL_NUMBERING_SCHEME
, PRINT_TEMPLATE_ID PRINT_TEMPLATE_ID
, APPROVAL_WF_KEY APPROVAL_WF_KEY
, CZ_EXPORT_WF_KEY CZ_EXPORT_WF_KEY
, 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
, ORG_ID ORG_ID
, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE
, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1
, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, HIDE_YN HIDE_YN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, XPRT_REQUEST_ID XPRT_REQUEST_ID
, XPRT_CLAUSE_MANDATORY_FLAG XPRT_CLAUSE_MANDATORY_FLAG
, XPRT_SCN_CODE XPRT_SCN_CODE
, LANGUAGE LANGUAGE
, TRANSLATED_FROM_TMPL_ID TRANSLATED_FROM_TMPL_ID
, CLS_ENABLED CLS_ENABLED
FROM "OKC"."OKC_TERMS_TEMPLATES_ALL"