Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_TERMS_ART_DETAILS_V |
SELECT KART.ID
, AA.ARTICLE_ID
, AA.ARTICLE_TITLE
, AA.ORG_ID
, AA.ARTICLE_NUMBER
, AA.STANDARD_YN
, AA.ARTICLE_INTENT
, AA.ARTICLE_LANGUAGE
, AA.ARTICLE_TYPE
, AA.ORIG_SYSTEM_REFERENCE_CODE
, AA.ORIG_SYSTEM_REFERENCE_ID1
, AA.ORIG_SYSTEM_REFERENCE_ID2
, AA.CZ_TRANSFER_STATUS_FLAG
, AV.ARTICLE_VERSION_ID
, AV.ARTICLE_VERSION_NUMBER
, AV.ARTICLE_TEXT
, NVL(AV.PROVISION_YN
, 'N')
, AV.INSERT_BY_REFERENCE
, AV.LOCK_TEXT
, AV.GLOBAL_YN
, AV.ARTICLE_STATUS
, AV.SAV_RELEASE
, AV.START_DATE
, AV.END_DATE
, AV.ADOPTION_TYPE
, AV.STD_ARTICLE_VERSION_ID
, AV.DISPLAY_NAME
, AV.TRANSLATED_YN
, AV.ARTICLE_DESCRIPTION
, AV.DATE_APPROVED
, AV.DEFAULT_SECTION
, AV.REFERENCE_SOURCE
, AV.REFERENCE_TEXT
, AV.ORIG_SYSTEM_REFERENCE_CODE
, AV.ORIG_SYSTEM_REFERENCE_ID1
, AV.ORIG_SYSTEM_REFERENCE_ID2
, AV.ADDITIONAL_INSTRUCTIONS
, AV.VARIATION_DESCRIPTION
, AV.ATTRIBUTE_CATEGORY
, AV.ATTRIBUTE1
, AV.ATTRIBUTE2
, AV.ATTRIBUTE3
, AV.ATTRIBUTE4
, AV.ATTRIBUTE5
, AV.ATTRIBUTE6
, AV.ATTRIBUTE7
, AV.ATTRIBUTE8
, AV.ATTRIBUTE9
, AV.ATTRIBUTE10
, AV.ATTRIBUTE11
, AV.ATTRIBUTE12
, AV.ATTRIBUTE13
, AV.ATTRIBUTE14
, AV.ATTRIBUTE15
, KART.MANDATORY_YN
, KART.AMENDMENT_DESCRIPTION
, KART.AMENDMENT_OPERATION_CODE
, NVL(KART.PRINT_TEXT_YN
, 'N')
, KART.CHANGE_NONSTD_YN
, KART.OBJECT_VERSION_NUMBER
, KART.CREATED_BY
, KART.CREATION_DATE
, KART.LAST_UPDATED_BY
, KART.LAST_UPDATE_DATE
, KART.LAST_UPDATE_LOGIN
, KART.SUMMARY_AMEND_OPERATION_CODE
, AV.EDITED_IN_WORD
, AV.ARTICLE_TEXT_IN_WORD
FROM OKC_ARTICLES_ALL AA
, OKC_ARTICLE_VERSIONS AV
, OKC_K_ARTICLES_B KART
WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
AND KART.SAV_SAE_ID = AA.ARTICLE_ID