View: OKL_CS_SERVICE_LINES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_SERVICE_LINES_UV

View Text

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')

Columns