VIEW: APPS.OKL_CS_SERVICE_LINES_UV

Source

View Text - Preformatted

SELECT cle.id cle_id, okx_service.name, kle.amount, cle.start_date, cle.end_date, lstl.meaning, chr.contract_number, cle.dnz_chr_id, chr.currency_code from okc_k_lines_b cle, okc_line_styles_b lse, okl_k_lines kle, okc_k_items cit, OKX_SYSTEM_ITEMS_V OKX_SERVICE, okc_k_headers_b chr, okc_statuses_b ls, okc_statuses_tl lstl WHERE lse.id = cle.lse_id and lse.lty_code = 'SOLD_SERVICE' and kle.id = cle.id and cle.sts_code not in ('ABANDONED') and cit.cle_id = cle.id and cit.dnz_chr_id = cle.dnz_chr_id and okx_service.vendor_warranty_flag = 'N' and okx_service.service_item_flag = 'Y' and okx_service.id1 = cit.object1_id1 and okx_service.id2 = cit.object1_id2 and cit.jtot_object1_code = 'OKX_SERVICE' and cit.dnz_chr_id = chr.id and cle.dnz_chr_id = chr.id and ls.code = cle.sts_code and lstl.code = ls.code and lstl.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CLE.ID CLE_ID
, OKX_SERVICE.NAME
, KLE.AMOUNT
, CLE.START_DATE
, CLE.END_DATE
, LSTL.MEANING
, CHR.CONTRACT_NUMBER
, CLE.DNZ_CHR_ID
, CHR.CURRENCY_CODE
FROM OKC_K_LINES_B CLE
, OKC_LINE_STYLES_B LSE
, OKL_K_LINES KLE
, OKC_K_ITEMS CIT
, OKX_SYSTEM_ITEMS_V OKX_SERVICE
, OKC_K_HEADERS_B CHR
, OKC_STATUSES_B LS
, OKC_STATUSES_TL LSTL
WHERE LSE.ID = CLE.LSE_ID
AND LSE.LTY_CODE = 'SOLD_SERVICE'
AND KLE.ID = CLE.ID
AND CLE.STS_CODE NOT IN ('ABANDONED')
AND CIT.CLE_ID = CLE.ID
AND CIT.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND OKX_SERVICE.VENDOR_WARRANTY_FLAG = 'N'
AND OKX_SERVICE.SERVICE_ITEM_FLAG = 'Y'
AND OKX_SERVICE.ID1 = CIT.OBJECT1_ID1
AND OKX_SERVICE.ID2 = CIT.OBJECT1_ID2
AND CIT.JTOT_OBJECT1_CODE = 'OKX_SERVICE'
AND CIT.DNZ_CHR_ID = CHR.ID
AND CLE.DNZ_CHR_ID = CHR.ID
AND LS.CODE = CLE.STS_CODE
AND LSTL.CODE = LS.CODE
AND LSTL.LANGUAGE = USERENV('LANG')