VIEW: APPS.OKL_K_LINES_FULL_V

Source

View Text - Preformatted

SELECT cleb.rowid ROW_ID, CLEB.ID ID, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CLET.SFWT_FLAG SFWT_FLAG, CLEB.CHR_ID CHR_ID, CLEB.CLE_ID CLE_ID, CLEB.CLE_ID_RENEWED CLE_ID_RENEWED, CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO, CLEB.LSE_ID LSE_ID, CLEB.LINE_NUMBER LINE_NUMBER, CLEB.STS_CODE STS_CODE, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, CLEB.TRN_CODE TRN_CODE, CLEB.DNZ_CHR_ID DNZ_CHR_ID, CLET.COMMENTS COMMENTS, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION, CLET.OKE_BOE_DESCRIPTION, CLEB.HIDDEN_IND HIDDEN_IND, CLEB.PRICE_UNIT PRICE_UNIT, CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED, CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED, CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND, CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND, CLEB.DPAS_RATING DPAS_RATING, CLET.BLOCK23TEXT BLOCK23TEXT, CLEB.EXCEPTION_YN EXCEPTION_YN, CLEB.TEMPLATE_USED TEMPLATE_USED, CLEB.DATE_TERMINATED DATE_TERMINATED, CLET.NAME NAME, CLEB.START_DATE START_DATE, CLEB.END_DATE END_DATE, CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF , CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID, 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 , CLEB.PRICE_TYPE PRICE_TYPE, CLEB.CURRENCY_CODE CURRENCY_CODE, CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED , CLEB.DATE_RENEWED DATE_RENEWED, CLEB.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE, CLEB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1, CLEB.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1 , CLEB.PROGRAM_APPLICATION_ID, CLEB.PROGRAM_ID, CLEB.PROGRAM_UPDATE_DATE, CLEB.REQUEST_ID, CLEB.PRICE_LIST_ID, CLEB.PRICE_LIST_LINE_ID, CLEB.LINE_LIST_PRICE, CLEB.ITEM_TO_PRICE_YN, CLEB.PRICING_DATE, CLEB.PRICE_BASIS_YN, CLEB.CONFIG_HEADER_ID, CLEB.CONFIG_REVISION_NUMBER, CLEB.CONFIG_COMPLETE_YN, CLEB.CONFIG_VALID_YN, CLEB.CONFIG_TOP_MODEL_LINE_ID, CLEB.CONFIG_ITEM_TYPE, CLEB.CONFIG_ITEM_ID, CLEB.SERVICE_ITEM_YN, CLEB.PH_PRICING_TYPE, CLEB.PH_PRICE_BREAK_BASIS, CLEB.PH_MIN_QTY, CLEB.PH_MIN_AMT, CLEB.PH_QP_REFERENCE_ID, CLEB.PH_VALUE, CLEB.PH_ENFORCE_PRICE_LIST_YN, CLEB.PH_ADJUSTMENT, CLEB.PH_INTEGRATED_WITH_QP, CLEB.CUST_ACCT_ID, CLEB.BILL_TO_SITE_USE_ID, CLEB.INV_RULE_ID, CLEB.LINE_RENEWAL_TYPE_CODE, CLEB.SHIP_TO_SITE_USE_ID, CLEB.PAYMENT_TERM_ID, KLE.rowid KLE_ROW_ID, KLE.OBJECT_VERSION_NUMBER KLE_OBJECT_VERSION_NUMBER, KLE.KLE_ID KLE_ID, KLE.STY_ID STY_ID, KLE.PRC_CODE PRC_CODE, KLE.FCG_CODE FCG_CODE, KLE.NTY_CODE NTY_CODE, KLE.ESTIMATED_OEC ESTIMATED_OEC, KLE.LAO_AMOUNT LAO_AMOUNT, KLE.TITLE_DATE TITLE_DATE, KLE.FEE_CHARGE FEE_CHARGE, KLE.LRS_PERCENT LRS_PERCENT, KLE.INITIAL_DIRECT_COST INITIAL_DIRECT_COST, KLE.PERCENT_STAKE PERCENT_STAKE, KLE.PERCENT PERCENT, KLE.EVERGREEN_PERCENT EVERGREEN_PERCENT, KLE.AMOUNT_STAKE AMOUNT_STAKE, KLE.OCCUPANCY OCCUPANCY, KLE.COVERAGE COVERAGE, KLE.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE, KLE.DATE_LAST_INSPECTION DATE_LAST_INSPECTION, KLE.DATE_SOLD DATE_SOLD, KLE.LRV_AMOUNT LRV_AMOUNT, KLE.CAPITAL_REDUCTION CAPITAL_REDUCTION, KLE.DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE, KLE.DATE_RESIDUAL_LAST_REVIEW DATE_RESIDUAL_LAST_REVIEW, KLE.DATE_LAST_REAMORTISATION DATE_LAST_REAMORTISATION, KLE.VENDOR_ADVANCE_PAID VENDOR_ADVANCE_PAID, KLE.WEIGHTED_AVERAGE_LIFE WEIGHTED_AVERAGE_LIFE, KLE.TRADEIN_AMOUNT TRADEIN_AMOUNT, KLE.BOND_EQUIVALENT_YIELD BOND_EQUIVALENT_YIELD, KLE.TERMINATION_PURCHASE_AMOUNT TERMINATION_PURCHASE_AMOUNT, KLE.REFINANCE_AMOUNT REFINANCE_AMOUNT, KLE.YEAR_BUILT YEAR_BUILT, KLE.DELIVERED_DATE DELIVERED_DATE, KLE.CREDIT_TENANT_YN CREDIT_TENANT_YN, KLE.DATE_LAST_CLEANUP DATE_LAST_CLEANUP, KLE.YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE, KLE.COVERAGE_RATIO COVERAGE_RATIO, KLE.REMARKETED_AMOUNT REMARKETED_AMOUNT, KLE.GROSS_SQUARE_FOOTAGE GROSS_SQUARE_FOOTAGE, KLE.PRESCRIBED_ASSET_YN PRESCRIBED_ASSET_YN, KLE.DATE_REMARKETED DATE_REMARKETED, KLE.NET_RENTABLE NET_RENTABLE, KLE.REMARKET_MARGIN REMARKET_MARGIN, KLE.DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE, KLE.REPURCHASED_AMOUNT REPURCHASED_AMOUNT, KLE.DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION, KLE.DATE_REPURCHASED DATE_REPURCHASED, KLE.DATE_APPRAISAL DATE_APPRAISAL, KLE.RESIDUAL_VALUE RESIDUAL_VALUE, KLE.APPRAISAL_VALUE APPRAISAL_VALUE, KLE.SECURED_DEAL_YN SECURED_DEAL_YN, KLE.GAIN_LOSS GAIN_LOSS, KLE.FLOOR_AMOUNT FLOOR_AMOUNT, KLE.RE_LEASE_YN RE_LEASE_YN, KLE.PREVIOUS_CONTRACT PREVIOUS_CONTRACT, KLE.TRACKED_RESIDUAL TRACKED_RESIDUAL, KLE.DATE_TITLE_RECEIVED DATE_TITLE_RECEIVED, KLE.AMOUNT AMOUNT, KLE.ATTRIBUTE_CATEGORY KLE_ATTRIBUTE_CATEGORY, KLE.ATTRIBUTE1 KLE_ATTRIBUTE1, KLE.ATTRIBUTE2 KLE_ATTRIBUTE2, KLE.ATTRIBUTE3 KLE_ATTRIBUTE3, KLE.ATTRIBUTE4 KLE_ATTRIBUTE4, KLE.ATTRIBUTE5 KLE_ATTRIBUTE5, KLE.ATTRIBUTE6 KLE_ATTRIBUTE6, KLE.ATTRIBUTE7 KLE_ATTRIBUTE7, KLE.ATTRIBUTE8 KLE_ATTRIBUTE8, KLE.ATTRIBUTE9 KLE_ATTRIBUTE9, KLE.ATTRIBUTE10 KLE_ATTRIBUTE10, KLE.ATTRIBUTE11 KLE_ATTRIBUTE11, KLE.ATTRIBUTE12 KLE_ATTRIBUTE12, KLE.ATTRIBUTE13 KLE_ATTRIBUTE13, KLE.ATTRIBUTE14 KLE_ATTRIBUTE14, KLE.ATTRIBUTE15 KLE_ATTRIBUTE15, KLE.STY_ID_FOR STY_ID_FOR, KLE.CLG_ID CLG_ID, KLE.CREATED_BY KLE_CREATED_BY, KLE.CREATION_DATE KLE_CREATION_DATE, KLE.LAST_UPDATED_BY KLE_LAST_UPDATED_BY, KLE.LAST_UPDATE_DATE KLE_LAST_UPDATE_DATE, KLE.LAST_UPDATE_LOGIN KLE_LAST_UPDATE_LOGIN , KLE.DATE_FUNDING DATE_FUNDING, KLE.DATE_FUNDING_REQUIRED DATE_FUNDING_REQUIRED, KLE.DATE_ACCEPTED DATE_ACCEPTED, KLE.DATE_DELIVERY_EXPECTED DATE_DELIVERY_EXPECTED, KLE.OEC OEC, KLE.CAPITAL_AMOUNT CAPITAL_AMOUNT, KLE.RESIDUAL_GRNTY_AMOUNT RESIDUAL_GRNTY_AMOUNT, KLE.RESIDUAL_CODE RESIDUAL_CODE, KLE.RVI_PREMIUM RVI_PREMIUM, KLE.CREDIT_NATURE CREDIT_NATURE, KLE.CAPITALIZED_INTEREST CAPITALIZED_INTEREST, KLE.CAPITAL_REDUCTION_PERCENT CAPITAL_REDUCTION_PERCENT, KLE.DATE_PAY_INVESTOR_START DATE_PAY_INVESTOR_START, KLE.PAY_INVESTOR_FREQUENCY PAY_INVESTOR_FREQUENCY, KLE.PAY_INVESTOR_EVENT PAY_INVESTOR_EVENT, KLE.PAY_INVESTOR_REMITTANCE_DAYS PAY_INVESTOR_REMITTANCE_DAYS, KLE.FEE_TYPE FEE_TYPE, KLE.SUBSIDY_ID SUBSIDY_ID, KLE.SUBSIDY_OVERRIDE_AMOUNT SUBSIDY_OVERRIDE_AMOUNT, KLE.PRE_TAX_YIELD PRE_TAX_YIELD, KLE.AFTER_TAX_YIELD AFTER_TAX_YIELD, KLE.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE, KLE.IMPLICIT_NON_IDC_INTEREST_RATE IMPLICIT_NON_IDC_INTEREST_RATE, KLE.PRE_TAX_IRR PRE_TAX_IRR, KLE.AFTER_TAX_IRR AFTER_TAX_IRR, KLE.SUB_PRE_TAX_YIELD SUB_PRE_TAX_YIELD, KLE.SUB_AFTER_TAX_YIELD SUB_AFTER_TAX_YIELD, KLE.SUB_IMPL_INTEREST_RATE SUB_IMPL_INTEREST_RATE, KLE.SUB_IMPL_NON_IDC_INT_RATE SUB_IMPL_NON_IDC_INT_RATE, KLE.SUB_PRE_TAX_IRR SUB_PRE_TAX_IRR, KLE.SUB_AFTER_TAX_IRR SUB_AFTER_TAX_IRR, KLE.ITEM_INSURANCE_CATEGORY ITEM_INSURANCE_CATEGORY, KLE.QTE_ID QTE_ID, KLE.FUNDING_DATE FUNDING_DATE, KLE.STREAM_TYPE_SUBCLASS STREAM_TYPE_SUBCLASS, KLE.DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED, KLE.MANUFACTURER_NAME MANUFACTURER_NAME, KLE.MODEL_NUMBER MODEL_NUMBER, KLE.DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE, KLE.CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN, KLE.FEE_PURPOSE_CODE FEE_PURPOSE_CODE , KLE.TERMINATION_VALUE TERMINATION_VALUE , KLE.EXPECTED_ASSET_COST, kle.orig_contract_line_id, KLE.ORIGINATION_INCOME, KLE.AMOUNT_BALANCE_LEGACY, KLE.DT_EFFECTIVE_BALANCE_LEGACY FROM OKC_K_LINES_B CLEB,OKC_K_LINES_TL CLET,OKL_K_LINES KLE WHERE CLEB.ID = CLET.ID and CLET.LANGUAGE = USERENV('LANG') AND KLE.ID = CLEB.ID AND CLEB.STS_CODE <> 'ABANDONED'

