VIEW: OKL.OKL_K_LINES#

Source

View Text - Preformatted

select ID ID, KLE_ID KLE_ID, STY_ID STY_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAO_AMOUNT LAO_AMOUNT, FEE_CHARGE FEE_CHARGE, TITLE_DATE TITLE_DATE, DATE_RESIDUAL_LAST_REVIEW DATE_RESIDUAL_LAST_REVIEW, DATE_LAST_REAMORTISATION DATE_LAST_REAMORTISATION, TERMINATION_PURCHASE_AMOUNT TERMINATION_PURCHASE_AMOUNT, DATE_LAST_CLEANUP DATE_LAST_CLEANUP, REMARKETED_AMOUNT REMARKETED_AMOUNT, DATE_REMARKETED DATE_REMARKETED, REMARKET_MARGIN REMARKET_MARGIN, REPURCHASED_AMOUNT REPURCHASED_AMOUNT, DATE_REPURCHASED DATE_REPURCHASED, GAIN_LOSS GAIN_LOSS, FLOOR_AMOUNT FLOOR_AMOUNT, PREVIOUS_CONTRACT PREVIOUS_CONTRACT, TRACKED_RESIDUAL TRACKED_RESIDUAL, DATE_TITLE_RECEIVED DATE_TITLE_RECEIVED, ESTIMATED_OEC ESTIMATED_OEC, RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE, CAPITAL_REDUCTION CAPITAL_REDUCTION, VENDOR_ADVANCE_PAID VENDOR_ADVANCE_PAID, TRADEIN_AMOUNT TRADEIN_AMOUNT, DELIVERED_DATE DELIVERED_DATE, YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE, INITIAL_DIRECT_COST INITIAL_DIRECT_COST, OCCUPANCY OCCUPANCY, DATE_LAST_INSPECTION DATE_LAST_INSPECTION, DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE, WEIGHTED_AVERAGE_LIFE WEIGHTED_AVERAGE_LIFE, BOND_EQUIVALENT_YIELD BOND_EQUIVALENT_YIELD, REFINANCE_AMOUNT REFINANCE_AMOUNT, YEAR_BUILT YEAR_BUILT, COVERAGE_RATIO COVERAGE_RATIO, GROSS_SQUARE_FOOTAGE GROSS_SQUARE_FOOTAGE, NET_RENTABLE NET_RENTABLE, DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE, DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION, DATE_APPRAISAL DATE_APPRAISAL, APPRAISAL_VALUE APPRAISAL_VALUE, RESIDUAL_VALUE RESIDUAL_VALUE, PERCENT PERCENT, COVERAGE COVERAGE, LRV_AMOUNT LRV_AMOUNT, AMOUNT AMOUNT, LRS_PERCENT LRS_PERCENT, EVERGREEN_PERCENT EVERGREEN_PERCENT, PERCENT_STAKE PERCENT_STAKE, AMOUNT_STAKE AMOUNT_STAKE, DATE_SOLD DATE_SOLD, STY_ID_FOR STY_ID_FOR, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NTY_CODE NTY_CODE, FCG_CODE FCG_CODE, PRC_CODE PRC_CODE, RE_LEASE_YN RE_LEASE_YN, PRESCRIBED_ASSET_YN PRESCRIBED_ASSET_YN, CREDIT_TENANT_YN CREDIT_TENANT_YN, SECURED_DEAL_YN SECURED_DEAL_YN, CLG_ID CLG_ID, DATE_FUNDING DATE_FUNDING, DATE_FUNDING_REQUIRED DATE_FUNDING_REQUIRED, DATE_ACCEPTED DATE_ACCEPTED, DATE_DELIVERY_EXPECTED DATE_DELIVERY_EXPECTED, OEC OEC, CAPITAL_AMOUNT CAPITAL_AMOUNT, RESIDUAL_GRNTY_AMOUNT RESIDUAL_GRNTY_AMOUNT, RESIDUAL_CODE RESIDUAL_CODE, RVI_PREMIUM RVI_PREMIUM, CREDIT_NATURE CREDIT_NATURE, CAPITALIZED_INTEREST CAPITALIZED_INTEREST, CAPITAL_REDUCTION_PERCENT CAPITAL_REDUCTION_PERCENT, DATE_PAY_INVESTOR_START DATE_PAY_INVESTOR_START, PAY_INVESTOR_FREQUENCY PAY_INVESTOR_FREQUENCY, PAY_INVESTOR_EVENT PAY_INVESTOR_EVENT, PAY_INVESTOR_REMITTANCE_DAYS PAY_INVESTOR_REMITTANCE_DAYS, FEE_TYPE FEE_TYPE, SUBSIDY_ID SUBSIDY_ID, SUBSIDY_OVERRIDE_AMOUNT SUBSIDY_OVERRIDE_AMOUNT, PRE_TAX_YIELD PRE_TAX_YIELD, AFTER_TAX_YIELD AFTER_TAX_YIELD, IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE, IMPLICIT_NON_IDC_INTEREST_RATE IMPLICIT_NON_IDC_INTEREST_RATE, PRE_TAX_IRR PRE_TAX_IRR, AFTER_TAX_IRR AFTER_TAX_IRR, SUB_PRE_TAX_YIELD SUB_PRE_TAX_YIELD, SUB_AFTER_TAX_YIELD SUB_AFTER_TAX_YIELD, SUB_IMPL_INTEREST_RATE SUB_IMPL_INTEREST_RATE, SUB_IMPL_NON_IDC_INT_RATE SUB_IMPL_NON_IDC_INT_RATE, SUB_PRE_TAX_IRR SUB_PRE_TAX_IRR, SUB_AFTER_TAX_IRR SUB_AFTER_TAX_IRR, ITEM_INSURANCE_CATEGORY ITEM_INSURANCE_CATEGORY, QTE_ID QTE_ID, FUNDING_DATE FUNDING_DATE, STREAM_TYPE_SUBCLASS STREAM_TYPE_SUBCLASS, DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED, MANUFACTURER_NAME MANUFACTURER_NAME, MODEL_NUMBER MODEL_NUMBER, DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE, CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN, FEE_PURPOSE_CODE FEE_PURPOSE_CODE, TERMINATION_VALUE TERMINATION_VALUE, EXPECTED_ASSET_COST EXPECTED_ASSET_COST, ORIG_CONTRACT_LINE_ID ORIG_CONTRACT_LINE_ID, ORIGINATION_INCOME ORIGINATION_INCOME, AMOUNT_BALANCE_LEGACY AMOUNT_BALANCE_LEGACY, DT_EFFECTIVE_BALANCE_LEGACY DT_EFFECTIVE_BALANCE_LEGACY from "OKL"."OKL_K_LINES"

