VIEW: APPS.OKC_TERMS_ART_VERSIONS_V

Source

View Text - Preformatted

SELECT art.article_id ARTICLE_ID, ver.article_version_id ARTICLE_VERSION_ID, ver.article_version_number, art.article_title ARTICLE_TITLE, ver.article_status ARTICLE_STATUS, ver.display_name DISPLAY_NAME, art.article_type ARTICLE_TYPE, art.article_number ARTICLE_NUMBER, art.article_intent ARTICLE_INTENT, ver.article_text ARTICLE_TEXT, ver.article_description ARTICLE_DESCRIPTION, ver.ADDITIONAL_INSTRUCTIONS ADDITIONAL_INSTRUCTIONS, ver.start_date START_DATE, ver.end_date END_DATE, ver.provision_yn PROVISION_YN, ver.default_section DEFAULT_SECTION , art.org_id ORG_ID, ver.LOCK_TEXT, ver.GLOBAL_YN, ver.INSERT_BY_REFERENCE, ver.ADOPTION_TYPE FROM okc_articles_all art, okc_article_versions ver WHERE art.article_id = ver.article_id and art.STANDARD_YN = 'Y' UNION ALL select art.article_id, ver.article_version_id, ver.article_version_number, art.article_title, adp.adoption_status, ver.display_name, art.article_type, art.article_number, art.article_intent, ver.article_text, ver.article_description, ver.ADDITIONAL_INSTRUCTIONS, ver.start_date, ver.end_date, ver.provision_yn, ver.default_section, adp.local_org_id , ver.LOCK_TEXT, ver.GLOBAL_YN, ver.INSERT_BY_REFERENCE, ver.ADOPTION_TYPE from okc_articles_all art, okc_article_versions ver, okc_article_adoptions adp where art.article_id = ver.article_id and art.STANDARD_YN = 'Y' and ver.global_yn = 'Y' and ver.ARTICLE_STATUS = 'APPROVED' and adp.global_article_version_id = ver.article_version_id and adp.adoption_type = 'ADOPTED' and adp.adoption_status = 'APPROVED'

View Text - HTML Formatted

SELECT ART.ARTICLE_ID ARTICLE_ID
, VER.ARTICLE_VERSION_ID ARTICLE_VERSION_ID
, VER.ARTICLE_VERSION_NUMBER
, ART.ARTICLE_TITLE ARTICLE_TITLE
, VER.ARTICLE_STATUS ARTICLE_STATUS
, VER.DISPLAY_NAME DISPLAY_NAME
, ART.ARTICLE_TYPE ARTICLE_TYPE
, ART.ARTICLE_NUMBER ARTICLE_NUMBER
, ART.ARTICLE_INTENT ARTICLE_INTENT
, VER.ARTICLE_TEXT ARTICLE_TEXT
, VER.ARTICLE_DESCRIPTION ARTICLE_DESCRIPTION
, VER.ADDITIONAL_INSTRUCTIONS ADDITIONAL_INSTRUCTIONS
, VER.START_DATE START_DATE
, VER.END_DATE END_DATE
, VER.PROVISION_YN PROVISION_YN
, VER.DEFAULT_SECTION DEFAULT_SECTION
, ART.ORG_ID ORG_ID
, VER.LOCK_TEXT
, VER.GLOBAL_YN
, VER.INSERT_BY_REFERENCE
, VER.ADOPTION_TYPE
FROM OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS VER
WHERE ART.ARTICLE_ID = VER.ARTICLE_ID
AND ART.STANDARD_YN = 'Y' UNION ALL SELECT ART.ARTICLE_ID
, VER.ARTICLE_VERSION_ID
, VER.ARTICLE_VERSION_NUMBER
, ART.ARTICLE_TITLE
, ADP.ADOPTION_STATUS
, VER.DISPLAY_NAME
, ART.ARTICLE_TYPE
, ART.ARTICLE_NUMBER
, ART.ARTICLE_INTENT
, VER.ARTICLE_TEXT
, VER.ARTICLE_DESCRIPTION
, VER.ADDITIONAL_INSTRUCTIONS
, VER.START_DATE
, VER.END_DATE
, VER.PROVISION_YN
, VER.DEFAULT_SECTION
, ADP.LOCAL_ORG_ID
, VER.LOCK_TEXT
, VER.GLOBAL_YN
, VER.INSERT_BY_REFERENCE
, VER.ADOPTION_TYPE
FROM OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS VER
, OKC_ARTICLE_ADOPTIONS ADP
WHERE ART.ARTICLE_ID = VER.ARTICLE_ID
AND ART.STANDARD_YN = 'Y'
AND VER.GLOBAL_YN = 'Y'
AND VER.ARTICLE_STATUS = 'APPROVED'
AND ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
AND ADP.ADOPTION_TYPE = 'ADOPTED'
AND ADP.ADOPTION_STATUS = 'APPROVED'