VIEW: APPS.OKL_ASSET_ADJUST_UV

Source

View Text - Preformatted

SELECT KLE.ID ID, CLE.STS_CODE STS_CODE, CLE.DNZ_CHR_ID DNZ_CHR_ID, CLE.CLE_ID CLE_ID, CLE.LSE_ID LSE_ID, KLE.STY_ID STY_ID, CLET.NAME ASSET_NUMBER, CLET.ITEM_DESCRIPTION DESCRIPTION, to_char(KLE.CAPITAL_REDUCTION) CAPITAL_REDUCTION, to_char(KLE.TRADEIN_AMOUNT) TRADEIN_AMOUNT, to_char(KLE.CAPITAL_REDUCTION_PERCENT) CAPITAL_REDUCTION_PERCENT, to_char(KLE.CAPITAL_AMOUNT) CAPITAL_AMOUNT, to_char(KLE.OEC) OEC, kle.CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN, kle.DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE FROM 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'

View Text - HTML Formatted

SELECT KLE.ID ID
, CLE.STS_CODE STS_CODE
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, CLE.CLE_ID CLE_ID
, CLE.LSE_ID LSE_ID
, KLE.STY_ID STY_ID
, CLET.NAME ASSET_NUMBER
, CLET.ITEM_DESCRIPTION DESCRIPTION
, TO_CHAR(KLE.CAPITAL_REDUCTION) CAPITAL_REDUCTION
, TO_CHAR(KLE.TRADEIN_AMOUNT) TRADEIN_AMOUNT
, TO_CHAR(KLE.CAPITAL_REDUCTION_PERCENT) CAPITAL_REDUCTION_PERCENT
, TO_CHAR(KLE.CAPITAL_AMOUNT) CAPITAL_AMOUNT
, TO_CHAR(KLE.OEC) OEC
, KLE.CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN
, KLE.DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE
FROM 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'