View: OKS_COVERED_LEVEL_V

Product:	OKS - Service Contracts
Description:	Covered level view for Contract details form
Implementation/DBA Data:	APPS.OKS_COVERED_LEVEL_V

View Text

SELECT MTL.NAME
, KL.START_DATE
, KL.END_DATE
, KL.STS_CODE
, KL.DNZ_CHR_ID
FROM OKC_K_LINES_V KL
, OKC_K_ITEMS_V ITEM
, OKC_K_HEADERS_V KH
, OKX_SYSTEM_ITEMS_V MTL
WHERE KL.LSE_ID = 19
AND ITEM.CLE_ID = KL.ID
AND MTL.ID1 = ITEM.OBJECT1_ID1
AND KH.ID = KL.DNZ_CHR_ID
AND KL.CLE_ID IS NULL
AND MTL.ORGANIZATION_ID = KH.INV_ORGANIZATION_ID

Columns