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_LINES_INTERFACE#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
CONTRACT_NUMBER_OLD	VARCHAR2	(30)	Yes
LINE_NUMBER	NUMBER		Yes
LINE_TYPE	VARCHAR2	(30)	Yes
ASSET_NUMBER	VARCHAR2	(15)
LINK_ASSET_NUMBER	VARCHAR2	(15)
ORIGINAL_COST	NUMBER
TOTAL_UNITS	NUMBER
AMOUNT	NUMBER
STATUS	VARCHAR2	(40)
DATE_APPROVED	DATE
DATE_SIGNED	DATE
CURRENCY_CODE	VARCHAR2	(3)
INVENTORY_ORGANIZATION_NAME	VARCHAR2	(240)
INVENTORY_ORGANIZATION_ID	NUMBER
INVENTORY_ITEM_NAME	VARCHAR2	(1000)
INVENTORY_ITEM_ID	NUMBER
DESCRIPTION	VARCHAR2	(1995)
MODEL	VARCHAR2	(40)
MAKE	VARCHAR2	(360)
YEAR_OF_MANUFACTURE	NUMBER
INSTALL_SITE_NUMBER	VARCHAR2	(30)
INSTALL_SITE_ID	NUMBER
RESIDUAL_PERCENT	NUMBER
RESIDUAL_AMOUNT	NUMBER
RESIDUAL_AMOUNT_GUARANTEE	NUMBER
RESIDUAL_AMOUNT_GUARANTEE_PV	NUMBER
GUARANTOR_TYPE_CODE	VARCHAR2	(30)
TRADE_IN_AMOUNT	NUMBER
CAPITAL_REDUCTION_PERCENT	NUMBER
CAPITAL_REDUCTION_AMOUNT	NUMBER
INTERIM_INT_CAPITALIZED_AMT	NUMBER
ASSET_CORPORATE_BOOK	VARCHAR2	(15)
ASSET_CATEGORY_SEGMENT1	VARCHAR2	(30)
ASSET_CATEGORY_SEGMENT2	VARCHAR2	(30)
ASSET_CATEGORY_SEGMENT3	VARCHAR2	(30)
ASSET_CATEGORY_SEGMENT4	VARCHAR2	(30)
ASSET_CATEGORY_SEGMENT5	VARCHAR2	(30)
ASSET_CATEGORY_SEGMENT6	VARCHAR2	(30)
ASSET_CATEGORY_SEGMENT7	VARCHAR2	(30)
ASSET_CATEGORY_ID	NUMBER
ASSET_LOCATION_SEGMENT1	VARCHAR2	(30)
ASSET_LOCATION_SEGMENT2	VARCHAR2	(30)
ASSET_LOCATION_SEGMENT3	VARCHAR2	(30)
ASSET_LOCATION_SEGMENT4	VARCHAR2	(30)
ASSET_LOCATION_SEGMENT5	VARCHAR2	(30)
ASSET_LOCATION_SEGMENT6	VARCHAR2	(30)
ASSET_LOCATION_SEGMENT7	VARCHAR2	(30)
ASSET_LOCATION_ID	NUMBER
DEPRECIATION_METHOD_ID	NUMBER
DEPRECIATION_METHOD_CODE	VARCHAR2	(12)
LIFE_IN_MONTHS	NUMBER
DEPRECIATION_RATE	NUMBER
SALVAGE_VALUE	NUMBER
SALVAGE_VALUE_PERCENT	NUMBER
SALES_TAX_EXEMPT_FLAG	VARCHAR2	(1)
SALES_TAX_EXEMPT_CERT_NUMBER	VARCHAR2	(50)
SALES_TAX_OVERRIDE_FLAG	VARCHAR2	(1)
SALES_TAX_OVERRIDE_RATE	NUMBER
VAT_TAX_EXEMPT	VARCHAR2	(1)
VAT_TAX_EXEMPT_CERT_NUMBER	VARCHAR2	(50)
VAT_TAX_OVERRIDE_FLAG	VARCHAR2	(1)
VAT_TAX_OVERRIDE_RATE	NUMBER
LIEN_TYPE	VARCHAR2	(30)
LIEN_FILING_NUMBER	VARCHAR2	(50)
LIEN_FILING_DATE	DATE
LIEN_FILING_STATUS	VARCHAR2	(30)
LIENHOLDER_ID	NUMBER
LIENHOLDER_NUMBER	VARCHAR2	(360)
FILING_JURISDICTION	VARCHAR2	(50)
FILING_SUB_JURISDICTION	VARCHAR2	(50)
LIEN_EXPIRATION_DATE	DATE
LIEN_CONTINUATION_NUMBER	VARCHAR2	(50)
LIEN_CONTINUATION_DATE	DATE
TITLE_TYPE	VARCHAR2	(30)
TITLE_ISSUER_NUMBER	VARCHAR2	(60)
TITLE_ISSUER_ID	NUMBER
TITLE_DATE	DATE
TITLE_NUMBER	VARCHAR2	(50)
REGISTRATION_NUMBER	VARCHAR2	(150)
ASSET_REGISTRATION_LOC_NAME	VARCHAR2	(50)
TITLE_CUSTODIAN_NAME	VARCHAR2	(30)
PAYEE_SITE_NAME	VARCHAR2	(240)
SERIAL_NUMBER	VARCHAR2	(100)
VENDOR_INVOICE_NUMBER	VARCHAR2	(30)
VENDOR_INVOICE_DATE	DATE
SHIP_TO_SITE_NUMBER	VARCHAR2	(240)
SHIP_TO_SITE_ID	NUMBER
START_DATE	DATE
END_DATE	DATE
PASSTHROUGH_PERCENT	NUMBER
PASSTHROUGH_BASIS_CODE	VARCHAR2	(30)
FEE_CODE	VARCHAR2	(150)
USAGE_ITEM_NAME	VARCHAR2	(1000)
USAGE_ITEM_ID	NUMBER
PRICE_LIST_NAME	VARCHAR2	(240)
PRICE_LIST_ID	NUMBER
COUNTER_GROUP_NAME	VARCHAR2	(30)
COUNTER_GROUP_ID	NUMBER
USAGE_BILL_FREQUENCY_CODE	VARCHAR2	(30)
MINIMUM_QTY_USAGE	NUMBER
DEFAULT_QTY_USAGE	NUMBER
AMCV_FLAG	VARCHAR2	(1)
LEVEL_FLAG	VARCHAR2	(1)
BASE_READING	NUMBER
BASE_READING_UOM_CODE	VARCHAR2	(3)
REAL_EST_INIT_DIRECT_COST	NUMBER
REAL_EST_OCCUPANCY	NUMBER
REAL_EST_DATE_LAST_INSP	DATE
REAL_EST_DATE_NEXT_INSP	DATE
REAL_EST_WTD_AVG_LIFE	NUMBER
REAL_EST_BOND_EQ_YIELD	NUMBER
REAL_EST_REFINANCE_AMT	NUMBER
REAL_EST_CREDIT_TENANT_FLAG	VARCHAR2	(1)
REAL_EST_PROPERTY_CLASS_CODE	VARCHAR2	(30)
REAL_EST_COVERAGE_RATIO	NUMBER
REAL_EST_NET_CASH_FLOW	NUMBER
REAL_EST_FUNDING_CATG_CODE	VARCHAR2	(30)
REAL_EST_APPRAISAL_FLAG	VARCHAR2	(1)
REAL_EST_APPRAISAL_DATE	DATE
REAL_EST_APPRAISAL_VALUE	NUMBER
REAL_EST_CONCEPT_TYPE_CODE	VARCHAR2	(30)
REAL_EST_DEAL_TYPE_CODE	VARCHAR2	(30)
REAL_EST_GROSS_FOOTAGE	NUMBER
REAL_EST_NET_FOOTAGE_RENTABLE	NUMBER
REAL_EST_LETTER_ACCEPT_DATE	DATE
REAL_EST_ACCEPT_EXPIRE_DATE	DATE
CAPITALIZED_INTEREST	NUMBER
TAX_COST	NUMBER
TAX_BOOK	VARCHAR2	(15)
LIFE_IN_MONTHS_TAX	NUMBER
DEPRN_METHOD_TAX	VARCHAR2	(12)
DEPRN_RATE_TAX	NUMBER
PAYMENT_TERM	VARCHAR2	(50)
PAYMENT_TERM_ID	NUMBER
VENDOR_PAYSITE_ID	NUMBER
VENDOR_PAYSITE_NAME	VARCHAR2	(15)
VENDOR_PAYMENT_METHOD	VARCHAR2	(30)
FEE_EXP_NO_OF_PERIODS	NUMBER
FEE_EXP_FREQUENCY	VARCHAR2	(80)
FEE_EXP_AMOUNT_PER_PERIOD	NUMBER
PROP_TAX_APPLICABLE	VARCHAR2	(3)
PROP_TAX_LEASE_REP	VARCHAR2	(3)
FRENCH_TAX_CODE	VARCHAR2	(30)
FRENCH_TAX_NAME	VARCHAR2	(150)
USAGE_TYPE_CODE	VARCHAR2	(30)
FIXED_USAGE_QUANTITY	NUMBER
INITIAL_DIRECT_COST	NUMBER
IN_SERVICE_DATE	DATE
LINK_ASSET_AMOUNT	NUMBER
FEE_TYPE	VARCHAR2	(30)
DEPRECIATION_COST	NUMBER
USAGE_PERIOD	VARCHAR2	(3)
USAGE_NO_OF_PERIOD	NUMBER
ASSET_KEY_ID	NUMBER
ASSET_KEY_SEGMENT1	VARCHAR2	(30)
ASSET_KEY_SEGMENT2	VARCHAR2	(30)
ASSET_KEY_SEGMENT3	VARCHAR2	(30)
ASSET_KEY_SEGMENT4	VARCHAR2	(30)
ASSET_KEY_SEGMENT5	VARCHAR2	(30)
ASSET_KEY_SEGMENT6	VARCHAR2	(30)
ASSET_KEY_SEGMENT7	VARCHAR2	(30)
ASSET_KEY_SEGMENT8	VARCHAR2	(30)
ASSET_KEY_SEGMENT9	VARCHAR2	(30)
ASSET_KEY_SEGMENT10	VARCHAR2	(30)
TERMINATION_QUOTE_ID	NUMBER
TERMINATION_QUOTE_NUMBER	NUMBER
PROP_TAX_BILL_METHOD	VARCHAR2	(35)
PROP_TAX_AS_CONTRACT_YN	VARCHAR2	(1)
STREAM_PURPOSE_CODE	VARCHAR2	(35)
EXPLICIT_NEW_LINE_FLAG	VARCHAR2	(1)
SUBSIDY_ID	NUMBER
SUBSIDY_NAME	VARCHAR2	(30)
SUBSIDY_OVERRIDE_AMOUNT	NUMBER
SUBSIDY_PARTY_ID	NUMBER
SUBSIDY_PARTY_NAME	VARCHAR2	(240)
SUBSIDY_REFND_PAYSITE_ID	NUMBER
SUBSIDY_REFND_PAYSITE_CODE	VARCHAR2	(15)
SUBSIDY_REFND_PAYTERM_ID	NUMBER
SUBSIDY_REFND_PAYTERM_NAME	VARCHAR2	(50)
SUBSIDY_REFND_PAYMETHOD_CODE	VARCHAR2	(30)
SUBSIDY_REFND_PAYGROUP_CODE	VARCHAR2	(30)
PTH_BASE_PAYOUT_BASIS	VARCHAR2	(30)
PTH_BASE_STREAM_CODE	VARCHAR2	(150)
PTH_BASE_STREAM_PURPOSE_CODE	VARCHAR2	(30)
PTH_START_DATE	DATE
PTH_EVG_PAYOUT_BASIS	VARCHAR2	(30)
PTH_PAYOUT_BASIS_FORMULA	VARCHAR2	(150)
PTH_EVG_STREAM_CODE	VARCHAR2	(150)
PTH_EVG_STREAM_PURPOSE_CODE	VARCHAR2	(30)
ST_UPDATE_LINES_FROM_CONTRACT	VARCHAR2	(1)
ST_TRANSFER_OF_TITLE	VARCHAR2	(1)
ST_SALE_AND_LEASE_BACK	VARCHAR2	(1)
ST_PURCHASE_OF_LEASE	VARCHAR2	(1)
ST_EQUIPMENT_USAGE	VARCHAR2	(30)
ST_EQUIPMENT_AGE	NUMBER
FEE_PURPOSE_CODE	VARCHAR2	(30)
ST_ASSET_UPFRONT_TAX	VARCHAR2	(30)
ATTRIBUTE_CATEGORY	VARCHAR2	(150)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
DOWN_PAYMENT_RECEIVER_CODE	VARCHAR2	(30)
CAPITALIZE_DOWN_PAYMENT_YN	VARCHAR2	(3)
DATE_FUNDING_EXPECTED	DATE
ORIGINATION_INCOME	NUMBER
AMOUNT_BALANCE_LEGACY	NUMBER
DT_EFFECTIVE_BALANCE_LEGACY	DATE

