VIEW: APPS.OKL_LA_TRADEIN_UV

Source

View Text - Preformatted

SELECT KLE.ID ID, CLE.DNZ_CHR_ID DNZ_CHR_ID, CLET.NAME ASSET_NUMBER, to_char(KLE.TRADEIN_AMOUNT) TRADEIN_AMOUNT, KLE.ID ASSET_ID, CLET.ITEM_DESCRIPTION DESCRIPTION, KLE.OEC ASSET_COST, KLE.TRADEIN_AMOUNT AMOUNT FROM OKC_STATUSES_B STS,OKC_LINE_STYLES_B LSE,OKC_K_LINES_B CLE,OKL_K_LINES KLE,OKC_K_LINES_TL CLET WHERE KLE.ID = CLE.ID AND KLE.ID = CLET.ID AND CLET.LANGUAGE = userenv('LANG') AND CLE.LSE_ID = LSE.ID AND LSE.LTY_CODE = 'FREE_FORM1' and kle.tradein_amount is not null AND CLE.STS_CODE = STS.CODE AND STS.STE_CODE NOT IN ('HOLD','EXPIRED','CANCELLED')

View Text - HTML Formatted

SELECT KLE.ID ID
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, CLET.NAME ASSET_NUMBER
, TO_CHAR(KLE.TRADEIN_AMOUNT) TRADEIN_AMOUNT
, KLE.ID ASSET_ID
, CLET.ITEM_DESCRIPTION DESCRIPTION
, KLE.OEC ASSET_COST
, KLE.TRADEIN_AMOUNT AMOUNT
FROM OKC_STATUSES_B STS
, OKC_LINE_STYLES_B LSE
, OKC_K_LINES_B CLE
, OKL_K_LINES KLE
, OKC_K_LINES_TL CLET
WHERE KLE.ID = CLE.ID
AND KLE.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND CLE.LSE_ID = LSE.ID
AND LSE.LTY_CODE = 'FREE_FORM1'
AND KLE.TRADEIN_AMOUNT IS NOT NULL
AND CLE.STS_CODE = STS.CODE
AND STS.STE_CODE NOT IN ('HOLD'
, 'EXPIRED'
, 'CANCELLED')