Product: | OKS - Service Contracts |
---|---|
Description: | THIS VIEW DISPLAYS ALL THE COVERAGE TEMPLATES USED IN OKS |
Implementation/DBA Data: | APPS.OKS_SERVICE_COV_TEMPLTS_V |
SELECT CLEB.ID ID
, CLEB.LSE_ID LSE_ID
, DECODE(CLEB.LSE_ID
, 2
, 'SERVICE'
, 15
, 'WARRANTY'
, 66
, 'USAGE') ITEM_TYPE
, CLET.NAME NAME
, CLET.ITEM_DESCRIPTION DESCRIPTION
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, DECODE(CLEB.LSE_ID
, 15
, 'Y'
, 'N') WARRANTY_YN
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
WHERE CLEB.CHR_ID < 0
AND CLEB.LSE_ID IN (2
, 15
, 65
, 66)
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG')