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

VIEW: OKL.OKL_SIF_FEES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
SFE_TYPE VARCHAR2 (10) Yes
DATE_START DATE

DATE_PAID DATE

AMOUNT NUMBER

IDC_ACCOUNTING_FLAG VARCHAR2 (10)
INCOME_OR_EXPENSE VARCHAR2 (10) Yes
DESCRIPTION VARCHAR2 (1995)
FEE_INDEX_NUMBER NUMBER
Yes
LEVEL_INDEX_NUMBER NUMBER (3)
ADVANCE_OR_ARREARS VARCHAR2 (10) Yes
LEVEL_TYPE VARCHAR2 (30)
LOCK_LEVEL_STEP VARCHAR2 (10)
PERIOD VARCHAR2 (30)
NUMBER_OF_PERIODS NUMBER (6)
LEVEL_LINE_NUMBER NUMBER (5)
SIF_ID NUMBER

KLE_ID NUMBER

SIL_ID NUMBER

RATE NUMBER (18)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
STRUCTURE VARCHAR2 (200)
DAYS_IN_PERIOD NUMBER

QUERY_LEVEL_YN VARCHAR2 (10)
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)
STREAM_INTERFACE_ATTRIBUTE16 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE17 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE18 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE19 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE20 VARCHAR2 (450)
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CASH_EFFECT_YN VARCHAR2 (3)
TAX_EFFECT_YN VARCHAR2 (3)
DAYS_IN_MONTH VARCHAR2 (30)
DAYS_IN_YEAR VARCHAR2 (240)
BALANCE_TYPE_CODE VARCHAR2 (30)
DOWN_PAYMENT_AMOUNT NUMBER

ORIG_CONTRACT_LINE_ID NUMBER

Query Text

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


SELECT ID
,      SFE_TYPE
,      DATE_START
,      DATE_PAID
,      AMOUNT
,      IDC_ACCOUNTING_FLAG
,      INCOME_OR_EXPENSE
,      DESCRIPTION
,      FEE_INDEX_NUMBER
,      LEVEL_INDEX_NUMBER
,      ADVANCE_OR_ARREARS
,      LEVEL_TYPE
,      LOCK_LEVEL_STEP
,      PERIOD
,      NUMBER_OF_PERIODS
,      LEVEL_LINE_NUMBER
,      SIF_ID
,      KLE_ID
,      SIL_ID
,      RATE
,      OBJECT_VERSION_NUMBER
,      STRUCTURE
,      DAYS_IN_PERIOD
,      QUERY_LEVEL_YN
,      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
,      STREAM_INTERFACE_ATTRIBUTE16
,      STREAM_INTERFACE_ATTRIBUTE17
,      STREAM_INTERFACE_ATTRIBUTE18
,      STREAM_INTERFACE_ATTRIBUTE19
,      STREAM_INTERFACE_ATTRIBUTE20
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CASH_EFFECT_YN
,      TAX_EFFECT_YN
,      DAYS_IN_MONTH
,      DAYS_IN_YEAR
,      BALANCE_TYPE_CODE
,      DOWN_PAYMENT_AMOUNT
,      ORIG_CONTRACT_LINE_ID
FROM OKL.OKL_SIF_FEES#;

Dependencies

[top of page]

OKL.OKL_SIF_FEES# references the following:

SchemaOKL
TableOKL_SIF_FEES
OKL.OKL_SIF_FEES# is referenced by following:

SchemaAPPS
SynonymOKL_SIF_FEES