VIEW: APPS.OKS_COVERAGE_TEMPLTS_V

Source

View Text - Preformatted

SELECT cleb.id id , cleb.lse_id lse_id , decode(cleb.lse_id,2,'SERVICE',15,'WARRANTY',66,'USAGE') item_type , clet.name name , clet.item_description description , cleb.start_date start_date , cleb.end_date end_date , decode(cleb.lse_id,15,'Y','N') warranty_yn , cleb.exception_yn exception_yn , cleb.attribute_category attribute_category , cleb.attribute1 attribute1 , cleb.attribute2 attribute2 , cleb.attribute3 attribute3 , cleb.attribute4 attribute4 , cleb.attribute5 attribute5 , cleb.attribute6 attribute6 , cleb.attribute7 attribute7 , cleb.attribute8 attribute8 , cleb.attribute9 attribute9 , cleb.attribute10 attribute10 , cleb.attribute11 attribute11 , cleb.attribute12 attribute12 , cleb.attribute13 attribute13 , cleb.attribute14 attribute14 , cleb.attribute15 attribute15 , cleb.created_by created_by , cleb.creation_date creation_date , cleb.last_updated_by last_updated_by , cleb.last_update_date last_update_date , cleb.last_update_login last_update_login from okc_k_lines_b cleb , okc_k_lines_tl clet WHERE cleb.chr_id < 0 and cleb.lse_id in (2,15,65,66) and clet.id = cleb.id and clet.language = userenv('LANG') UNION select cleb.id id , to_number(null) lse_id , 'SUBSCRIPTION' item_type , cleb.name name , cleb.description description , to_date(null) start_date , to_date(null) end_date , null warranty_yn , null exception_yn , null attribute_category , null attribute1 , null attribute2 , null attribute3 , null attribute4 , null attribute5 , null attribute6 , null attribute7 , null attribute8 , null attribute9 , null attribute10 , null attribute11 , null attribute12 , null attribute13 , null attribute14 , null attribute15 , cleb.created_by created_by , cleb.creation_date creation_date , cleb.last_updated_by last_updated_by , cleb.last_update_date last_update_date , cleb.last_update_login last_update_login from oks_subscr_header_v cleb where cleb.dnz_chr_id = -1

View Text - HTML Formatted

SELECT CLEB.ID ID
, CLEB.LSE_ID LSE_ID
, DECODE(CLEB.LSE_ID
, 2
, 'SERVICE'
, 15
, 'WARRANTY'
, 66
, 'USAGE') ITEM_TYPE
, CLET.NAME NAME
, CLET.ITEM_DESCRIPTION DESCRIPTION
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, DECODE(CLEB.LSE_ID
, 15
, 'Y'
, 'N') WARRANTY_YN
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
WHERE CLEB.CHR_ID < 0
AND CLEB.LSE_ID IN (2
, 15
, 65
, 66)
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG') UNION SELECT CLEB.ID ID
, TO_NUMBER(NULL) LSE_ID
, 'SUBSCRIPTION' ITEM_TYPE
, CLEB.NAME NAME
, CLEB.DESCRIPTION DESCRIPTION
, TO_DATE(NULL) START_DATE
, TO_DATE(NULL) END_DATE
, NULL WARRANTY_YN
, NULL EXCEPTION_YN
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_SUBSCR_HEADER_V CLEB
WHERE CLEB.DNZ_CHR_ID = -1