Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_TERMS_ART_VERSIONS_V |
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'