[Home] [Help]
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
Name |
ACTUAL_COVERAGE_ID |
CONTRACT_ID |
CONTRACT_NUMBER |
CONTRACT_LINE_ID |
SERVICE_ITEM_ID |
COVERAGE_NAME |
COVERAGE_DESC |
COVERAGE_MEANING |
START_DATE |
END_DATE |
DATE_TERMINATED |
EXCEPTION_COVERAGE_ID |