DBA Data[Home] [Help]

VIEW: APPS.OKL_VP_STD_ARTICLES_UV

Source

View Text - Preformatted

SELECT SAE.NAME NAME, SAV.TEXT TEXT, SAV.SAE_ID SAV_SAE_ID, SAV.SAV_RELEASE SAV_SAV_RELEASE FROM OKC_STD_ARTICLES_V SAE,OKC_STD_ART_VERSIONS_V SAV WHERE SAV.SAE_ID = SAE.ID
View Text - HTML Formatted

SELECT SAE.NAME NAME
, SAV.TEXT TEXT
, SAV.SAE_ID SAV_SAE_ID
, SAV.SAV_RELEASE SAV_SAV_RELEASE
FROM OKC_STD_ARTICLES_V SAE
, OKC_STD_ART_VERSIONS_V SAV
WHERE SAV.SAE_ID = SAE.ID