Query Text

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


SELECT CONTRACT_NUMBER_OLD
,      LINE_NUMBER
,      LINE_TYPE
,      ASSET_NUMBER
,      LINK_ASSET_NUMBER
,      ORIGINAL_COST
,      TOTAL_UNITS
,      AMOUNT
,      STATUS
,      DATE_APPROVED
,      DATE_SIGNED
,      CURRENCY_CODE
,      INVENTORY_ORGANIZATION_NAME
,      INVENTORY_ORGANIZATION_ID
,      INVENTORY_ITEM_NAME
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      MODEL
,      MAKE
,      YEAR_OF_MANUFACTURE
,      INSTALL_SITE_NUMBER
,      INSTALL_SITE_ID
,      RESIDUAL_PERCENT
,      RESIDUAL_AMOUNT
,      RESIDUAL_AMOUNT_GUARANTEE
,      RESIDUAL_AMOUNT_GUARANTEE_PV
,      GUARANTOR_TYPE_CODE
,      TRADE_IN_AMOUNT
,      CAPITAL_REDUCTION_PERCENT
,      CAPITAL_REDUCTION_AMOUNT
,      INTERIM_INT_CAPITALIZED_AMT
,      ASSET_CORPORATE_BOOK
,      ASSET_CATEGORY_SEGMENT1
,      ASSET_CATEGORY_SEGMENT2
,      ASSET_CATEGORY_SEGMENT3
,      ASSET_CATEGORY_SEGMENT4
,      ASSET_CATEGORY_SEGMENT5
,      ASSET_CATEGORY_SEGMENT6
,      ASSET_CATEGORY_SEGMENT7
,      ASSET_CATEGORY_ID
,      ASSET_LOCATION_SEGMENT1
,      ASSET_LOCATION_SEGMENT2
,      ASSET_LOCATION_SEGMENT3
,      ASSET_LOCATION_SEGMENT4
,      ASSET_LOCATION_SEGMENT5
,      ASSET_LOCATION_SEGMENT6
,      ASSET_LOCATION_SEGMENT7
,      ASSET_LOCATION_ID
,      DEPRECIATION_METHOD_ID
,      DEPRECIATION_METHOD_CODE
,      LIFE_IN_MONTHS
,      DEPRECIATION_RATE
,      SALVAGE_VALUE
,      SALVAGE_VALUE_PERCENT
,      SALES_TAX_EXEMPT_FLAG
,      SALES_TAX_EXEMPT_CERT_NUMBER
,      SALES_TAX_OVERRIDE_FLAG
,      SALES_TAX_OVERRIDE_RATE
,      VAT_TAX_EXEMPT
,      VAT_TAX_EXEMPT_CERT_NUMBER
,      VAT_TAX_OVERRIDE_FLAG
,      VAT_TAX_OVERRIDE_RATE
,      LIEN_TYPE
,      LIEN_FILING_NUMBER
,      LIEN_FILING_DATE
,      LIEN_FILING_STATUS
,      LIENHOLDER_ID
,      LIENHOLDER_NUMBER
,      FILING_JURISDICTION
,      FILING_SUB_JURISDICTION
,      LIEN_EXPIRATION_DATE
,      LIEN_CONTINUATION_NUMBER
,      LIEN_CONTINUATION_DATE
,      TITLE_TYPE
,      TITLE_ISSUER_NUMBER
,      TITLE_ISSUER_ID
,      TITLE_DATE
,      TITLE_NUMBER
,      REGISTRATION_NUMBER
,      ASSET_REGISTRATION_LOC_NAME
,      TITLE_CUSTODIAN_NAME
,      PAYEE_SITE_NAME
,      SERIAL_NUMBER
,      VENDOR_INVOICE_NUMBER
,      VENDOR_INVOICE_DATE
,      SHIP_TO_SITE_NUMBER
,      SHIP_TO_SITE_ID
,      START_DATE
,      END_DATE
,      PASSTHROUGH_PERCENT
,      PASSTHROUGH_BASIS_CODE
,      FEE_CODE
,      USAGE_ITEM_NAME
,      USAGE_ITEM_ID
,      PRICE_LIST_NAME
,      PRICE_LIST_ID
,      COUNTER_GROUP_NAME
,      COUNTER_GROUP_ID
,      USAGE_BILL_FREQUENCY_CODE
,      MINIMUM_QTY_USAGE
,      DEFAULT_QTY_USAGE
,      AMCV_FLAG
,      LEVEL_FLAG
,      BASE_READING
,      BASE_READING_UOM_CODE
,      REAL_EST_INIT_DIRECT_COST
,      REAL_EST_OCCUPANCY
,      REAL_EST_DATE_LAST_INSP
,      REAL_EST_DATE_NEXT_INSP
,      REAL_EST_WTD_AVG_LIFE
,      REAL_EST_BOND_EQ_YIELD
,      REAL_EST_REFINANCE_AMT
,      REAL_EST_CREDIT_TENANT_FLAG
,      REAL_EST_PROPERTY_CLASS_CODE
,      REAL_EST_COVERAGE_RATIO
,      REAL_EST_NET_CASH_FLOW
,      REAL_EST_FUNDING_CATG_CODE
,      REAL_EST_APPRAISAL_FLAG
,      REAL_EST_APPRAISAL_DATE
,      REAL_EST_APPRAISAL_VALUE
,      REAL_EST_CONCEPT_TYPE_CODE
,      REAL_EST_DEAL_TYPE_CODE
,      REAL_EST_GROSS_FOOTAGE
,      REAL_EST_NET_FOOTAGE_RENTABLE
,      REAL_EST_LETTER_ACCEPT_DATE
,      REAL_EST_ACCEPT_EXPIRE_DATE
,      CAPITALIZED_INTEREST
,      TAX_COST
,      TAX_BOOK
,      LIFE_IN_MONTHS_TAX
,      DEPRN_METHOD_TAX
,      DEPRN_RATE_TAX
,      PAYMENT_TERM
,      PAYMENT_TERM_ID
,      VENDOR_PAYSITE_ID
,      VENDOR_PAYSITE_NAME
,      VENDOR_PAYMENT_METHOD
,      FEE_EXP_NO_OF_PERIODS
,      FEE_EXP_FREQUENCY
,      FEE_EXP_AMOUNT_PER_PERIOD
,      PROP_TAX_APPLICABLE
,      PROP_TAX_LEASE_REP
,      FRENCH_TAX_CODE
,      FRENCH_TAX_NAME
,      USAGE_TYPE_CODE
,      FIXED_USAGE_QUANTITY
,      INITIAL_DIRECT_COST
,      IN_SERVICE_DATE
,      LINK_ASSET_AMOUNT
,      FEE_TYPE
,      DEPRECIATION_COST
,      USAGE_PERIOD
,      USAGE_NO_OF_PERIOD
,      ASSET_KEY_ID
,      ASSET_KEY_SEGMENT1
,      ASSET_KEY_SEGMENT2
,      ASSET_KEY_SEGMENT3
,      ASSET_KEY_SEGMENT4
,      ASSET_KEY_SEGMENT5
,      ASSET_KEY_SEGMENT6
,      ASSET_KEY_SEGMENT7
,      ASSET_KEY_SEGMENT8
,      ASSET_KEY_SEGMENT9
,      ASSET_KEY_SEGMENT10
,      TERMINATION_QUOTE_ID
,      TERMINATION_QUOTE_NUMBER
,      PROP_TAX_BILL_METHOD
,      PROP_TAX_AS_CONTRACT_YN
,      STREAM_PURPOSE_CODE
,      EXPLICIT_NEW_LINE_FLAG
,      SUBSIDY_ID
,      SUBSIDY_NAME
,      SUBSIDY_OVERRIDE_AMOUNT
,      SUBSIDY_PARTY_ID
,      SUBSIDY_PARTY_NAME
,      SUBSIDY_REFND_PAYSITE_ID
,      SUBSIDY_REFND_PAYSITE_CODE
,      SUBSIDY_REFND_PAYTERM_ID
,      SUBSIDY_REFND_PAYTERM_NAME
,      SUBSIDY_REFND_PAYMETHOD_CODE
,      SUBSIDY_REFND_PAYGROUP_CODE
,      PTH_BASE_PAYOUT_BASIS
,      PTH_BASE_STREAM_CODE
,      PTH_BASE_STREAM_PURPOSE_CODE
,      PTH_START_DATE
,      PTH_EVG_PAYOUT_BASIS
,      PTH_PAYOUT_BASIS_FORMULA
,      PTH_EVG_STREAM_CODE
,      PTH_EVG_STREAM_PURPOSE_CODE
,      ST_UPDATE_LINES_FROM_CONTRACT
,      ST_TRANSFER_OF_TITLE
,      ST_SALE_AND_LEASE_BACK
,      ST_PURCHASE_OF_LEASE
,      ST_EQUIPMENT_USAGE
,      ST_EQUIPMENT_AGE
,      FEE_PURPOSE_CODE
,      ST_ASSET_UPFRONT_TAX
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DOWN_PAYMENT_RECEIVER_CODE
,      CAPITALIZE_DOWN_PAYMENT_YN
,      DATE_FUNDING_EXPECTED
,      ORIGINATION_INCOME
,      AMOUNT_BALANCE_LEGACY
,      DT_EFFECTIVE_BALANCE_LEGACY
FROM OKL.OKL_LINES_INTERFACE#;

Dependencies

[top of page]

OKL.OKL_LINES_INTERFACE# references the following:

OKL: OKL_LINES_INTERFACE

OKL.OKL_LINES_INTERFACE# is referenced by following:

APPS: OKL_LINES_INTERFACE