[Home] [Help]
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
Name |
HEADER_ID |
LINE_ID |
PARENT_LINE_ID |
COVERAGE_LEVEL_CODE |
COVERAGE_LEVEL_NAME |
COVERAGE_LEVEL_ID |