View: OKC_TERMS_DOC_LATEST_ART_V

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

View Text

SELECT OKC_TERMS_UTIL_PVT.GET_ARTICLE_NAME(K.SAV_SAE_ID
, K.ARTICLE_VERSION_ID) ARTICLE_NAME
, OKC_TERMS_UTIL_PVT.GET_SECTION_LABEL(K.SCN_ID) SECTION_LABEL
, OKC_TERMS_UTIL_PVT.GET_ARTICLE_VERSION_NUMBER(K.ARTICLE_VERSION_ID) ARTICLE_VERSION_NUMBER
, OKC_TERMS_UTIL_PVT.GET_LATEST_ART_VERSION_NO(K.SAV_SAE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID) LATEST_ARTICLE_VERSION_NUMBER
, OKC_TERMS_UTIL_PVT.GET_LATEST_ART_VERSION_ID(K.SAV_SAE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID) LATEST_ARTICLE_VERSION_ID
, K.SAV_SAE_ID ARTICLE_ID
, K.ARTICLE_VERSION_ID
, K.SCN_ID SECTION_ID
, 'ARTICLE' OBJECT_TYPE
, K.ID KARTICLES_ID
, K.DOCUMENT_TYPE DOCUMENT_TYPE
, K.DOCUMENT_ID DOCUMENT_ID
, K.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OKC_TERMS_UTIL_PVT.GET_LOCAL_ARTICLE_ID(K.SAV_SAE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID) LOCAL_ARTICLE_ID
, OKC_TERMS_UTIL_PVT.GET_ADOPTION_TYPE(K.SAV_SAE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID) ADOPTION_TYPE
, K.ORIG_SYSTEM_REFERENCE_CODE
, K.ORIG_SYSTEM_REFERENCE_ID1
FROM OKC_K_ARTICLES_B K
, OKC_ARTICLES_ALL ART
WHERE K.SAV_SAE_ID = ART.ARTICLE_ID
AND ART.STANDARD_YN = 'Y'
AND K.ARTICLE_VERSION_ID IS NOT NULL

Columns