View: OKS_COVDLEVEL_DETAILS_V

Product:	OKS - Service Contracts
Description:	This view is used to show the service details of a contract. This included all covered levels.
Implementation/DBA Data:	APPS.OKS_COVDLEVEL_DETAILS_V

View Text

SELECT SRV.LINE_NUMBER||'.'||KLIN.LINE_NUMBER CONCATENATED_LINE_NUMBER
, KLIN.LINE_NUMBER
, LSE.NAME
, KLIN.LSE_ID
, KLIN.COGNOMEN
, KLIN.START_DATE
, KLIN.END_DATE
, KLIN.STS_CODE
, KLIN.PRICE_NEGOTIATED
, KLIN.ID
, KLIN.CHR_ID
, KLIN.DNZ_CHR_ID
, KLIN.CLE_ID
FROM OKC_K_LINES_B SRV
, OKC_K_LINES_V KLIN
, OKC_LINE_STYLES_V LSE
WHERE SRV.ID = KLIN.CLE_ID
AND SRV.CLE_ID IS NULL
AND LSE.ID = KLIN.LSE_ID
AND KLIN.LSE_ID IN(7
, 8
, 9
, 10
, 11
, 18
, 25
, 35)

Columns