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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ID	NUMBER		Yes
KLE_ID	NUMBER
STY_ID	NUMBER
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes
LAO_AMOUNT	NUMBER	(14)
FEE_CHARGE	NUMBER	(14)
TITLE_DATE	DATE
DATE_RESIDUAL_LAST_REVIEW	DATE
DATE_LAST_REAMORTISATION	DATE
TERMINATION_PURCHASE_AMOUNT	NUMBER	(14)
DATE_LAST_CLEANUP	DATE
REMARKETED_AMOUNT	NUMBER	(14)
DATE_REMARKETED	DATE
REMARKET_MARGIN	NUMBER
REPURCHASED_AMOUNT	NUMBER	(14)
DATE_REPURCHASED	DATE
GAIN_LOSS	NUMBER	(4)
FLOOR_AMOUNT	NUMBER	(14)
PREVIOUS_CONTRACT	VARCHAR2	(40)
TRACKED_RESIDUAL	NUMBER	(14)
DATE_TITLE_RECEIVED	DATE
ESTIMATED_OEC	NUMBER	(14)
RESIDUAL_PERCENTAGE	NUMBER	(5)
CAPITAL_REDUCTION	NUMBER
VENDOR_ADVANCE_PAID	NUMBER	(14)
TRADEIN_AMOUNT	NUMBER
DELIVERED_DATE	DATE
YEAR_OF_MANUFACTURE	VARCHAR2	(240)
INITIAL_DIRECT_COST	NUMBER	(14)
OCCUPANCY	NUMBER	(20)
DATE_LAST_INSPECTION	DATE
DATE_NEXT_INSPECTION_DUE	DATE
WEIGHTED_AVERAGE_LIFE	NUMBER	(30)
BOND_EQUIVALENT_YIELD	NUMBER	(5)
REFINANCE_AMOUNT	NUMBER	(14)
YEAR_BUILT	NUMBER	(4)
COVERAGE_RATIO	NUMBER	(5)
GROSS_SQUARE_FOOTAGE	NUMBER	(30)
NET_RENTABLE	NUMBER	(14)
DATE_LETTER_ACCEPTANCE	DATE
DATE_COMMITMENT_EXPIRATION	DATE
DATE_APPRAISAL	DATE
APPRAISAL_VALUE	NUMBER	(14)
RESIDUAL_VALUE	NUMBER	(20)
PERCENT	NUMBER	(5)
COVERAGE	NUMBER	(14)
LRV_AMOUNT	NUMBER	(14)
AMOUNT	NUMBER
LRS_PERCENT	NUMBER	(5)
EVERGREEN_PERCENT	NUMBER	(5)
PERCENT_STAKE	NUMBER	(5)
AMOUNT_STAKE	NUMBER	(14)
DATE_SOLD	DATE
STY_ID_FOR	NUMBER	(10)
ATTRIBUTE_CATEGORY	VARCHAR2	(90)
ATTRIBUTE1	VARCHAR2	(450)
ATTRIBUTE2	VARCHAR2	(450)
ATTRIBUTE3	VARCHAR2	(450)
ATTRIBUTE4	VARCHAR2	(450)
ATTRIBUTE5	VARCHAR2	(450)
ATTRIBUTE6	VARCHAR2	(450)
ATTRIBUTE7	VARCHAR2	(450)
ATTRIBUTE8	VARCHAR2	(450)
ATTRIBUTE9	VARCHAR2	(450)
ATTRIBUTE10	VARCHAR2	(450)
ATTRIBUTE11	VARCHAR2	(450)
ATTRIBUTE12	VARCHAR2	(450)
ATTRIBUTE13	VARCHAR2	(450)
ATTRIBUTE14	VARCHAR2	(450)
ATTRIBUTE15	VARCHAR2	(450)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
NTY_CODE	VARCHAR2	(30)
FCG_CODE	VARCHAR2	(30)
PRC_CODE	VARCHAR2	(30)
RE_LEASE_YN	VARCHAR2	(3)
PRESCRIBED_ASSET_YN	VARCHAR2	(3)
CREDIT_TENANT_YN	VARCHAR2	(3)
SECURED_DEAL_YN	VARCHAR2	(3)
CLG_ID	NUMBER
DATE_FUNDING	DATE
DATE_FUNDING_REQUIRED	DATE
DATE_ACCEPTED	DATE
DATE_DELIVERY_EXPECTED	DATE
OEC	NUMBER
CAPITAL_AMOUNT	NUMBER
RESIDUAL_GRNTY_AMOUNT	NUMBER	(14)
RESIDUAL_CODE	VARCHAR2	(30)
RVI_PREMIUM	NUMBER	(14)
CREDIT_NATURE	VARCHAR2	(30)
CAPITALIZED_INTEREST	NUMBER	(14)
CAPITAL_REDUCTION_PERCENT	NUMBER	(5)
DATE_PAY_INVESTOR_START	DATE
PAY_INVESTOR_FREQUENCY	VARCHAR2	(30)
PAY_INVESTOR_EVENT	VARCHAR2	(30)
PAY_INVESTOR_REMITTANCE_DAYS	NUMBER
FEE_TYPE	VARCHAR2	(30)
SUBSIDY_ID	NUMBER
SUBSIDY_OVERRIDE_AMOUNT	NUMBER
PRE_TAX_YIELD	NUMBER
AFTER_TAX_YIELD	NUMBER
IMPLICIT_INTEREST_RATE	NUMBER
IMPLICIT_NON_IDC_INTEREST_RATE	NUMBER
PRE_TAX_IRR	NUMBER
AFTER_TAX_IRR	NUMBER
SUB_PRE_TAX_YIELD	NUMBER
SUB_AFTER_TAX_YIELD	NUMBER
SUB_IMPL_INTEREST_RATE	NUMBER
SUB_IMPL_NON_IDC_INT_RATE	NUMBER
SUB_PRE_TAX_IRR	NUMBER
SUB_AFTER_TAX_IRR	NUMBER
ITEM_INSURANCE_CATEGORY	NUMBER
QTE_ID	NUMBER
FUNDING_DATE	DATE
STREAM_TYPE_SUBCLASS	VARCHAR2	(30)
DATE_FUNDING_EXPECTED	DATE
MANUFACTURER_NAME	VARCHAR2	(360)
MODEL_NUMBER	VARCHAR2	(40)
DOWN_PAYMENT_RECEIVER_CODE	VARCHAR2	(30)
CAPITALIZE_DOWN_PAYMENT_YN	VARCHAR2	(3)
FEE_PURPOSE_CODE	VARCHAR2	(30)
TERMINATION_VALUE	NUMBER
EXPECTED_ASSET_COST	NUMBER
ORIG_CONTRACT_LINE_ID	NUMBER
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 ID
,      KLE_ID
,      STY_ID
,      OBJECT_VERSION_NUMBER
,      LAO_AMOUNT
,      FEE_CHARGE
,      TITLE_DATE
,      DATE_RESIDUAL_LAST_REVIEW
,      DATE_LAST_REAMORTISATION
,      TERMINATION_PURCHASE_AMOUNT
,      DATE_LAST_CLEANUP
,      REMARKETED_AMOUNT
,      DATE_REMARKETED
,      REMARKET_MARGIN
,      REPURCHASED_AMOUNT
,      DATE_REPURCHASED
,      GAIN_LOSS
,      FLOOR_AMOUNT
,      PREVIOUS_CONTRACT
,      TRACKED_RESIDUAL
,      DATE_TITLE_RECEIVED
,      ESTIMATED_OEC
,      RESIDUAL_PERCENTAGE
,      CAPITAL_REDUCTION
,      VENDOR_ADVANCE_PAID
,      TRADEIN_AMOUNT
,      DELIVERED_DATE
,      YEAR_OF_MANUFACTURE
,      INITIAL_DIRECT_COST
,      OCCUPANCY
,      DATE_LAST_INSPECTION
,      DATE_NEXT_INSPECTION_DUE
,      WEIGHTED_AVERAGE_LIFE
,      BOND_EQUIVALENT_YIELD
,      REFINANCE_AMOUNT
,      YEAR_BUILT
,      COVERAGE_RATIO
,      GROSS_SQUARE_FOOTAGE
,      NET_RENTABLE
,      DATE_LETTER_ACCEPTANCE
,      DATE_COMMITMENT_EXPIRATION
,      DATE_APPRAISAL
,      APPRAISAL_VALUE
,      RESIDUAL_VALUE
,      PERCENT
,      COVERAGE
,      LRV_AMOUNT
,      AMOUNT
,      LRS_PERCENT
,      EVERGREEN_PERCENT
,      PERCENT_STAKE
,      AMOUNT_STAKE
,      DATE_SOLD
,      STY_ID_FOR
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NTY_CODE
,      FCG_CODE
,      PRC_CODE
,      RE_LEASE_YN
,      PRESCRIBED_ASSET_YN
,      CREDIT_TENANT_YN
,      SECURED_DEAL_YN
,      CLG_ID
,      DATE_FUNDING
,      DATE_FUNDING_REQUIRED
,      DATE_ACCEPTED
,      DATE_DELIVERY_EXPECTED
,      OEC
,      CAPITAL_AMOUNT
,      RESIDUAL_GRNTY_AMOUNT
,      RESIDUAL_CODE
,      RVI_PREMIUM
,      CREDIT_NATURE
,      CAPITALIZED_INTEREST
,      CAPITAL_REDUCTION_PERCENT
,      DATE_PAY_INVESTOR_START
,      PAY_INVESTOR_FREQUENCY
,      PAY_INVESTOR_EVENT
,      PAY_INVESTOR_REMITTANCE_DAYS
,      FEE_TYPE
,      SUBSIDY_ID
,      SUBSIDY_OVERRIDE_AMOUNT
,      PRE_TAX_YIELD
,      AFTER_TAX_YIELD
,      IMPLICIT_INTEREST_RATE
,      IMPLICIT_NON_IDC_INTEREST_RATE
,      PRE_TAX_IRR
,      AFTER_TAX_IRR
,      SUB_PRE_TAX_YIELD
,      SUB_AFTER_TAX_YIELD
,      SUB_IMPL_INTEREST_RATE
,      SUB_IMPL_NON_IDC_INT_RATE
,      SUB_PRE_TAX_IRR
,      SUB_AFTER_TAX_IRR
,      ITEM_INSURANCE_CATEGORY
,      QTE_ID
,      FUNDING_DATE
,      STREAM_TYPE_SUBCLASS
,      DATE_FUNDING_EXPECTED
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      DOWN_PAYMENT_RECEIVER_CODE
,      CAPITALIZE_DOWN_PAYMENT_YN
,      FEE_PURPOSE_CODE
,      TERMINATION_VALUE
,      EXPECTED_ASSET_COST
,      ORIG_CONTRACT_LINE_ID
,      ORIGINATION_INCOME
,      AMOUNT_BALANCE_LEGACY
,      DT_EFFECTIVE_BALANCE_LEGACY
FROM OKL.OKL_K_LINES#;

Dependencies

[top of page]

OKL.OKL_K_LINES# references the following:

OKL: OKL_K_LINES

OKL.OKL_K_LINES# is referenced by following:

APPS: OKL_K_LINES