View: OKS_ENT_COVERAGES_V

Product:	OKS - Service Contracts
Description:	View all Coverages attcahed to a Contract Line
Implementation/DBA Data:	APPS.OKS_ENT_COVERAGES_V

View Text

SELECT KL.ID ACTUAL_COVERAGE_ID
, HD.ID CONTRACT_ID
, HD.CONTRACT_NUMBER CONTRACT_NUMBER
, KL.CLE_ID CONTRACT_LINE_ID
, TO_NUMBER (IT.OBJECT1_ID1) SERVICE_ITEM_ID
, TL.NAME COVERAGE_NAME
, TL.ITEM_DESCRIPTION COVERAGE_DESC
, COVTL.MEANING COVERAGE_MEANING
, KL.START_DATE START_DATE
, KL.END_DATE END_DATE
, KL.DATE_TERMINATED DATE_TERMINATED
, OKSCOV.EXCEPTION_COV_ID EXCEPTION_COVERAGE_ID
FROM OKC_K_HEADERS_B HD
, OKC_K_LINES_B KL
, OKC_K_LINES_TL TL
, OKS_K_LINES_B OKSCOV
, OKC_K_ITEMS IT
, OKS_COV_TYPES_TL COVTL
WHERE HD.ID = KL.DNZ_CHR_ID
AND KL.LSE_ID IN (2
, 15
, 20)
AND KL.ID = TL.ID
AND TL.LANGUAGE = USERENV('LANG')
AND KL.CLE_ID = IT.CLE_ID
AND IT.JTOT_OBJECT1_CODE IN ('OKX_SERVICE'
, 'OKX_WARRANTY')
AND COVTL.CODE = OKSCOV.COVERAGE_TYPE
AND COVTL.LANGUAGE = USERENV('LANG')

Columns