eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKC_TERMS_ALTERNATE_ART_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'