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

VIEW: OKL.OKL_SIF_LINES#

Object Details
Object Name: OKL_SIF_LINES#
Object Type: VIEW
Owner: OKL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
STATE_DEPRE_DMNSHING_VALUE_RT NUMBER (5)
BOOK_DEPRE_DMNSHING_VALUE_RT NUMBER (5)
RESIDUAL_GUARANTEE_METHOD VARCHAR2 (30)
FED_DEPRE_TERM NUMBER (4)
FED_DEPRE_DMNSHING_VALUE_RATE NUMBER (5)
FED_DEPRE_ADR_CONVE VARCHAR2 (80)
STATE_DEPRE_BASIS_PERCENT NUMBER

STATE_DEPRE_METHOD VARCHAR2 (80)
PURCHASE_OPTION VARCHAR2 (30)
ASSET_COST NUMBER (14)
STATE_DEPRE_TERM NUMBER (4)
STATE_DEPRE_ADR_CONVENT VARCHAR2 (80)
FED_DEPRE_METHOD VARCHAR2 (80)
RESIDUAL_AMOUNT NUMBER (14)
FED_DEPRE_SALVAGE NUMBER

DATE_FED_DEPRE DATE

BOOK_SALVAGE NUMBER

BOOK_ADR_CONVENTION VARCHAR2 (80)
STATE_DEPRE_SALVAGE NUMBER

FED_DEPRE_BASIS_PERCENT NUMBER

BOOK_BASIS_PERCENT NUMBER

DATE_DELIVERY DATE

BOOK_TERM NUMBER (4)
RESIDUAL_GUARANTEE_AMOUNT NUMBER (14)
DATE_FUNDING DATE

DATE_BOOK DATE

DATE_STATE_DEPRE DATE

BOOK_METHOD VARCHAR2 (80)
INDEX_NUMBER NUMBER
Yes
DESCRIPTION VARCHAR2 (1995)
DATE_START DATE

DATE_LENDING DATE

PURCHASE_OPTION_AMOUNT NUMBER (14)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
SIF_ID NUMBER
Yes
KLE_ID NUMBER
Yes
SIL_TYPE VARCHAR2 (10) Yes
RESIDUAL_GUARANTEE_TYPE VARCHAR2 (200)
STREAM_INTERFACE_ATTRIBUTE01 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE02 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE03 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE04 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE05 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE06 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE07 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE08 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE09 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE10 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE11 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE12 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE13 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE14 VARCHAR2 (450)
STREAM_INTERFACE_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)
RESIDUAL_DATE DATE

DOWN_PAYMENT_AMOUNT NUMBER

CAPITALIZE_DOWN_PAYMENT_YN VARCHAR2 (30)
ORIG_CONTRACT_LINE_ID NUMBER

Query Text

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


SELECT ID
,      STATE_DEPRE_DMNSHING_VALUE_RT
,      BOOK_DEPRE_DMNSHING_VALUE_RT
,      RESIDUAL_GUARANTEE_METHOD
,      FED_DEPRE_TERM
,      FED_DEPRE_DMNSHING_VALUE_RATE
,      FED_DEPRE_ADR_CONVE
,      STATE_DEPRE_BASIS_PERCENT
,      STATE_DEPRE_METHOD
,      PURCHASE_OPTION
,      ASSET_COST
,      STATE_DEPRE_TERM
,      STATE_DEPRE_ADR_CONVENT
,      FED_DEPRE_METHOD
,      RESIDUAL_AMOUNT
,      FED_DEPRE_SALVAGE
,      DATE_FED_DEPRE
,      BOOK_SALVAGE
,      BOOK_ADR_CONVENTION
,      STATE_DEPRE_SALVAGE
,      FED_DEPRE_BASIS_PERCENT
,      BOOK_BASIS_PERCENT
,      DATE_DELIVERY
,      BOOK_TERM
,      RESIDUAL_GUARANTEE_AMOUNT
,      DATE_FUNDING
,      DATE_BOOK
,      DATE_STATE_DEPRE
,      BOOK_METHOD
,      INDEX_NUMBER
,      DESCRIPTION
,      DATE_START
,      DATE_LENDING
,      PURCHASE_OPTION_AMOUNT
,      OBJECT_VERSION_NUMBER
,      SIF_ID
,      KLE_ID
,      SIL_TYPE
,      RESIDUAL_GUARANTEE_TYPE
,      STREAM_INTERFACE_ATTRIBUTE01
,      STREAM_INTERFACE_ATTRIBUTE02
,      STREAM_INTERFACE_ATTRIBUTE03
,      STREAM_INTERFACE_ATTRIBUTE04
,      STREAM_INTERFACE_ATTRIBUTE05
,      STREAM_INTERFACE_ATTRIBUTE06
,      STREAM_INTERFACE_ATTRIBUTE07
,      STREAM_INTERFACE_ATTRIBUTE08
,      STREAM_INTERFACE_ATTRIBUTE09
,      STREAM_INTERFACE_ATTRIBUTE10
,      STREAM_INTERFACE_ATTRIBUTE11
,      STREAM_INTERFACE_ATTRIBUTE12
,      STREAM_INTERFACE_ATTRIBUTE13
,      STREAM_INTERFACE_ATTRIBUTE14
,      STREAM_INTERFACE_ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESIDUAL_DATE
,      DOWN_PAYMENT_AMOUNT
,      CAPITALIZE_DOWN_PAYMENT_YN
,      ORIG_CONTRACT_LINE_ID
FROM OKL.OKL_SIF_LINES#;

Dependencies

[top of page]

OKL.OKL_SIF_LINES# references the following:

SchemaOKL
TableOKL_SIF_LINES
OKL.OKL_SIF_LINES# is referenced by following:

SchemaAPPS
SynonymOKL_SIF_LINES