View: OKC_K_ATE_V

Product:	OKC - Contracts Core
Description:	View to provide the contract using the std articles
Implementation/DBA Data:	APPS.OKC_K_ATE_V

View Text

SELECT DISTINCT A.ID ID
, A.CONTRACT_NUMBER CONTRACT_NUMBER
, A.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, A.SHORT_DESCRIPTION SHORT_DESCRIPTION
, B.SAV_SAE_ID SAV_SAE_ID
, NVL(VERS.SAV_RELEASE
, VERS.ARTICLE_VERSION_NUMBER) SAV_SAV_RELEASE
FROM OKC_K_HEADERS_V A
, OKC_K_ARTICLES_B B
, OKC_ARTICLE_VERSIONS VERS
, OKC_ARTICLES_V ART
WHERE DNZ_CHR_ID=A.ID
AND SAV_SAE_ID = ART.ARTICLE_ID
AND B.ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
AND ART.STANDARD_YN = 'Y'

Columns