VIEW: OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, CONTRACT_ID CONTRACT_ID, CONTRACT_LINE_ID CONTRACT_LINE_ID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_OPERATING_UNIT_ID CONTRACT_OPERATING_UNIT_ID, OPERATING_UNIT OPERATING_UNIT, OPERATING_UNIT_SHORT_CODE OPERATING_UNIT_SHORT_CODE, CONTRACT_STATUS_TYPE_CODE CONTRACT_STATUS_TYPE_CODE, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE, CONTRACT_STATUS CONTRACT_STATUS, CONTRACT_CURRENCY CONTRACT_CURRENCY, CONTRACT_CURRENCY_CONV_TYPE CONTRACT_CURRENCY_CONV_TYPE, CONTRACT_CURRENCY_CONV_RATE CONTRACT_CURRENCY_CONV_RATE, CONTRACT_CURRENCY_CONV_DATE CONTRACT_CURRENCY_CONV_DATE, FUNCTIONAL_CURRENCY FUNCTIONAL_CURRENCY, CONTRACT_START_DATE CONTRACT_START_DATE, CONTRACT_END_DATE CONTRACT_END_DATE, CONTRACT_FINANCIAL_PRODUCT_ID CONTRACT_FINANCIAL_PRODUCT_ID, CONTRACT_FINANCIAL_PRODUCT CONTRACT_FINANCIAL_PRODUCT, CONTRACT_REPORTING_PRODUCT_ID CONTRACT_REPORTING_PRODUCT_ID, CONTRACT_REPORTING_PRODUCT CONTRACT_REPORTING_PRODUCT, INTEREST_CALCLATION_BASIS_CODE INTEREST_CALCLATION_BASIS_CODE, REVENUE_RECOGNTION_METHOD_CODE REVENUE_RECOGNTION_METHOD_CODE, INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS, REVENUE_RECOGNITION_METHOD REVENUE_RECOGNITION_METHOD, CONTRACT_INTEREST_INDEX_ID CONTRACT_INTEREST_INDEX_ID, CONTRACT_INTEREST_INDEX CONTRACT_INTEREST_INDEX, CONTRACT_TERM_DURATION CONTRACT_TERM_DURATION, CONTRACT_BOOK_CLASS_CODE CONTRACT_BOOK_CLASS_CODE, CONTRACT_BOOK_CLASSIFICATION CONTRACT_BOOK_CLASSIFICATION, CONTRACT_LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID, LEGAL_ENTITY LEGAL_ENTITY, LEDGER_ID LEDGER_ID, LEDGER LEDGER, CNTRCT_CUSTOMER_PARTY_NAME CNTRCT_CUSTOMER_PARTY_NAME, CNTRCT_CUST_PARTY_ID CNTRCT_CUST_PARTY_ID, CNTRCT_CUST_PARTY_NUMBER CNTRCT_CUST_PARTY_NUMBER, CNTRCT_CUST_ACOUNT_ID CNTRCT_CUST_ACOUNT_ID, CNTRCT_CUST_ACCT_NUMBER CNTRCT_CUST_ACCT_NUMBER, CNTRCT_CUST_PARTY_SITE_ID CNTRCT_CUST_PARTY_SITE_ID, CNTRCT_CUST_PARTY_SITE_NUM CNTRCT_CUST_PARTY_SITE_NUM, CNTRCT_CUST_PARTY_SITE_NAME CNTRCT_CUST_PARTY_SITE_NAME, CNTRCT_CUST_PARTY_SITE_LOC_ID CNTRCT_CUST_PARTY_SITE_LOC_ID, CNTRCT_CUST_PARTY_SITE_USE_ID CNTRCT_CUST_PARTY_SITE_USE_ID, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONTRACT_LINE_TYPE_ID CONTRACT_LINE_TYPE_ID, CONTRACT_LINE_TYPE_CODE CONTRACT_LINE_TYPE_CODE, CONTRACT_LINE_TYPE_NAME CONTRACT_LINE_TYPE_NAME, CONTRACT_LINE_NAME CONTRACT_LINE_NAME, CONTRACT_LINE_STATUS_CODE CONTRACT_LINE_STATUS_CODE, CONTRACT_LINE_STATUS CONTRACT_LINE_STATUS, ASSET_DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED, ASSET_DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED, ASSET_RESIDUAL_PERCENT ASSET_RESIDUAL_PERCENT, ASSET_RES_GUARANTOR_TYPE_CODE ASSET_RES_GUARANTOR_TYPE_CODE, ASSET_RES_GUARANTOR_TYPE ASSET_RES_GUARANTOR_TYPE, ASSET_RESIDUAL_AMT_GUARANTEE ASSET_RESIDUAL_AMT_GUARANTEE, ASSET_RESIDUAL_AMOUNT ASSET_RESIDUAL_AMOUNT, ASSET_UPFRONT_TAX ASSET_UPFRONT_TAX, ASSET_BILL_TO_SITE_USE_ID ASSET_BILL_TO_SITE_USE_ID, ASSET_BILL_TO_ADDRESS ASSET_BILL_TO_ADDRESS, ASSET_BILLING_PAYMENT_METHOD ASSET_BILLING_PAYMENT_METHOD, ASSET_BILLING_BANK_ACCOUNT ASSET_BILLING_BANK_ACCOUNT, ASSET_BILLING_BANK ASSET_BILLING_BANK, ASSET_ST_TRANSFER_OF_TITLE ASSET_ST_TRANSFER_OF_TITLE, ASSET_ST_SALE_AND_LEASE_BACK ASSET_ST_SALE_AND_LEASE_BACK, ASSET_ST_PURCHASE_OF_LEASE ASSET_ST_PURCHASE_OF_LEASE, ASSET_ST_INTENDED_USE ASSET_ST_INTENDED_USE, ASSET_ST_ASSET_UPFRONT_TAX ASSET_ST_ASSET_UPFRONT_TAX, ASSET_ST_EQUIPMENT_AGE ASSET_ST_EQUIPMENT_AGE, ASSET_PROP_TAX_APPLICABLE ASSET_PROP_TAX_APPLICABLE, ASSET_PROP_TAX_LESSEE_REPORT ASSET_PROP_TAX_LESSEE_REPORT, ASSET_PROP_TAX_BILL_METHOD ASSET_PROP_TAX_BILL_METHOD, LINE_SUPPLIER_ID LINE_SUPPLIER_ID, LINE_SUPPLIER_NUMBER LINE_SUPPLIER_NUMBER, LINE_SUPPLIER LINE_SUPPLIER, INV_SUPPLR_SHIP_TO_SITE_USE_ID INV_SUPPLR_SHIP_TO_SITE_USE_ID, INV_SUPPLIER_SHIP_TO_SITE INV_SUPPLIER_SHIP_TO_SITE, INV_SUPPLIER_INVOICE_LINE_ID INV_SUPPLIER_INVOICE_LINE_ID, INV_SUPPLIER_INVOICE_NUMBER INV_SUPPLIER_INVOICE_NUMBER, INV_SUPPLIER_INVOICE_DATE INV_SUPPLIER_INVOICE_DATE, INV_SUPPLIER_SHIP_TO_SITE_ID INV_SUPPLIER_SHIP_TO_SITE_ID, INV_SUPPLIER_SHIP_TO_SITE_NUM INV_SUPPLIER_SHIP_TO_SITE_NUM, FIXED_ASSET_LINE_ID FIXED_ASSET_LINE_ID, FA_ASSET_KEY_ID FA_ASSET_KEY_ID, FA_ASSET_KEY FA_ASSET_KEY, FA_MANUFACTURER_NAME FA_MANUFACTURER_NAME, FA_ASSET_LOCATION_ID FA_ASSET_LOCATION_ID, FA_ASSET_LOCATION_NAME FA_ASSET_LOCATION_NAME, FA_MODEL_NUMBER FA_MODEL_NUMBER, FA_ASSET_ID FA_ASSET_ID, FA_CORP_BOOK_TYPE_CODE FA_CORP_BOOK_TYPE_CODE, FA_CORPORATE_BOOK FA_CORPORATE_BOOK, FA_CORP_SAL_VALUE_BASIS_CODE FA_CORP_SAL_VALUE_BASIS_CODE, FA_CORP_SAL_VALUE_BASIS FA_CORP_SAL_VALUE_BASIS, FA_CORP_SALVAGE_VALUE FA_CORP_SALVAGE_VALUE, FA_CORP_SALVAGE_VALUE_PERCENT FA_CORP_SALVAGE_VALUE_PERCENT, FA_CORP_DEP_RATE FA_CORP_DEP_RATE, FA_CORP_DEP_LIFE_IN_MONTHS FA_CORP_DEP_LIFE_IN_MONTHS, FA_CORP_DEP_METHOD_CODE FA_CORP_DEP_METHOD_CODE, FA_CORP_DEP_METHOD_ID FA_CORP_DEP_METHOD_ID, FA_CORP_DEP_METHOD_NAME FA_CORP_DEP_METHOD_NAME, FA_CORP_CATEGORY_ID FA_CORP_CATEGORY_ID, FA_CORP_CATEGORY FA_CORP_CATEGORY, FA_CORP_ORIG_COST FA_CORP_ORIG_COST, FA_CORP_DEP_COST FA_CORP_DEP_COST, FA_CORP_DATE_IN_SERVICE FA_CORP_DATE_IN_SERVICE, FA_TAX_BOOK_TYPE_CODE FA_TAX_BOOK_TYPE_CODE, FA_TAX_BOOK FA_TAX_BOOK, FA_TAX_SAL_VALUE_BASIS_CODE FA_TAX_SAL_VALUE_BASIS_CODE, FA_TAX_SAL_VALUE_BASIS FA_TAX_SAL_VALUE_BASIS, FA_TAX_SALVAGE_VALUE FA_TAX_SALVAGE_VALUE, FA_TAX_SALVAGE_VALUE_PERCENT FA_TAX_SALVAGE_VALUE_PERCENT, FA_TAX_DEP_RATE FA_TAX_DEP_RATE, FA_TAX_DEP_LIFE_IN_MONTHS FA_TAX_DEP_LIFE_IN_MONTHS, FA_TAX_DEP_METHOD_CODE FA_TAX_DEP_METHOD_CODE, FA_TAX_DEP_METHOD_ID FA_TAX_DEP_METHOD_ID, FA_TAX_DEP_METHOD_NAME FA_TAX_DEP_METHOD_NAME, FA_TAX_ORIG_COST FA_TAX_ORIG_COST, FA_TAX_DEP_COST FA_TAX_DEP_COST, FA_TAX_DATE_IN_SERVICE FA_TAX_DATE_IN_SERVICE, FEE_OR_SERVICE_NAME FEE_OR_SERVICE_NAME, FEE_OR_SERVICE_EFFECTIVE_FROM FEE_OR_SERVICE_EFFECTIVE_FROM, FEE_OR_SERVICE_EFFECTIVE_TO FEE_OR_SERVICE_EFFECTIVE_TO, FEE_OR_SERVICE_TOTAL_AMOUNT FEE_OR_SERVICE_TOTAL_AMOUNT, FEE_OR_SERV_NUMBER_OF_PERIODS FEE_OR_SERV_NUMBER_OF_PERIODS, FEE_OR_SERV_AMOUNT_PER_PERIOD FEE_OR_SERV_AMOUNT_PER_PERIOD, FEE_OR_SERVICE_FREQUENCY_CODE FEE_OR_SERVICE_FREQUENCY_CODE, FEE_OR_SERVICE_FREQUENCY FEE_OR_SERVICE_FREQUENCY, FEE_TYPE_CODE FEE_TYPE_CODE, FEE_TYPE FEE_TYPE, FEE_TRX_TAX_YN FEE_TRX_TAX_YN, FEE_INITIAL_DIRECT_COST FEE_INITIAL_DIRECT_COST, FEE_ROLLOVER_QUOTE_ID FEE_ROLLOVER_QUOTE_ID, FEE_ROLLOVER_QUOTE_NUMBER FEE_ROLLOVER_QUOTE_NUMBER, FEE_ROLLOVER_CONTRACT_NUMBER FEE_ROLLOVER_CONTRACT_NUMBER, SERVICE_CONTRACT_NUMBER SERVICE_CONTRACT_NUMBER, SERVICE_PAYMENT_TYPE SERVICE_PAYMENT_TYPE, INSURANCE_POLICY_ID INSURANCE_POLICY_ID, INSURANCE_QUOTE_NUMBER INSURANCE_QUOTE_NUMBER, INSURANCE_POLICY_NUMBER INSURANCE_POLICY_NUMBER, INSURANCE_POLICY_TYPE_CODE INSURANCE_POLICY_TYPE_CODE, INSURANCE_POLICY_TYPE INSURANCE_POLICY_TYPE, INSURANCE_POLICY_STATUS_CODE INSURANCE_POLICY_STATUS_CODE, INSURANCE_POLICY_STATUS INSURANCE_POLICY_STATUS, INSURANCE_PROVIDER INSURANCE_PROVIDER, INSURANCE_POLICY_LOCATION INSURANCE_POLICY_LOCATION, INSURANCE_PAYMENT_FREQUENCY INSURANCE_PAYMENT_FREQUENCY, INS_POLICY_LESSOR_INSURED_YN INS_POLICY_LESSOR_INSURED_YN, INS_POLICY_LESSOR_PAYEE_YN INS_POLICY_LESSOR_PAYEE_YN, INSURANCE_POLICY_EFF_FROM INSURANCE_POLICY_EFF_FROM, INSURANCE_POLICY_EFF_TO INSURANCE_POLICY_EFF_TO, INSURANCE_PRODUCT_ID INSURANCE_PRODUCT_ID, INSURANCE_PRODUCT INSURANCE_PRODUCT, INSURANCE_FACTOR_VALUE INSURANCE_FACTOR_VALUE, INSURANCE_NAME_OF_INSURED INSURANCE_NAME_OF_INSURED, INSURANCE_COVERED_AMOUNT INSURANCE_COVERED_AMOUNT, INSURANCE_CALC_PREMIUM INSURANCE_CALC_PREMIUM, INSURANCE_TOT_PREMIUM INSURANCE_TOT_PREMIUM, INSURANCE_ACTIVATION_DATE INSURANCE_ACTIVATION_DATE, INSURANCE_CANCELLATION_DATE INSURANCE_CANCELLATION_DATE, INSURANCE_SALES_REP INSURANCE_SALES_REP, MODEL_LINE_ID MODEL_LINE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM_ORG_ID INVENTORY_ITEM_ORG_ID, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, INVENTORY_ITEM_DESCRIPTION INVENTORY_ITEM_DESCRIPTION, INVENTORY_TOTAL_UNITS INVENTORY_TOTAL_UNITS, INVENTORY_UNIT_COST INVENTORY_UNIT_COST, ASSET_FILING_LIEN_TYPE_CODE ASSET_FILING_LIEN_TYPE_CODE, ASSET_FILING_LIEN_TYPE ASSET_FILING_LIEN_TYPE, ASSET_FILING_LIEN_NUMBER ASSET_FILING_LIEN_NUMBER, ASSET_FILING_LIEN_DATE ASSET_FILING_LIEN_DATE, ASSET_FILING_LIEN_STATUS_CODE ASSET_FILING_LIEN_STATUS_CODE, ASSET_FILING_LIEN_STATUS ASSET_FILING_LIEN_STATUS, ASSET_FILING_LIENHOLDER ASSET_FILING_LIENHOLDER, ASSET_FILING_JURISDICTION ASSET_FILING_JURISDICTION, ASSET_FILING_SUB_JURISDICTION ASSET_FILING_SUB_JURISDICTION, ASSET_FILING_LIEN_EXP_DATE ASSET_FILING_LIEN_EXP_DATE, ASSET_FILING_LIEN_CONT_NUMBER ASSET_FILING_LIEN_CONT_NUMBER, ASSET_FILING_LIEN_CONT_DATE ASSET_FILING_LIEN_CONT_DATE, ASSET_FILING_TITLE_TYPE_CODE ASSET_FILING_TITLE_TYPE_CODE, ASSET_FILING_TITLE_TYPE ASSET_FILING_TITLE_TYPE, ASSET_FILING_TITLE_NUMBER ASSET_FILING_TITLE_NUMBER, ASSET_FILING_TITLE_ISSUER ASSET_FILING_TITLE_ISSUER, ASSET_FILING_TITLE_DATE ASSET_FILING_TITLE_DATE, ASSET_FILING_TITLE_CUSTODIAN ASSET_FILING_TITLE_CUSTODIAN, ASSET_FILING_TITLE_REGIS_NUM ASSET_FILING_TITLE_REGIS_NUM, ASSET_FILING_TITLE_LOCATION ASSET_FILING_TITLE_LOCATION, ASSET_FILING_TITLE_REGIS_LOC ASSET_FILING_TITLE_REGIS_LOC, ASSET_FILING_PAYEE_SITE ASSET_FILING_PAYEE_SITE, ASSET_FILING_REGIS_EXP_DATE ASSET_FILING_REGIS_EXP_DATE, LINE_PTH_EVG_PAYOUT_BASIS_CODE LINE_PTH_EVG_PAYOUT_BASIS_CODE, LINE_PTH_EVG_PAYOUT_BASIS LINE_PTH_EVG_PAYOUT_BASIS, LINE_PTH_EVG_START_DATE LINE_PTH_EVG_START_DATE, LINE_PTH_EVG_PYOUT_FORMULA_ID LINE_PTH_EVG_PYOUT_FORMULA_ID, LINE_PTH_EVG_PYOUT_FORMULA LINE_PTH_EVG_PYOUT_FORMULA, LINE_PTH_EVG_STREAM_TYPE_ID LINE_PTH_EVG_STREAM_TYPE_ID, LINE_PTH_EVG_STREAM_TYPE_CODE LINE_PTH_EVG_STREAM_TYPE_CODE, LINE_PTH_EVG_STREAM_TYPE LINE_PTH_EVG_STREAM_TYPE, LINE_PTH_BASE_PAY_BASIS_CODE LINE_PTH_BASE_PAY_BASIS_CODE, LINE_PTH_BASE_PAYOUT_BASIS LINE_PTH_BASE_PAYOUT_BASIS, LINE_PTH_BASE_STREAM_TYPE_ID LINE_PTH_BASE_STREAM_TYPE_ID, LINE_PTH_BASE_STREAM_TYPE_CODE LINE_PTH_BASE_STREAM_TYPE_CODE, LINE_PTH_BASE_STREAM_TYPE LINE_PTH_BASE_STREAM_TYPE, LINE_PTH_BASE_START_DATE LINE_PTH_BASE_START_DATE, IB_INSTALL_SITE_ID IB_INSTALL_SITE_ID, IB_INSTALL_SITE_NUMBER IB_INSTALL_SITE_NUMBER, IB_INSTALL_SITE_USE_ID IB_INSTALL_SITE_USE_ID, IB_INSTALL_SITE IB_INSTALL_SITE, IB_SERIAL_NUMBER IB_SERIAL_NUMBER, FA_MG_BOOK_TYPE_CODE FA_MG_BOOK_TYPE_CODE, FA_MG_BOOK FA_MG_BOOK, FA_MG_SAL_VALUE_BASIS_CODE FA_MG_SAL_VALUE_BASIS_CODE, FA_MG_SAL_VALUE_BASIS FA_MG_SAL_VALUE_BASIS, FA_MG_SALVAGE_VALUE FA_MG_SALVAGE_VALUE, FA_MG_SALVAGE_VALUE_PERCENT FA_MG_SALVAGE_VALUE_PERCENT, FA_MG_DEP_RATE FA_MG_DEP_RATE, FA_MG_DEP_LIFE_IN_MONTHS FA_MG_DEP_LIFE_IN_MONTHS, FA_MG_DEP_METHOD_CODE FA_MG_DEP_METHOD_CODE, FA_MG_DEP_METHOD_ID FA_MG_DEP_METHOD_ID, FA_MG_DEP_METHOD_NAME FA_MG_DEP_METHOD_NAME, FA_MG_ORIG_COST FA_MG_ORIG_COST, FA_MG_DEP_COST FA_MG_DEP_COST, FA_MG_DATE_IN_SERVICE FA_MG_DATE_IN_SERVICE, USAGE_PRICE_LIST_ID USAGE_PRICE_LIST_ID, USAGE_PRICE_LIST_NAME USAGE_PRICE_LIST_NAME, USAGE_PERIOD_CODE USAGE_PERIOD_CODE, USAGE_PERIOD USAGE_PERIOD, USAGE_NO_OF_PERIOD USAGE_NO_OF_PERIOD, USAGE_MINIMUM_QTY USAGE_MINIMUM_QTY, USAGE_LEVEL_FLAG USAGE_LEVEL_FLAG, USAGE_DEFAULT_QUANTITY USAGE_DEFAULT_QUANTITY, USAGE_BASE_READING_UOM_CODE USAGE_BASE_READING_UOM_CODE, USAGE_BASE_READING_UOM USAGE_BASE_READING_UOM, USAGE_BASE_READING USAGE_BASE_READING, USAGE_AVG_MONTHLY_COUNTER_FLAG USAGE_AVG_MONTHLY_COUNTER_FLAG, USAGE_TYPE_CODE USAGE_TYPE_CODE, USAGE_TYPE USAGE_TYPE, USAGE_FIXED_QUANTITY USAGE_FIXED_QUANTITY, LINE_ACCUMULATED_DEPRECIATION LINE_ACCUMULATED_DEPRECIATION, LINE_CAPITALIZED_REDUCTION LINE_CAPITALIZED_REDUCTION, LINE_CAPITALIZED_INTEREST LINE_CAPITALIZED_INTEREST, LINE_DISCOUNT LINE_DISCOUNT, LINE_UNBILLED_DUE_AMOUNT LINE_UNBILLED_DUE_AMOUNT, LINE_OEC LINE_OEC, LINE_CAP_AMOUNT LINE_CAP_AMOUNT, LINE_ASSET_COST LINE_ASSET_COST, LINE_RESIDUAL_AMOUNT LINE_RESIDUAL_AMOUNT, LINE_RENT_AMOUNT LINE_RENT_AMOUNT, LINE_NET_INVESTMENT LINE_NET_INVESTMENT, LINE_NET_INVESTMENT_FUNC LINE_NET_INVESTMENT_FUNC, LINE_BILLED_RENTS LINE_BILLED_RENTS, LINE_BILLED_RENTS_FUNC LINE_BILLED_RENTS_FUNC, LINE_BILLED_NON_RENTS LINE_BILLED_NON_RENTS, LINE_BILLED_NON_RENTS_FUNC LINE_BILLED_NON_RENTS_FUNC, ASSETS_FUNDED_AMOUNT ASSETS_FUNDED_AMOUNT, EXPENSE_FUNDED_AMOUNT EXPENSE_FUNDED_AMOUNT, ASSET_TERMINATION_DATE ASSET_TERMINATION_DATE, TOTAL_ASSET_ADDON_COST TOTAL_ASSET_ADDON_COST, TOTAL_ASSET_SUBSIDY_AMOUNT TOTAL_ASSET_SUBSIDY_AMOUNT, TOTAL_ASSET_SUBSIDY_OVRD_AMT TOTAL_ASSET_SUBSIDY_OVRD_AMT, TOTAL_ASSET_CAP_SERVICE_AMOUNT TOTAL_ASSET_CAP_SERVICE_AMOUNT, TOTAL_ASSET_CAP_FEE_AMOUNT TOTAL_ASSET_CAP_FEE_AMOUNT, TOTAL_ASSET_FINANCED_FEE_AMT TOTAL_ASSET_FINANCED_FEE_AMT, TOTAL_ASSET_ROLLOVER_FEE_AMT TOTAL_ASSET_ROLLOVER_FEE_AMT, TOTAL_ASSET_TRADEIN_AMOUNT TOTAL_ASSET_TRADEIN_AMOUNT, TOTAL_ACTIVE_LINE_FINANCED_AMT TOTAL_ACTIVE_LINE_FINANCED_AMT, CONTRACT_LINE_DFF_CATEGORY CONTRACT_LINE_DFF_CATEGORY, CONTRACT_LINE_DFF1 CONTRACT_LINE_DFF1, CONTRACT_LINE_DFF2 CONTRACT_LINE_DFF2, CONTRACT_LINE_DFF3 CONTRACT_LINE_DFF3, CONTRACT_LINE_DFF4 CONTRACT_LINE_DFF4, CONTRACT_LINE_DFF5 CONTRACT_LINE_DFF5, CONTRACT_LINE_DFF6 CONTRACT_LINE_DFF6, CONTRACT_LINE_DFF7 CONTRACT_LINE_DFF7, CONTRACT_LINE_DFF8 CONTRACT_LINE_DFF8, CONTRACT_LINE_DFF9 CONTRACT_LINE_DFF9, CONTRACT_LINE_DFF10 CONTRACT_LINE_DFF10, CONTRACT_LINE_DFF11 CONTRACT_LINE_DFF11, CONTRACT_LINE_DFF12 CONTRACT_LINE_DFF12, CONTRACT_LINE_DFF13 CONTRACT_LINE_DFF13, CONTRACT_LINE_DFF14 CONTRACT_LINE_DFF14, CONTRACT_LINE_DFF15 CONTRACT_LINE_DFF15, ASSET_BILLING_BANK_ACCT_ID ASSET_BILLING_BANK_ACCT_ID from "OKL"."OKL_CNTRCT_LINE_FIN_EXTRACT_T"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, CONTRACT_ID CONTRACT_ID
, CONTRACT_LINE_ID CONTRACT_LINE_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_OPERATING_UNIT_ID CONTRACT_OPERATING_UNIT_ID
, OPERATING_UNIT OPERATING_UNIT
, OPERATING_UNIT_SHORT_CODE OPERATING_UNIT_SHORT_CODE
, CONTRACT_STATUS_TYPE_CODE CONTRACT_STATUS_TYPE_CODE
, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE
, CONTRACT_STATUS CONTRACT_STATUS
, CONTRACT_CURRENCY CONTRACT_CURRENCY
, CONTRACT_CURRENCY_CONV_TYPE CONTRACT_CURRENCY_CONV_TYPE
, CONTRACT_CURRENCY_CONV_RATE CONTRACT_CURRENCY_CONV_RATE
, CONTRACT_CURRENCY_CONV_DATE CONTRACT_CURRENCY_CONV_DATE
, FUNCTIONAL_CURRENCY FUNCTIONAL_CURRENCY
, CONTRACT_START_DATE CONTRACT_START_DATE
, CONTRACT_END_DATE CONTRACT_END_DATE
, CONTRACT_FINANCIAL_PRODUCT_ID CONTRACT_FINANCIAL_PRODUCT_ID
, CONTRACT_FINANCIAL_PRODUCT CONTRACT_FINANCIAL_PRODUCT
, CONTRACT_REPORTING_PRODUCT_ID CONTRACT_REPORTING_PRODUCT_ID
, CONTRACT_REPORTING_PRODUCT CONTRACT_REPORTING_PRODUCT
, INTEREST_CALCLATION_BASIS_CODE INTEREST_CALCLATION_BASIS_CODE
, REVENUE_RECOGNTION_METHOD_CODE REVENUE_RECOGNTION_METHOD_CODE
, INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS
, REVENUE_RECOGNITION_METHOD REVENUE_RECOGNITION_METHOD
, CONTRACT_INTEREST_INDEX_ID CONTRACT_INTEREST_INDEX_ID
, CONTRACT_INTEREST_INDEX CONTRACT_INTEREST_INDEX
, CONTRACT_TERM_DURATION CONTRACT_TERM_DURATION
, CONTRACT_BOOK_CLASS_CODE CONTRACT_BOOK_CLASS_CODE
, CONTRACT_BOOK_CLASSIFICATION CONTRACT_BOOK_CLASSIFICATION
, CONTRACT_LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID
, LEGAL_ENTITY LEGAL_ENTITY
, LEDGER_ID LEDGER_ID
, LEDGER LEDGER
, CNTRCT_CUSTOMER_PARTY_NAME CNTRCT_CUSTOMER_PARTY_NAME
, CNTRCT_CUST_PARTY_ID CNTRCT_CUST_PARTY_ID
, CNTRCT_CUST_PARTY_NUMBER CNTRCT_CUST_PARTY_NUMBER
, CNTRCT_CUST_ACOUNT_ID CNTRCT_CUST_ACOUNT_ID
, CNTRCT_CUST_ACCT_NUMBER CNTRCT_CUST_ACCT_NUMBER
, CNTRCT_CUST_PARTY_SITE_ID CNTRCT_CUST_PARTY_SITE_ID
, CNTRCT_CUST_PARTY_SITE_NUM CNTRCT_CUST_PARTY_SITE_NUM
, CNTRCT_CUST_PARTY_SITE_NAME CNTRCT_CUST_PARTY_SITE_NAME
, CNTRCT_CUST_PARTY_SITE_LOC_ID CNTRCT_CUST_PARTY_SITE_LOC_ID
, CNTRCT_CUST_PARTY_SITE_USE_ID CNTRCT_CUST_PARTY_SITE_USE_ID
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONTRACT_LINE_TYPE_ID CONTRACT_LINE_TYPE_ID
, CONTRACT_LINE_TYPE_CODE CONTRACT_LINE_TYPE_CODE
, CONTRACT_LINE_TYPE_NAME CONTRACT_LINE_TYPE_NAME
, CONTRACT_LINE_NAME CONTRACT_LINE_NAME
, CONTRACT_LINE_STATUS_CODE CONTRACT_LINE_STATUS_CODE
, CONTRACT_LINE_STATUS CONTRACT_LINE_STATUS
, ASSET_DATE_DELIVERY_EXPECTED ASSET_DATE_DELIVERY_EXPECTED
, ASSET_DATE_FUNDING_EXPECTED ASSET_DATE_FUNDING_EXPECTED
, ASSET_RESIDUAL_PERCENT ASSET_RESIDUAL_PERCENT
, ASSET_RES_GUARANTOR_TYPE_CODE ASSET_RES_GUARANTOR_TYPE_CODE
, ASSET_RES_GUARANTOR_TYPE ASSET_RES_GUARANTOR_TYPE
, ASSET_RESIDUAL_AMT_GUARANTEE ASSET_RESIDUAL_AMT_GUARANTEE
, ASSET_RESIDUAL_AMOUNT ASSET_RESIDUAL_AMOUNT
, ASSET_UPFRONT_TAX ASSET_UPFRONT_TAX
, ASSET_BILL_TO_SITE_USE_ID ASSET_BILL_TO_SITE_USE_ID
, ASSET_BILL_TO_ADDRESS ASSET_BILL_TO_ADDRESS
, ASSET_BILLING_PAYMENT_METHOD ASSET_BILLING_PAYMENT_METHOD
, ASSET_BILLING_BANK_ACCOUNT ASSET_BILLING_BANK_ACCOUNT
, ASSET_BILLING_BANK ASSET_BILLING_BANK
, ASSET_ST_TRANSFER_OF_TITLE ASSET_ST_TRANSFER_OF_TITLE
, ASSET_ST_SALE_AND_LEASE_BACK ASSET_ST_SALE_AND_LEASE_BACK
, ASSET_ST_PURCHASE_OF_LEASE ASSET_ST_PURCHASE_OF_LEASE
, ASSET_ST_INTENDED_USE ASSET_ST_INTENDED_USE
, ASSET_ST_ASSET_UPFRONT_TAX ASSET_ST_ASSET_UPFRONT_TAX
, ASSET_ST_EQUIPMENT_AGE ASSET_ST_EQUIPMENT_AGE
, ASSET_PROP_TAX_APPLICABLE ASSET_PROP_TAX_APPLICABLE
, ASSET_PROP_TAX_LESSEE_REPORT ASSET_PROP_TAX_LESSEE_REPORT
, ASSET_PROP_TAX_BILL_METHOD ASSET_PROP_TAX_BILL_METHOD
, LINE_SUPPLIER_ID LINE_SUPPLIER_ID
, LINE_SUPPLIER_NUMBER LINE_SUPPLIER_NUMBER
, LINE_SUPPLIER LINE_SUPPLIER
, INV_SUPPLR_SHIP_TO_SITE_USE_ID INV_SUPPLR_SHIP_TO_SITE_USE_ID
, INV_SUPPLIER_SHIP_TO_SITE INV_SUPPLIER_SHIP_TO_SITE
, INV_SUPPLIER_INVOICE_LINE_ID INV_SUPPLIER_INVOICE_LINE_ID
, INV_SUPPLIER_INVOICE_NUMBER INV_SUPPLIER_INVOICE_NUMBER
, INV_SUPPLIER_INVOICE_DATE INV_SUPPLIER_INVOICE_DATE
, INV_SUPPLIER_SHIP_TO_SITE_ID INV_SUPPLIER_SHIP_TO_SITE_ID
, INV_SUPPLIER_SHIP_TO_SITE_NUM INV_SUPPLIER_SHIP_TO_SITE_NUM
, FIXED_ASSET_LINE_ID FIXED_ASSET_LINE_ID
, FA_ASSET_KEY_ID FA_ASSET_KEY_ID
, FA_ASSET_KEY FA_ASSET_KEY
, FA_MANUFACTURER_NAME FA_MANUFACTURER_NAME
, FA_ASSET_LOCATION_ID FA_ASSET_LOCATION_ID
, FA_ASSET_LOCATION_NAME FA_ASSET_LOCATION_NAME
, FA_MODEL_NUMBER FA_MODEL_NUMBER
, FA_ASSET_ID FA_ASSET_ID
, FA_CORP_BOOK_TYPE_CODE FA_CORP_BOOK_TYPE_CODE
, FA_CORPORATE_BOOK FA_CORPORATE_BOOK
, FA_CORP_SAL_VALUE_BASIS_CODE FA_CORP_SAL_VALUE_BASIS_CODE
, FA_CORP_SAL_VALUE_BASIS FA_CORP_SAL_VALUE_BASIS
, FA_CORP_SALVAGE_VALUE FA_CORP_SALVAGE_VALUE
, FA_CORP_SALVAGE_VALUE_PERCENT FA_CORP_SALVAGE_VALUE_PERCENT
, FA_CORP_DEP_RATE FA_CORP_DEP_RATE
, FA_CORP_DEP_LIFE_IN_MONTHS FA_CORP_DEP_LIFE_IN_MONTHS
, FA_CORP_DEP_METHOD_CODE FA_CORP_DEP_METHOD_CODE
, FA_CORP_DEP_METHOD_ID FA_CORP_DEP_METHOD_ID
, FA_CORP_DEP_METHOD_NAME FA_CORP_DEP_METHOD_NAME
, FA_CORP_CATEGORY_ID FA_CORP_CATEGORY_ID
, FA_CORP_CATEGORY FA_CORP_CATEGORY
, FA_CORP_ORIG_COST FA_CORP_ORIG_COST
, FA_CORP_DEP_COST FA_CORP_DEP_COST
, FA_CORP_DATE_IN_SERVICE FA_CORP_DATE_IN_SERVICE
, FA_TAX_BOOK_TYPE_CODE FA_TAX_BOOK_TYPE_CODE
, FA_TAX_BOOK FA_TAX_BOOK
, FA_TAX_SAL_VALUE_BASIS_CODE FA_TAX_SAL_VALUE_BASIS_CODE
, FA_TAX_SAL_VALUE_BASIS FA_TAX_SAL_VALUE_BASIS
, FA_TAX_SALVAGE_VALUE FA_TAX_SALVAGE_VALUE
, FA_TAX_SALVAGE_VALUE_PERCENT FA_TAX_SALVAGE_VALUE_PERCENT
, FA_TAX_DEP_RATE FA_TAX_DEP_RATE
, FA_TAX_DEP_LIFE_IN_MONTHS FA_TAX_DEP_LIFE_IN_MONTHS
, FA_TAX_DEP_METHOD_CODE FA_TAX_DEP_METHOD_CODE
, FA_TAX_DEP_METHOD_ID FA_TAX_DEP_METHOD_ID
, FA_TAX_DEP_METHOD_NAME FA_TAX_DEP_METHOD_NAME
, FA_TAX_ORIG_COST FA_TAX_ORIG_COST
, FA_TAX_DEP_COST FA_TAX_DEP_COST
, FA_TAX_DATE_IN_SERVICE FA_TAX_DATE_IN_SERVICE
, FEE_OR_SERVICE_NAME FEE_OR_SERVICE_NAME
, FEE_OR_SERVICE_EFFECTIVE_FROM FEE_OR_SERVICE_EFFECTIVE_FROM
, FEE_OR_SERVICE_EFFECTIVE_TO FEE_OR_SERVICE_EFFECTIVE_TO
, FEE_OR_SERVICE_TOTAL_AMOUNT FEE_OR_SERVICE_TOTAL_AMOUNT
, FEE_OR_SERV_NUMBER_OF_PERIODS FEE_OR_SERV_NUMBER_OF_PERIODS
, FEE_OR_SERV_AMOUNT_PER_PERIOD FEE_OR_SERV_AMOUNT_PER_PERIOD
, FEE_OR_SERVICE_FREQUENCY_CODE FEE_OR_SERVICE_FREQUENCY_CODE
, FEE_OR_SERVICE_FREQUENCY FEE_OR_SERVICE_FREQUENCY
, FEE_TYPE_CODE FEE_TYPE_CODE
, FEE_TYPE FEE_TYPE
, FEE_TRX_TAX_YN FEE_TRX_TAX_YN
, FEE_INITIAL_DIRECT_COST FEE_INITIAL_DIRECT_COST
, FEE_ROLLOVER_QUOTE_ID FEE_ROLLOVER_QUOTE_ID
, FEE_ROLLOVER_QUOTE_NUMBER FEE_ROLLOVER_QUOTE_NUMBER
, FEE_ROLLOVER_CONTRACT_NUMBER FEE_ROLLOVER_CONTRACT_NUMBER
, SERVICE_CONTRACT_NUMBER SERVICE_CONTRACT_NUMBER
, SERVICE_PAYMENT_TYPE SERVICE_PAYMENT_TYPE
, INSURANCE_POLICY_ID INSURANCE_POLICY_ID
, INSURANCE_QUOTE_NUMBER INSURANCE_QUOTE_NUMBER
, INSURANCE_POLICY_NUMBER INSURANCE_POLICY_NUMBER
, INSURANCE_POLICY_TYPE_CODE INSURANCE_POLICY_TYPE_CODE
, INSURANCE_POLICY_TYPE INSURANCE_POLICY_TYPE
, INSURANCE_POLICY_STATUS_CODE INSURANCE_POLICY_STATUS_CODE
, INSURANCE_POLICY_STATUS INSURANCE_POLICY_STATUS
, INSURANCE_PROVIDER INSURANCE_PROVIDER
, INSURANCE_POLICY_LOCATION INSURANCE_POLICY_LOCATION
, INSURANCE_PAYMENT_FREQUENCY INSURANCE_PAYMENT_FREQUENCY
, INS_POLICY_LESSOR_INSURED_YN INS_POLICY_LESSOR_INSURED_YN
, INS_POLICY_LESSOR_PAYEE_YN INS_POLICY_LESSOR_PAYEE_YN
, INSURANCE_POLICY_EFF_FROM INSURANCE_POLICY_EFF_FROM
, INSURANCE_POLICY_EFF_TO INSURANCE_POLICY_EFF_TO
, INSURANCE_PRODUCT_ID INSURANCE_PRODUCT_ID
, INSURANCE_PRODUCT INSURANCE_PRODUCT
, INSURANCE_FACTOR_VALUE INSURANCE_FACTOR_VALUE
, INSURANCE_NAME_OF_INSURED INSURANCE_NAME_OF_INSURED
, INSURANCE_COVERED_AMOUNT INSURANCE_COVERED_AMOUNT
, INSURANCE_CALC_PREMIUM INSURANCE_CALC_PREMIUM
, INSURANCE_TOT_PREMIUM INSURANCE_TOT_PREMIUM
, INSURANCE_ACTIVATION_DATE INSURANCE_ACTIVATION_DATE
, INSURANCE_CANCELLATION_DATE INSURANCE_CANCELLATION_DATE
, INSURANCE_SALES_REP INSURANCE_SALES_REP
, MODEL_LINE_ID MODEL_LINE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_ORG_ID INVENTORY_ITEM_ORG_ID
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, INVENTORY_ITEM_DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, INVENTORY_TOTAL_UNITS INVENTORY_TOTAL_UNITS
, INVENTORY_UNIT_COST INVENTORY_UNIT_COST
, ASSET_FILING_LIEN_TYPE_CODE ASSET_FILING_LIEN_TYPE_CODE
, ASSET_FILING_LIEN_TYPE ASSET_FILING_LIEN_TYPE
, ASSET_FILING_LIEN_NUMBER ASSET_FILING_LIEN_NUMBER
, ASSET_FILING_LIEN_DATE ASSET_FILING_LIEN_DATE
, ASSET_FILING_LIEN_STATUS_CODE ASSET_FILING_LIEN_STATUS_CODE
, ASSET_FILING_LIEN_STATUS ASSET_FILING_LIEN_STATUS
, ASSET_FILING_LIENHOLDER ASSET_FILING_LIENHOLDER
, ASSET_FILING_JURISDICTION ASSET_FILING_JURISDICTION
, ASSET_FILING_SUB_JURISDICTION ASSET_FILING_SUB_JURISDICTION
, ASSET_FILING_LIEN_EXP_DATE ASSET_FILING_LIEN_EXP_DATE
, ASSET_FILING_LIEN_CONT_NUMBER ASSET_FILING_LIEN_CONT_NUMBER
, ASSET_FILING_LIEN_CONT_DATE ASSET_FILING_LIEN_CONT_DATE
, ASSET_FILING_TITLE_TYPE_CODE ASSET_FILING_TITLE_TYPE_CODE
, ASSET_FILING_TITLE_TYPE ASSET_FILING_TITLE_TYPE
, ASSET_FILING_TITLE_NUMBER ASSET_FILING_TITLE_NUMBER
, ASSET_FILING_TITLE_ISSUER ASSET_FILING_TITLE_ISSUER
, ASSET_FILING_TITLE_DATE ASSET_FILING_TITLE_DATE
, ASSET_FILING_TITLE_CUSTODIAN ASSET_FILING_TITLE_CUSTODIAN
, ASSET_FILING_TITLE_REGIS_NUM ASSET_FILING_TITLE_REGIS_NUM
, ASSET_FILING_TITLE_LOCATION ASSET_FILING_TITLE_LOCATION
, ASSET_FILING_TITLE_REGIS_LOC ASSET_FILING_TITLE_REGIS_LOC
, ASSET_FILING_PAYEE_SITE ASSET_FILING_PAYEE_SITE
, ASSET_FILING_REGIS_EXP_DATE ASSET_FILING_REGIS_EXP_DATE
, LINE_PTH_EVG_PAYOUT_BASIS_CODE LINE_PTH_EVG_PAYOUT_BASIS_CODE
, LINE_PTH_EVG_PAYOUT_BASIS LINE_PTH_EVG_PAYOUT_BASIS
, LINE_PTH_EVG_START_DATE LINE_PTH_EVG_START_DATE
, LINE_PTH_EVG_PYOUT_FORMULA_ID LINE_PTH_EVG_PYOUT_FORMULA_ID
, LINE_PTH_EVG_PYOUT_FORMULA LINE_PTH_EVG_PYOUT_FORMULA
, LINE_PTH_EVG_STREAM_TYPE_ID LINE_PTH_EVG_STREAM_TYPE_ID
, LINE_PTH_EVG_STREAM_TYPE_CODE LINE_PTH_EVG_STREAM_TYPE_CODE
, LINE_PTH_EVG_STREAM_TYPE LINE_PTH_EVG_STREAM_TYPE
, LINE_PTH_BASE_PAY_BASIS_CODE LINE_PTH_BASE_PAY_BASIS_CODE
, LINE_PTH_BASE_PAYOUT_BASIS LINE_PTH_BASE_PAYOUT_BASIS
, LINE_PTH_BASE_STREAM_TYPE_ID LINE_PTH_BASE_STREAM_TYPE_ID
, LINE_PTH_BASE_STREAM_TYPE_CODE LINE_PTH_BASE_STREAM_TYPE_CODE
, LINE_PTH_BASE_STREAM_TYPE LINE_PTH_BASE_STREAM_TYPE
, LINE_PTH_BASE_START_DATE LINE_PTH_BASE_START_DATE
, IB_INSTALL_SITE_ID IB_INSTALL_SITE_ID
, IB_INSTALL_SITE_NUMBER IB_INSTALL_SITE_NUMBER
, IB_INSTALL_SITE_USE_ID IB_INSTALL_SITE_USE_ID
, IB_INSTALL_SITE IB_INSTALL_SITE
, IB_SERIAL_NUMBER IB_SERIAL_NUMBER
, FA_MG_BOOK_TYPE_CODE FA_MG_BOOK_TYPE_CODE
, FA_MG_BOOK FA_MG_BOOK
, FA_MG_SAL_VALUE_BASIS_CODE FA_MG_SAL_VALUE_BASIS_CODE
, FA_MG_SAL_VALUE_BASIS FA_MG_SAL_VALUE_BASIS
, FA_MG_SALVAGE_VALUE FA_MG_SALVAGE_VALUE
, FA_MG_SALVAGE_VALUE_PERCENT FA_MG_SALVAGE_VALUE_PERCENT
, FA_MG_DEP_RATE FA_MG_DEP_RATE
, FA_MG_DEP_LIFE_IN_MONTHS FA_MG_DEP_LIFE_IN_MONTHS
, FA_MG_DEP_METHOD_CODE FA_MG_DEP_METHOD_CODE
, FA_MG_DEP_METHOD_ID FA_MG_DEP_METHOD_ID
, FA_MG_DEP_METHOD_NAME FA_MG_DEP_METHOD_NAME
, FA_MG_ORIG_COST FA_MG_ORIG_COST
, FA_MG_DEP_COST FA_MG_DEP_COST
, FA_MG_DATE_IN_SERVICE FA_MG_DATE_IN_SERVICE
, USAGE_PRICE_LIST_ID USAGE_PRICE_LIST_ID
, USAGE_PRICE_LIST_NAME USAGE_PRICE_LIST_NAME
, USAGE_PERIOD_CODE USAGE_PERIOD_CODE
, USAGE_PERIOD USAGE_PERIOD
, USAGE_NO_OF_PERIOD USAGE_NO_OF_PERIOD
, USAGE_MINIMUM_QTY USAGE_MINIMUM_QTY
, USAGE_LEVEL_FLAG USAGE_LEVEL_FLAG
, USAGE_DEFAULT_QUANTITY USAGE_DEFAULT_QUANTITY
, USAGE_BASE_READING_UOM_CODE USAGE_BASE_READING_UOM_CODE
, USAGE_BASE_READING_UOM USAGE_BASE_READING_UOM
, USAGE_BASE_READING USAGE_BASE_READING
, USAGE_AVG_MONTHLY_COUNTER_FLAG USAGE_AVG_MONTHLY_COUNTER_FLAG
, USAGE_TYPE_CODE USAGE_TYPE_CODE
, USAGE_TYPE USAGE_TYPE
, USAGE_FIXED_QUANTITY USAGE_FIXED_QUANTITY
, LINE_ACCUMULATED_DEPRECIATION LINE_ACCUMULATED_DEPRECIATION
, LINE_CAPITALIZED_REDUCTION LINE_CAPITALIZED_REDUCTION
, LINE_CAPITALIZED_INTEREST LINE_CAPITALIZED_INTEREST
, LINE_DISCOUNT LINE_DISCOUNT
, LINE_UNBILLED_DUE_AMOUNT LINE_UNBILLED_DUE_AMOUNT
, LINE_OEC LINE_OEC
, LINE_CAP_AMOUNT LINE_CAP_AMOUNT
, LINE_ASSET_COST LINE_ASSET_COST
, LINE_RESIDUAL_AMOUNT LINE_RESIDUAL_AMOUNT
, LINE_RENT_AMOUNT LINE_RENT_AMOUNT
, LINE_NET_INVESTMENT LINE_NET_INVESTMENT
, LINE_NET_INVESTMENT_FUNC LINE_NET_INVESTMENT_FUNC
, LINE_BILLED_RENTS LINE_BILLED_RENTS
, LINE_BILLED_RENTS_FUNC LINE_BILLED_RENTS_FUNC
, LINE_BILLED_NON_RENTS LINE_BILLED_NON_RENTS
, LINE_BILLED_NON_RENTS_FUNC LINE_BILLED_NON_RENTS_FUNC
, ASSETS_FUNDED_AMOUNT ASSETS_FUNDED_AMOUNT
, EXPENSE_FUNDED_AMOUNT EXPENSE_FUNDED_AMOUNT
, ASSET_TERMINATION_DATE ASSET_TERMINATION_DATE
, TOTAL_ASSET_ADDON_COST TOTAL_ASSET_ADDON_COST
, TOTAL_ASSET_SUBSIDY_AMOUNT TOTAL_ASSET_SUBSIDY_AMOUNT
, TOTAL_ASSET_SUBSIDY_OVRD_AMT TOTAL_ASSET_SUBSIDY_OVRD_AMT
, TOTAL_ASSET_CAP_SERVICE_AMOUNT TOTAL_ASSET_CAP_SERVICE_AMOUNT
, TOTAL_ASSET_CAP_FEE_AMOUNT TOTAL_ASSET_CAP_FEE_AMOUNT
, TOTAL_ASSET_FINANCED_FEE_AMT TOTAL_ASSET_FINANCED_FEE_AMT
, TOTAL_ASSET_ROLLOVER_FEE_AMT TOTAL_ASSET_ROLLOVER_FEE_AMT
, TOTAL_ASSET_TRADEIN_AMOUNT TOTAL_ASSET_TRADEIN_AMOUNT
, TOTAL_ACTIVE_LINE_FINANCED_AMT TOTAL_ACTIVE_LINE_FINANCED_AMT
, CONTRACT_LINE_DFF_CATEGORY CONTRACT_LINE_DFF_CATEGORY
, CONTRACT_LINE_DFF1 CONTRACT_LINE_DFF1
, CONTRACT_LINE_DFF2 CONTRACT_LINE_DFF2
, CONTRACT_LINE_DFF3 CONTRACT_LINE_DFF3
, CONTRACT_LINE_DFF4 CONTRACT_LINE_DFF4
, CONTRACT_LINE_DFF5 CONTRACT_LINE_DFF5
, CONTRACT_LINE_DFF6 CONTRACT_LINE_DFF6
, CONTRACT_LINE_DFF7 CONTRACT_LINE_DFF7
, CONTRACT_LINE_DFF8 CONTRACT_LINE_DFF8
, CONTRACT_LINE_DFF9 CONTRACT_LINE_DFF9
, CONTRACT_LINE_DFF10 CONTRACT_LINE_DFF10
, CONTRACT_LINE_DFF11 CONTRACT_LINE_DFF11
, CONTRACT_LINE_DFF12 CONTRACT_LINE_DFF12
, CONTRACT_LINE_DFF13 CONTRACT_LINE_DFF13
, CONTRACT_LINE_DFF14 CONTRACT_LINE_DFF14
, CONTRACT_LINE_DFF15 CONTRACT_LINE_DFF15
, ASSET_BILLING_BANK_ACCT_ID ASSET_BILLING_BANK_ACCT_ID
FROM "OKL"."OKL_CNTRCT_LINE_FIN_EXTRACT_T"