VIEW: APPS.OKC_TERMS_DOC_LATEST_ART_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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