VIEW: APPS.OKL_K_LINES_V

Source

View Text - Preformatted

SELECT KLE.rowid ROW_ID, KLE.ID ID, KLE.OBJECT_VERSION_NUMBER 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 ATTRIBUTE_CATEGORY, KLE.ATTRIBUTE1 ATTRIBUTE1, KLE.ATTRIBUTE2 ATTRIBUTE2, KLE.ATTRIBUTE3 ATTRIBUTE3, KLE.ATTRIBUTE4 ATTRIBUTE4, KLE.ATTRIBUTE5 ATTRIBUTE5, KLE.ATTRIBUTE6 ATTRIBUTE6, KLE.ATTRIBUTE7 ATTRIBUTE7, KLE.ATTRIBUTE8 ATTRIBUTE8, KLE.ATTRIBUTE9 ATTRIBUTE9, KLE.ATTRIBUTE10 ATTRIBUTE10, KLE.ATTRIBUTE11 ATTRIBUTE11, KLE.ATTRIBUTE12 ATTRIBUTE12, KLE.ATTRIBUTE13 ATTRIBUTE13, KLE.ATTRIBUTE14 ATTRIBUTE14, KLE.ATTRIBUTE15 ATTRIBUTE15, KLE.STY_ID_FOR STY_ID_FOR, KLE.CLG_ID CLG_ID, KLE.CREATED_BY CREATED_BY, KLE.CREATION_DATE CREATION_DATE, KLE.LAST_UPDATED_BY LAST_UPDATED_BY, KLE.LAST_UPDATE_DATE LAST_UPDATE_DATE, KLE.LAST_UPDATE_LOGIN 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 OKL_K_LINES KLE

View Text - HTML Formatted

SELECT KLE.ROWID ROW_ID
, KLE.ID ID
, KLE.OBJECT_VERSION_NUMBER 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 ATTRIBUTE_CATEGORY
, KLE.ATTRIBUTE1 ATTRIBUTE1
, KLE.ATTRIBUTE2 ATTRIBUTE2
, KLE.ATTRIBUTE3 ATTRIBUTE3
, KLE.ATTRIBUTE4 ATTRIBUTE4
, KLE.ATTRIBUTE5 ATTRIBUTE5
, KLE.ATTRIBUTE6 ATTRIBUTE6
, KLE.ATTRIBUTE7 ATTRIBUTE7
, KLE.ATTRIBUTE8 ATTRIBUTE8
, KLE.ATTRIBUTE9 ATTRIBUTE9
, KLE.ATTRIBUTE10 ATTRIBUTE10
, KLE.ATTRIBUTE11 ATTRIBUTE11
, KLE.ATTRIBUTE12 ATTRIBUTE12
, KLE.ATTRIBUTE13 ATTRIBUTE13
, KLE.ATTRIBUTE14 ATTRIBUTE14
, KLE.ATTRIBUTE15 ATTRIBUTE15
, KLE.STY_ID_FOR STY_ID_FOR
, KLE.CLG_ID CLG_ID
, KLE.CREATED_BY CREATED_BY
, KLE.CREATION_DATE CREATION_DATE
, KLE.LAST_UPDATED_BY LAST_UPDATED_BY
, KLE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, KLE.LAST_UPDATE_LOGIN 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 OKL_K_LINES KLE