eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKS_ENT_COVD_LEVELS_V

Source

View Text - Preformatted


SELECT KL.DNZ_CHR_ID HEADER_ID ,KL.ID LINE_ID ,KL.CLE_ID PARENT_LINE_ID ,SB.LTY_CODE COVERAGE_LEVEL_CODE ,ST.NAME COVERAGE_LEVEL_NAME ,TO_NUMBER(KI.OBJECT1_ID1) COVERAGE_LEVEL_ID FROM OKC_LINE_STYLES_B SB ,OKC_LINE_STYLES_TL ST ,OKC_K_LINES_B KL ,OKC_K_ITEMS KI WHERE SB.ID = ST.ID AND SB.ID IN(7, 8, 9, 10, 11,13, 18, 25, 35) AND ST.LANGUAGE = USERENV('LANG') AND SB.ID = KL.LSE_ID AND KL.ID = KI.CLE_ID

View Text - HTML Formatted

SELECT KL.DNZ_CHR_ID HEADER_ID
, KL.ID LINE_ID
, KL.CLE_ID PARENT_LINE_ID
, SB.LTY_CODE COVERAGE_LEVEL_CODE
, ST.NAME COVERAGE_LEVEL_NAME
, TO_NUMBER(KI.OBJECT1_ID1) COVERAGE_LEVEL_ID
FROM OKC_LINE_STYLES_B SB
, OKC_LINE_STYLES_TL ST
, OKC_K_LINES_B KL
, OKC_K_ITEMS KI
WHERE SB.ID = ST.ID
AND SB.ID IN(7
, 8
, 9
, 10
, 11
, 13
, 18
, 25
, 35)
AND ST.LANGUAGE = USERENV('LANG')
AND SB.ID = KL.LSE_ID
AND KL.ID = KI.CLE_ID