View: OKC_TERMS_PREVIEW_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_TERMS_PREVIEW_V

View Text

SELECT KART.ID
, 'ARTICLE'
, KART.SCN_ID
, KART.DOCUMENT_ID
, KART.DOCUMENT_TYPE
, KART.DISPLAY_SEQUENCE
, KART.LABEL
, OKC_TERMS_UTIL_PVT.GET_ARTICLE_NAME( ART.ARTICLE_ID
, VER.ARTICLE_VERSION_ID)
, NULL
, NULL
, NULL
, NULL
, ART.ARTICLE_NUMBER
, VER.INSERT_BY_REFERENCE
, VER.REFERENCE_TEXT
, VER.ARTICLE_TEXT
, VER.ARTICLE_VERSION_ID
, ART.ARTICLE_ID
FROM OKC_K_ARTICLES_B KART
, OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS VER
, OKC_TERMS_TEMPLATES_ALL TMPL
WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
AND ART.ARTICLE_ID = VER.ARTICLE_ID
AND KART.DOCUMENT_TYPE = 'TEMPLATE'
AND KART.DOCUMENT_ID = TMPL.TEMPLATE_ID
AND VER.ARTICLE_VERSION_ID = OKC_TERMS_UTIL_PVT.GET_LATEST_TMPL_ART_VERSION_ID( ART.ARTICLE_ID
, TMPL.START_DATE
, TMPL.END_DATE
, TMPL.STATUS_CODE
, KART.DOCUMENT_TYPE
, KART.DOCUMENT_ID) UNION ALL SELECT KART.ID
, 'ARTICLE'
, KART.SCN_ID
, KART.DOCUMENT_ID
, KART.DOCUMENT_TYPE
, KART.DISPLAY_SEQUENCE
, KART.LABEL
, OKC_TERMS_UTIL_PVT.GET_ARTICLE_NAME( ART.ARTICLE_ID
, VER.ARTICLE_VERSION_ID)
, KART.AMENDMENT_DESCRIPTION
, KART.SUMMARY_AMEND_OPERATION_CODE
, AMEND_CODE.MEANING
, KART.PRINT_TEXT_YN
, ART.ARTICLE_NUMBER
, VER.INSERT_BY_REFERENCE
, VER.REFERENCE_TEXT
, VER.ARTICLE_TEXT
, VER.ARTICLE_VERSION_ID
, ART.ARTICLE_ID
FROM OKC_K_ARTICLES_B KART
, OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS VER
, FND_LOOKUPS AMEND_CODE
WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
AND KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
AND AMEND_CODE.LOOKUP_TYPE(+)= 'OKC_AMEND_OPN_CODE'
AND AMEND_CODE.LOOKUP_CODE (+) = KART.SUMMARY_AMEND_OPERATION_CODE
AND KART.DOCUMENT_TYPE <> 'TEMPLATE' UNION ALL SELECT SEC.ID
, 'SECTION'
, SEC.SCN_ID
, SEC.DOCUMENT_ID
, SEC.DOCUMENT_TYPE
, SEC.SECTION_SEQUENCE
, SEC.LABEL
, SEC.HEADING
, SEC.AMENDMENT_DESCRIPTION
, SEC.SUMMARY_AMEND_OPERATION_CODE
, AMEND_CODE.MEANING SAOC_MEANING
, NULL
, NULL
, NULL
, NULL
, OKC_TERMS_UTIL_GRP.EMPCLOB
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM OKC_SECTIONS_B SEC
, FND_LOOKUPS AMEND_CODE
WHERE SEC.PRINT_YN = 'Y'
AND AMEND_CODE.LOOKUP_TYPE(+)= 'OKC_AMEND_OPN_CODE'
AND AMEND_CODE.LOOKUP_CODE (+) = SEC.SUMMARY_AMEND_OPERATION_CODE

Columns