View: OKS_ENT_COVD_LEVELS_V

Product:	OKS - Service Contracts
Description:	View Lists all Coverage Leveles with Coverage level Identifier and Service Line Identifier
Implementation/DBA Data:	APPS.OKS_ENT_COVD_LEVELS_V

View Text

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

Columns