eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKS_ENT_COVERAGES_V

Source

View Text - Preformatted


SELECT OKSSRV.COVERAGE_ID ACTUAL_COVERAGE_ID , HD.ID CONTRACT_ID , HD.CONTRACT_NUMBER CONTRACT_NUMBER , KL.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 , DECODE(OKSSRV.STANDARD_COV_YN,'Y',KL.START_DATE,COV.START_DATE) START_DATE , DECODE(OKSSRV.STANDARD_COV_YN,'Y',KL.END_DATE,COV.END_DATE) END_DATE , DECODE(OKSSRV.STANDARD_COV_YN,'Y',KL.DATE_TERMINATED,COV.DATE_TERMINATED) DATE_TERMINATED , OKSCOV.EXCEPTION_COV_ID EXCEPTION_COVERAGE_ID, OKSSRV.STANDARD_COV_YN STANDARD_COV_YN FROM OKC_K_HEADERS_ALL_B HD , OKC_K_LINES_B KL , OKS_K_LINES_B OKSSRV, OKC_K_ITEMS IT, OKC_K_LINES_B COV, OKC_K_LINES_TL TL , OKS_K_LINES_B OKSCOV, OKS_COV_TYPES_TL COVTL WHERE HD.ID = KL.DNZ_CHR_ID AND HD.ID = KL.CHR_ID AND KL.LSE_ID IN (1,14,19) AND KL.ID = OKSSRV.CLE_ID AND KL.ID = IT.CLE_ID AND IT.JTOT_OBJECT1_CODE IN ('OKX_SERVICE','OKX_WARRANTY') AND COV.ID = OKSSRV.COVERAGE_ID AND COV.ID = TL.ID AND TL.LANGUAGE = USERENV('LANG') AND OKSCOV.CLE_ID = COV.ID AND COVTL.CODE (+)= OKSCOV.COVERAGE_TYPE AND COVTL.LANGUAGE (+)= USERENV('LANG')

View Text - HTML Formatted

SELECT OKSSRV.COVERAGE_ID ACTUAL_COVERAGE_ID
, HD.ID CONTRACT_ID
, HD.CONTRACT_NUMBER CONTRACT_NUMBER
, KL.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
, DECODE(OKSSRV.STANDARD_COV_YN
, 'Y'
, KL.START_DATE
, COV.START_DATE) START_DATE
, DECODE(OKSSRV.STANDARD_COV_YN
, 'Y'
, KL.END_DATE
, COV.END_DATE) END_DATE
, DECODE(OKSSRV.STANDARD_COV_YN
, 'Y'
, KL.DATE_TERMINATED
, COV.DATE_TERMINATED) DATE_TERMINATED
, OKSCOV.EXCEPTION_COV_ID EXCEPTION_COVERAGE_ID
, OKSSRV.STANDARD_COV_YN STANDARD_COV_YN
FROM OKC_K_HEADERS_ALL_B HD
, OKC_K_LINES_B KL
, OKS_K_LINES_B OKSSRV
, OKC_K_ITEMS IT
, OKC_K_LINES_B COV
, OKC_K_LINES_TL TL
, OKS_K_LINES_B OKSCOV
, OKS_COV_TYPES_TL COVTL
WHERE HD.ID = KL.DNZ_CHR_ID
AND HD.ID = KL.CHR_ID
AND KL.LSE_ID IN (1
, 14
, 19)
AND KL.ID = OKSSRV.CLE_ID
AND KL.ID = IT.CLE_ID
AND IT.JTOT_OBJECT1_CODE IN ('OKX_SERVICE'
, 'OKX_WARRANTY')
AND COV.ID = OKSSRV.COVERAGE_ID
AND COV.ID = TL.ID
AND TL.LANGUAGE = USERENV('LANG')
AND OKSCOV.CLE_ID = COV.ID
AND COVTL.CODE (+)= OKSCOV.COVERAGE_TYPE
AND COVTL.LANGUAGE (+)= USERENV('LANG')