VIEW: APPS.OKS_K_COVERAGES_V

Source

View Text - Preformatted

SELECT OKSSRV.CLE_ID ,OKSSRV.COVERAGE_ID ,OKSSRV.STANDARD_COV_YN ,COVTL.NAME ,COVTL.ITEM_DESCRIPTION FROM OKS_K_LINES_B OKSSRV ,OKC_K_LINES_B COV ,OKC_K_LINES_TL COVTL WHERE COV.LSE_ID IN (2,15,20) AND COV.ID = OKSSRV.COVERAGE_ID AND COV.ID = COVTL.ID AND COVTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT OKSSRV.CLE_ID
, OKSSRV.COVERAGE_ID
, OKSSRV.STANDARD_COV_YN
, COVTL.NAME
, COVTL.ITEM_DESCRIPTION
FROM OKS_K_LINES_B OKSSRV
, OKC_K_LINES_B COV
, OKC_K_LINES_TL COVTL
WHERE COV.LSE_ID IN (2
, 15
, 20)
AND COV.ID = OKSSRV.COVERAGE_ID
AND COV.ID = COVTL.ID
AND COVTL.LANGUAGE = USERENV('LANG')