View: OKC_ARTICLES_GLOBAL_V

Product:	OKC - Contracts Core
Description:	The View is based on tables OKC_ARTICLES_ALL and OKC_ARTICLE_VERSIONS. Intended to provide information for Searching of Standard Clauses owned by Global Organization.
Implementation/DBA Data:	APPS.OKC_ARTICLES_GLOBAL_V

View Text

SELECT ART.ARTICLE_TITLE
, ART.ARTICLE_NUMBER
, ART.ARTICLE_TYPE
, TM.MEANING
, ARTV.ARTICLE_VERSION_NUMBER
, DECODE(ARTV.ARTICLE_STATUS
, 'APPROVED'
, DECODE(GREATEST(NVL(TRUNC(END_DATE)
, TRUNC(SYSDATE))+1
, TRUNC(SYSDATE))
, TRUNC(SYSDATE)
, 'EXPIRED'
, ARTV.ARTICLE_STATUS)
, ARTV.ARTICLE_STATUS) ARTICLE_STATUS
, SM.MEANING
, ARTV.GLOBAL_YN
, GM.MEANING
, ARTV.ARTICLE_TEXT
, ARTV.ARTICLE_DESCRIPTION
, ART.ORG_ID
, ART.ARTICLE_ID
, ARTV.ARTICLE_VERSION_ID
, ART.ARTICLE_INTENT
, IM.MEANING
, ARTV.PROVISION_YN
, PM.MEANING
, ARTV.START_DATE
, ARTV.END_DATE
, ARTV.DEFAULT_SECTION
, DSM.MEANING
FROM OKC_ARTICLES_ALL ART
, OKC_ARTICLE_VERSIONS ARTV
, OKC_LOOKUPS_V SM
, OKC_LOOKUPS_V TM
, OKC_LOOKUPS_V DSM
, OKC_LOOKUPS_V PM
, OKC_LOOKUPS_V IM
, OKC_LOOKUPS_V GM
WHERE ART.STANDARD_YN = 'Y'
AND ART.ARTICLE_ID = ARTV.ARTICLE_ID
AND TM.LOOKUP_TYPE(+) ='OKC_SUBJECT'
AND SM.LOOKUP_TYPE ='OKC_ARTICLE_STATUS'
AND DSM.LOOKUP_TYPE(+) ='OKC_ARTICLE_SECTION'
AND PM.LOOKUP_TYPE ='OKC_ARTICLE_PROVISION'
AND IM.LOOKUP_TYPE ='OKC_ARTICLE_INTENT'
AND GM.LOOKUP_TYPE='OKC_YN'
AND TM.LOOKUP_CODE(+) = ART.ARTICLE_TYPE
AND SM.LOOKUP_CODE = DECODE(ARTV.ARTICLE_STATUS
, 'APPROVED'
, DECODE(GREATEST(NVL(TRUNC(END_DATE)
, TRUNC(SYSDATE))+1
, TRUNC(SYSDATE))
, TRUNC(SYSDATE)
, 'EXPIRED'
, ARTV.ARTICLE_STATUS)
, ARTV.ARTICLE_STATUS)
AND DSM.LOOKUP_CODE(+) = ARTV.DEFAULT_SECTION
AND PM.LOOKUP_CODE = ARTV.PROVISION_YN
AND IM.LOOKUP_CODE = ART.ARTICLE_INTENT
AND GM.LOOKUP_CODE = ARTV.GLOBAL_YN

Columns