VIEW: APPS.OKC_TERMS_PREVIEW_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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