View: OKS_COVERAGES_V

Product:	OKS - Service Contracts
Description:	This view lists all actual Coverages. In order to have a Coverage information for a specific service, the condition on SERVICE_CLE_ID must be specified.
Implementation/DBA Data:	APPS.OKS_COVERAGES_V

View Text

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLEB.CHR_ID TEMPLATE_COVERAGE_CHR_ID
, CLEB.CLE_ID SERVICE_CLE_ID
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLET.NAME NAME
, CLET.ITEM_DESCRIPTION DESCRIPTION
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, 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.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND CLEB.LSE_ID IN ( 2
, 15
, 20)

Columns