eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T#

Object Details

Object Name:	OKL_CNTRCT_LINE_FIN_EXTRACT_T#
Object Type:	VIEW
Owner:	OKL
Subobject Name:
Status:	VALID

[View Source]

Columns

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

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T# references the following:

OKL: OKL_CNTRCT_LINE_FIN_EXTRACT_T

OKL.OKL_CNTRCT_LINE_FIN_EXTRACT_T# is referenced by following:

APPS: OKL_CNTRCT_LINE_FIN_EXTRACT_T