View Text - HTML Formatted

SELECT ID ID
, KLE_ID KLE_ID
, STY_ID STY_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAO_AMOUNT LAO_AMOUNT
, FEE_CHARGE FEE_CHARGE
, TITLE_DATE TITLE_DATE
, DATE_RESIDUAL_LAST_REVIEW DATE_RESIDUAL_LAST_REVIEW
, DATE_LAST_REAMORTISATION DATE_LAST_REAMORTISATION
, TERMINATION_PURCHASE_AMOUNT TERMINATION_PURCHASE_AMOUNT
, DATE_LAST_CLEANUP DATE_LAST_CLEANUP
, REMARKETED_AMOUNT REMARKETED_AMOUNT
, DATE_REMARKETED DATE_REMARKETED
, REMARKET_MARGIN REMARKET_MARGIN
, REPURCHASED_AMOUNT REPURCHASED_AMOUNT
, DATE_REPURCHASED DATE_REPURCHASED
, GAIN_LOSS GAIN_LOSS
, FLOOR_AMOUNT FLOOR_AMOUNT
, PREVIOUS_CONTRACT PREVIOUS_CONTRACT
, TRACKED_RESIDUAL TRACKED_RESIDUAL
, DATE_TITLE_RECEIVED DATE_TITLE_RECEIVED
, ESTIMATED_OEC ESTIMATED_OEC
, RESIDUAL_PERCENTAGE RESIDUAL_PERCENTAGE
, CAPITAL_REDUCTION CAPITAL_REDUCTION
, VENDOR_ADVANCE_PAID VENDOR_ADVANCE_PAID
, TRADEIN_AMOUNT TRADEIN_AMOUNT
, DELIVERED_DATE DELIVERED_DATE
, YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE
, INITIAL_DIRECT_COST INITIAL_DIRECT_COST
, OCCUPANCY OCCUPANCY
, DATE_LAST_INSPECTION DATE_LAST_INSPECTION
, DATE_NEXT_INSPECTION_DUE DATE_NEXT_INSPECTION_DUE
, WEIGHTED_AVERAGE_LIFE WEIGHTED_AVERAGE_LIFE
, BOND_EQUIVALENT_YIELD BOND_EQUIVALENT_YIELD
, REFINANCE_AMOUNT REFINANCE_AMOUNT
, YEAR_BUILT YEAR_BUILT
, COVERAGE_RATIO COVERAGE_RATIO
, GROSS_SQUARE_FOOTAGE GROSS_SQUARE_FOOTAGE
, NET_RENTABLE NET_RENTABLE
, DATE_LETTER_ACCEPTANCE DATE_LETTER_ACCEPTANCE
, DATE_COMMITMENT_EXPIRATION DATE_COMMITMENT_EXPIRATION
, DATE_APPRAISAL DATE_APPRAISAL
, APPRAISAL_VALUE APPRAISAL_VALUE
, RESIDUAL_VALUE RESIDUAL_VALUE
, PERCENT PERCENT
, COVERAGE COVERAGE
, LRV_AMOUNT LRV_AMOUNT
, AMOUNT AMOUNT
, LRS_PERCENT LRS_PERCENT
, EVERGREEN_PERCENT EVERGREEN_PERCENT
, PERCENT_STAKE PERCENT_STAKE
, AMOUNT_STAKE AMOUNT_STAKE
, DATE_SOLD DATE_SOLD
, STY_ID_FOR STY_ID_FOR
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NTY_CODE NTY_CODE
, FCG_CODE FCG_CODE
, PRC_CODE PRC_CODE
, RE_LEASE_YN RE_LEASE_YN
, PRESCRIBED_ASSET_YN PRESCRIBED_ASSET_YN
, CREDIT_TENANT_YN CREDIT_TENANT_YN
, SECURED_DEAL_YN SECURED_DEAL_YN
, CLG_ID CLG_ID
, DATE_FUNDING DATE_FUNDING
, DATE_FUNDING_REQUIRED DATE_FUNDING_REQUIRED
, DATE_ACCEPTED DATE_ACCEPTED
, DATE_DELIVERY_EXPECTED DATE_DELIVERY_EXPECTED
, OEC OEC
, CAPITAL_AMOUNT CAPITAL_AMOUNT
, RESIDUAL_GRNTY_AMOUNT RESIDUAL_GRNTY_AMOUNT
, RESIDUAL_CODE RESIDUAL_CODE
, RVI_PREMIUM RVI_PREMIUM
, CREDIT_NATURE CREDIT_NATURE
, CAPITALIZED_INTEREST CAPITALIZED_INTEREST
, CAPITAL_REDUCTION_PERCENT CAPITAL_REDUCTION_PERCENT
, DATE_PAY_INVESTOR_START DATE_PAY_INVESTOR_START
, PAY_INVESTOR_FREQUENCY PAY_INVESTOR_FREQUENCY
, PAY_INVESTOR_EVENT PAY_INVESTOR_EVENT
, PAY_INVESTOR_REMITTANCE_DAYS PAY_INVESTOR_REMITTANCE_DAYS
, FEE_TYPE FEE_TYPE
, SUBSIDY_ID SUBSIDY_ID
, SUBSIDY_OVERRIDE_AMOUNT SUBSIDY_OVERRIDE_AMOUNT
, PRE_TAX_YIELD PRE_TAX_YIELD
, AFTER_TAX_YIELD AFTER_TAX_YIELD
, IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, IMPLICIT_NON_IDC_INTEREST_RATE IMPLICIT_NON_IDC_INTEREST_RATE
, PRE_TAX_IRR PRE_TAX_IRR
, AFTER_TAX_IRR AFTER_TAX_IRR
, SUB_PRE_TAX_YIELD SUB_PRE_TAX_YIELD
, SUB_AFTER_TAX_YIELD SUB_AFTER_TAX_YIELD
, SUB_IMPL_INTEREST_RATE SUB_IMPL_INTEREST_RATE
, SUB_IMPL_NON_IDC_INT_RATE SUB_IMPL_NON_IDC_INT_RATE
, SUB_PRE_TAX_IRR SUB_PRE_TAX_IRR
, SUB_AFTER_TAX_IRR SUB_AFTER_TAX_IRR
, ITEM_INSURANCE_CATEGORY ITEM_INSURANCE_CATEGORY
, QTE_ID QTE_ID
, FUNDING_DATE FUNDING_DATE
, STREAM_TYPE_SUBCLASS STREAM_TYPE_SUBCLASS
, DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED
, MANUFACTURER_NAME MANUFACTURER_NAME
, MODEL_NUMBER MODEL_NUMBER
, DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE
, CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN
, FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, TERMINATION_VALUE TERMINATION_VALUE
, EXPECTED_ASSET_COST EXPECTED_ASSET_COST
, ORIG_CONTRACT_LINE_ID ORIG_CONTRACT_LINE_ID
, ORIGINATION_INCOME ORIGINATION_INCOME
, AMOUNT_BALANCE_LEGACY AMOUNT_BALANCE_LEGACY
, DT_EFFECTIVE_BALANCE_LEGACY DT_EFFECTIVE_BALANCE_LEGACY
FROM "OKL"."OKL_K_LINES"