VIEW: OKC.OKC_K_ARTICLES_B#

Source

View Text - Preformatted

select ID ID, SAV_SAE_ID SAV_SAE_ID, SAV_SAV_RELEASE SAV_SAV_RELEASE, SBT_CODE SBT_CODE, CAT_TYPE CAT_TYPE, CHR_ID CHR_ID, CLE_ID CLE_ID, CAT_ID CAT_ID, DNZ_CHR_ID DNZ_CHR_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, FULLTEXT_YN FULLTEXT_YN, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID, OLD_ID OLD_ID, DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_ID DOCUMENT_ID, SOURCE_FLAG SOURCE_FLAG, MANDATORY_YN MANDATORY_YN, SCN_ID SCN_ID, LABEL LABEL, DISPLAY_SEQUENCE DISPLAY_SEQUENCE, AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION, ARTICLE_VERSION_ID ARTICLE_VERSION_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, AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE, SUMMARY_AMEND_OPERATION_CODE SUMMARY_AMEND_OPERATION_CODE, CHANGE_NONSTD_YN CHANGE_NONSTD_YN, PRINT_TEXT_YN PRINT_TEXT_YN, REF_ARTICLE_ID REF_ARTICLE_ID, REF_ARTICLE_VERSION_ID REF_ARTICLE_VERSION_ID, ORIG_ARTICLE_ID ORIG_ARTICLE_ID, LAST_AMENDED_BY LAST_AMENDED_BY, LAST_AMENDMENT_DATE LAST_AMENDMENT_DATE, MANDATORY_RWA MANDATORY_RWA from "OKC"."OKC_K_ARTICLES_B"

View Text - HTML Formatted

SELECT ID ID
, SAV_SAE_ID SAV_SAE_ID
, SAV_SAV_RELEASE SAV_SAV_RELEASE
, SBT_CODE SBT_CODE
, CAT_TYPE CAT_TYPE
, CHR_ID CHR_ID
, CLE_ID CLE_ID
, CAT_ID CAT_ID
, DNZ_CHR_ID DNZ_CHR_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, FULLTEXT_YN FULLTEXT_YN
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OLD_ID OLD_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_ID DOCUMENT_ID
, SOURCE_FLAG SOURCE_FLAG
, MANDATORY_YN MANDATORY_YN
, SCN_ID SCN_ID
, LABEL LABEL
, DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
, ARTICLE_VERSION_ID ARTICLE_VERSION_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
, AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE
, SUMMARY_AMEND_OPERATION_CODE SUMMARY_AMEND_OPERATION_CODE
, CHANGE_NONSTD_YN CHANGE_NONSTD_YN
, PRINT_TEXT_YN PRINT_TEXT_YN
, REF_ARTICLE_ID REF_ARTICLE_ID
, REF_ARTICLE_VERSION_ID REF_ARTICLE_VERSION_ID
, ORIG_ARTICLE_ID ORIG_ARTICLE_ID
, LAST_AMENDED_BY LAST_AMENDED_BY
, LAST_AMENDMENT_DATE LAST_AMENDMENT_DATE
, MANDATORY_RWA MANDATORY_RWA
FROM "OKC"."OKC_K_ARTICLES_B"