View Text - HTML Formatted

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLET.SFWT_FLAG SFWT_FLAG
, CLEB.CHR_ID CHR_ID
, CLEB.CLE_ID CLE_ID
, CLEB.CLE_ID_RENEWED CLE_ID_RENEWED
, CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.STS_CODE STS_CODE
, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, CLEB.TRN_CODE TRN_CODE
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLET.COMMENTS COMMENTS
, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLET.OKE_BOE_DESCRIPTION
, CLEB.HIDDEN_IND HIDDEN_IND
, CLEB.PRICE_UNIT PRICE_UNIT
, CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT
, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED
, CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED
, CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND
, CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND
, CLEB.DPAS_RATING DPAS_RATING
, CLET.BLOCK23TEXT BLOCK23TEXT
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.TEMPLATE_USED TEMPLATE_USED
, CLEB.DATE_TERMINATED DATE_TERMINATED
, CLET.NAME NAME
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, 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
, CLEB.PRICE_TYPE PRICE_TYPE
, CLEB.CURRENCY_CODE CURRENCY_CODE
, CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, CLEB.DATE_RENEWED DATE_RENEWED
, CLEB.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, CLEB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, CLEB.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, CLEB.PROGRAM_APPLICATION_ID
, CLEB.PROGRAM_ID
, CLEB.PROGRAM_UPDATE_DATE
, CLEB.REQUEST_ID
, CLEB.PRICE_LIST_ID
, CLEB.PRICE_LIST_LINE_ID
, CLEB.LINE_LIST_PRICE
, CLEB.ITEM_TO_PRICE_YN
, CLEB.PRICING_DATE
, CLEB.PRICE_BASIS_YN
, CLEB.CONFIG_HEADER_ID
, CLEB.CONFIG_REVISION_NUMBER
, CLEB.CONFIG_COMPLETE_YN
, CLEB.CONFIG_VALID_YN
, CLEB.CONFIG_TOP_MODEL_LINE_ID
, CLEB.CONFIG_ITEM_TYPE
, CLEB.CONFIG_ITEM_ID
, CLEB.SERVICE_ITEM_YN
, CLEB.PH_PRICING_TYPE
, CLEB.PH_PRICE_BREAK_BASIS
, CLEB.PH_MIN_QTY
, CLEB.PH_MIN_AMT
, CLEB.PH_QP_REFERENCE_ID
, CLEB.PH_VALUE
, CLEB.PH_ENFORCE_PRICE_LIST_YN
, CLEB.PH_ADJUSTMENT
, CLEB.PH_INTEGRATED_WITH_QP
, CLEB.CUST_ACCT_ID
, CLEB.BILL_TO_SITE_USE_ID
, CLEB.INV_RULE_ID
, CLEB.LINE_RENEWAL_TYPE_CODE
, CLEB.SHIP_TO_SITE_USE_ID
, CLEB.PAYMENT_TERM_ID
, KLE.ROWID KLE_ROW_ID
, KLE.OBJECT_VERSION_NUMBER KLE_OBJECT_VERSION_NUMBER
, KLE.KLE_ID KLE_ID
, KLE.STY_ID STY_ID
, KLE.PRC_CODE PRC_CODE
, KLE.FCG_CODE FCG_CODE
, KLE.NTY_CODE NTY_CODE
, KLE.ESTIMATED_OEC ESTIMATED_OEC
, KLE.LAO_AMOUNT LAO_AMOUNT
, KLE.TITLE_DATE TITLE_DATE
, KLE.FEE_CHARGE FEE_CHARGE
, KLE.LRS_PERCENT LRS_PERCENT
, KLE.INITIAL_DIRECT_COST INITIAL_DIRECT_COST
, KLE.PERCENT_STAKE PERCENT_STAKE
, KLE.PERCENT PERCENT
, KLE.EVERGREEN_PERCENT EVERGREEN_PERCENT
, KLE.AMOUNT_STAKE AMOUNT_STAKE
, KLE.OCCUPANCY OCCUPANCY
, KLE.COVERAGE COVERAGE
, KLE.RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE
, KLE.DATE_LAST_INSPECTION DATE_LAST_INSPECTION
, KLE.DATE_SOLD DATE_SOLD
, KLE.LRV_AMOUNT LRV_AMOUNT
, KLE.CAPITAL_REDUCTION CAPITAL_REDUCTION
, KLE.DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE
, KLE.DATE_RESIDUAL_LAST_REVIEW DATE_RESIDUAL_LAST_REVIEW
, KLE.DATE_LAST_REAMORTISATION DATE_LAST_REAMORTISATION
, KLE.VENDOR_ADVANCE_PAID VENDOR_ADVANCE_PAID
, KLE.WEIGHTED_AVERAGE_LIFE WEIGHTED_AVERAGE_LIFE
, KLE.TRADEIN_AMOUNT TRADEIN_AMOUNT
, KLE.BOND_EQUIVALENT_YIELD BOND_EQUIVALENT_YIELD
, KLE.TERMINATION_PURCHASE_AMOUNT TERMINATION_PURCHASE_AMOUNT
, KLE.REFINANCE_AMOUNT REFINANCE_AMOUNT
, KLE.YEAR_BUILT YEAR_BUILT
, KLE.DELIVERED_DATE DELIVERED_DATE
, KLE.CREDIT_TENANT_YN CREDIT_TENANT_YN
, KLE.DATE_LAST_CLEANUP DATE_LAST_CLEANUP
, KLE.YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE
, KLE.COVERAGE_RATIO COVERAGE_RATIO
, KLE.REMARKETED_AMOUNT REMARKETED_AMOUNT
, KLE.GROSS_SQUARE_FOOTAGE GROSS_SQUARE_FOOTAGE
, KLE.PRESCRIBED_ASSET_YN PRESCRIBED_ASSET_YN
, KLE.DATE_REMARKETED DATE_REMARKETED
, KLE.NET_RENTABLE NET_RENTABLE
, KLE.REMARKET_MARGIN REMARKET_MARGIN
, KLE.DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE
, KLE.REPURCHASED_AMOUNT REPURCHASED_AMOUNT
, KLE.DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION
, KLE.DATE_REPURCHASED DATE_REPURCHASED
, KLE.DATE_APPRAISAL DATE_APPRAISAL
, KLE.RESIDUAL_VALUE RESIDUAL_VALUE
, KLE.APPRAISAL_VALUE APPRAISAL_VALUE
, KLE.SECURED_DEAL_YN SECURED_DEAL_YN
, KLE.GAIN_LOSS GAIN_LOSS
, KLE.FLOOR_AMOUNT FLOOR_AMOUNT
, KLE.RE_LEASE_YN RE_LEASE_YN
, KLE.PREVIOUS_CONTRACT PREVIOUS_CONTRACT
, KLE.TRACKED_RESIDUAL TRACKED_RESIDUAL
, KLE.DATE_TITLE_RECEIVED DATE_TITLE_RECEIVED
, KLE.AMOUNT AMOUNT
, KLE.ATTRIBUTE_CATEGORY KLE_ATTRIBUTE_CATEGORY
, KLE.ATTRIBUTE1 KLE_ATTRIBUTE1
, KLE.ATTRIBUTE2 KLE_ATTRIBUTE2
, KLE.ATTRIBUTE3 KLE_ATTRIBUTE3
, KLE.ATTRIBUTE4 KLE_ATTRIBUTE4
, KLE.ATTRIBUTE5 KLE_ATTRIBUTE5
, KLE.ATTRIBUTE6 KLE_ATTRIBUTE6
, KLE.ATTRIBUTE7 KLE_ATTRIBUTE7
, KLE.ATTRIBUTE8 KLE_ATTRIBUTE8
, KLE.ATTRIBUTE9 KLE_ATTRIBUTE9
, KLE.ATTRIBUTE10 KLE_ATTRIBUTE10
, KLE.ATTRIBUTE11 KLE_ATTRIBUTE11
, KLE.ATTRIBUTE12 KLE_ATTRIBUTE12
, KLE.ATTRIBUTE13 KLE_ATTRIBUTE13
, KLE.ATTRIBUTE14 KLE_ATTRIBUTE14
, KLE.ATTRIBUTE15 KLE_ATTRIBUTE15
, KLE.STY_ID_FOR STY_ID_FOR
, KLE.CLG_ID CLG_ID
, KLE.CREATED_BY KLE_CREATED_BY
, KLE.CREATION_DATE KLE_CREATION_DATE
, KLE.LAST_UPDATED_BY KLE_LAST_UPDATED_BY
, KLE.LAST_UPDATE_DATE KLE_LAST_UPDATE_DATE
, KLE.LAST_UPDATE_LOGIN KLE_LAST_UPDATE_LOGIN
, KLE.DATE_FUNDING DATE_FUNDING
, KLE.DATE_FUNDING_REQUIRED DATE_FUNDING_REQUIRED
, KLE.DATE_ACCEPTED DATE_ACCEPTED
, KLE.DATE_DELIVERY_EXPECTED DATE_DELIVERY_EXPECTED
, KLE.OEC OEC
, KLE.CAPITAL_AMOUNT CAPITAL_AMOUNT
, KLE.RESIDUAL_GRNTY_AMOUNT RESIDUAL_GRNTY_AMOUNT
, KLE.RESIDUAL_CODE RESIDUAL_CODE
, KLE.RVI_PREMIUM RVI_PREMIUM
, KLE.CREDIT_NATURE CREDIT_NATURE
, KLE.CAPITALIZED_INTEREST CAPITALIZED_INTEREST
, KLE.CAPITAL_REDUCTION_PERCENT CAPITAL_REDUCTION_PERCENT
, KLE.DATE_PAY_INVESTOR_START DATE_PAY_INVESTOR_START
, KLE.PAY_INVESTOR_FREQUENCY PAY_INVESTOR_FREQUENCY
, KLE.PAY_INVESTOR_EVENT PAY_INVESTOR_EVENT
, KLE.PAY_INVESTOR_REMITTANCE_DAYS PAY_INVESTOR_REMITTANCE_DAYS
, KLE.FEE_TYPE FEE_TYPE
, KLE.SUBSIDY_ID SUBSIDY_ID
, KLE.SUBSIDY_OVERRIDE_AMOUNT SUBSIDY_OVERRIDE_AMOUNT
, KLE.PRE_TAX_YIELD PRE_TAX_YIELD
, KLE.AFTER_TAX_YIELD AFTER_TAX_YIELD
, KLE.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, KLE.IMPLICIT_NON_IDC_INTEREST_RATE IMPLICIT_NON_IDC_INTEREST_RATE
, KLE.PRE_TAX_IRR PRE_TAX_IRR
, KLE.AFTER_TAX_IRR AFTER_TAX_IRR
, KLE.SUB_PRE_TAX_YIELD SUB_PRE_TAX_YIELD
, KLE.SUB_AFTER_TAX_YIELD SUB_AFTER_TAX_YIELD
, KLE.SUB_IMPL_INTEREST_RATE SUB_IMPL_INTEREST_RATE
, KLE.SUB_IMPL_NON_IDC_INT_RATE SUB_IMPL_NON_IDC_INT_RATE
, KLE.SUB_PRE_TAX_IRR SUB_PRE_TAX_IRR
, KLE.SUB_AFTER_TAX_IRR SUB_AFTER_TAX_IRR
, KLE.ITEM_INSURANCE_CATEGORY ITEM_INSURANCE_CATEGORY
, KLE.QTE_ID QTE_ID
, KLE.FUNDING_DATE FUNDING_DATE
, KLE.STREAM_TYPE_SUBCLASS STREAM_TYPE_SUBCLASS
, KLE.DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED
, KLE.MANUFACTURER_NAME MANUFACTURER_NAME
, KLE.MODEL_NUMBER MODEL_NUMBER
, KLE.DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE
, KLE.CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN
, KLE.FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, KLE.TERMINATION_VALUE TERMINATION_VALUE
, KLE.EXPECTED_ASSET_COST
, KLE.ORIG_CONTRACT_LINE_ID
, KLE.ORIGINATION_INCOME
, KLE.AMOUNT_BALANCE_LEGACY
, KLE.DT_EFFECTIVE_BALANCE_LEGACY
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
, OKL_K_LINES KLE
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND KLE.ID = CLEB.ID
AND CLEB.STS_CODE <> 'ABANDONED'