VIEW: APPS.OKC_K_ATE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'