View: OKC_TERMS_ALTERNATE_ART_V

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

View Text

SELECT R.TARGET_ARTICLE_ID ALT_ARTICLE_ID
, ART.ARTICLE_TITLE ALT_ARTICLE_NAME
, V.DISPLAY_NAME
, OKC_TERMS_UTIL_PVT.GET_LATEST_ART_VERSION_ID(R.TARGET_ARTICLE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID) LATEST_ARTICLE_VERSION_ID
, SUBSTR(V.ARTICLE_DESCRIPTION
, 1
, 100) ARTICLE_DESCRIPTION
, V.ARTICLE_TEXT ARTICLE_TEXT
, SUBSTR(V.ADDITIONAL_INSTRUCTIONS
, 1
, 1000) INSTRUCTION_TEXT
, R.ORG_ID RELATIONSHIP_ORG_ID
, K.ID KARTICLES_ID
, K.DOCUMENT_TYPE DOCUMENT_TYPE
, K.DOCUMENT_ID DOCUMENT_ID
, K.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 'CURRENTDISABLED' CURRENT_ARTICLE_FLAG
, 'N' SHOW_DETAILS_FLAG
FROM OKC_K_ARTICLES_B K
, OKC_ARTICLE_RELATNS_ALL R
, OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS V
WHERE K.SAV_SAE_ID = R.SOURCE_ARTICLE_ID
AND R.TARGET_ARTICLE_ID = V.ARTICLE_ID
AND V.ARTICLE_ID = ART.ARTICLE_ID
AND V.ARTICLE_VERSION_ID = OKC_TERMS_UTIL_PVT.GET_LATEST_ART_VERSION_ID(R.TARGET_ARTICLE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID)
AND R.RELATIONSHIP_TYPE = 'ALTERNATE'
AND R.ORG_ID = OKC_TERMS_UTIL_PVT.GET_CURRENT_ORG_ID(K.DOCUMENT_TYPE
, K.DOCUMENT_ID)
AND ( V.PROVISION_YN = 'N' OR (K.DOCUMENT_TYPE IN (SELECT DOCUMENT_TYPE
FROM OKC_BUS_DOC_TYPES_B
WHERE PROVISION_ALLOWED_YN = 'Y') ) ) UNION ALL SELECT K.SAV_SAE_ID
, ART.ARTICLE_TITLE ALT_ARTICLE_NAME
, V.DISPLAY_NAME
, K.ARTICLE_VERSION_ID LATEST_ARTICLE_VERSION_ID
, SUBSTR(V.ARTICLE_DESCRIPTION
, 1
, 100) ARTICLE_DESCRIPTION
, V.ARTICLE_TEXT ARTICLE_TEXT
, SUBSTR(V.ADDITIONAL_INSTRUCTIONS
, 1
, 1000) INSTRUCTION_TEXT
, TO_NUMBER(NULL) ORG_ID
, K.ID CAT_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID
, K.OBJECT_VERSION_NUMBER
, 'CURRENTENABLED'
, 'N'
FROM OKC_K_ARTICLES_B K
, OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS V
WHERE K.ARTICLE_VERSION_ID = V.ARTICLE_VERSION_ID
AND K.DOCUMENT_TYPE <> 'TEMPLATE'
AND V.ARTICLE_ID = ART.ARTICLE_ID UNION ALL SELECT K.SAV_SAE_ID
, ART.ARTICLE_TITLE ALT_ARTICLE_NAME
, V.DISPLAY_NAME
, OKC_TERMS_UTIL_PVT.GET_LATEST_ART_VERSION_ID(K.SAV_SAE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID) LATEST_ARTICLE_VERSION_ID
, SUBSTR(V.ARTICLE_DESCRIPTION
, 1
, 100) ARTICLE_DESCRIPTION
, V.ARTICLE_TEXT ARTICLE_TEXT
, SUBSTR(V.ADDITIONAL_INSTRUCTIONS
, 1
, 1000) INSTRUCTION_TEXT
, TO_NUMBER(NULL) ORG_ID
, K.ID CAT_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID
, K.OBJECT_VERSION_NUMBER
, 'CURRENTENABLED'
, 'N'
FROM OKC_K_ARTICLES_B K
, OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS V
WHERE K.SAV_SAE_ID = V.ARTICLE_ID
AND V.ARTICLE_ID = ART.ARTICLE_ID
AND V.ARTICLE_VERSION_ID = OKC_TERMS_UTIL_PVT.GET_LATEST_ART_VERSION_ID(K.SAV_SAE_ID
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID)
AND K.DOCUMENT_TYPE = 'TEMPLATE'

Columns