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: APPS.OKL_SIF_FEES_V

Object Details

Object Name:	OKL_SIF_FEES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_SIF_FEES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This is an interface table which holds details about fees like fee type, fee amount, payment date etc.
This is a denormalized table which holds details of fee header and payment levels. This information
is used for external pricing. References to contract lines, stream Interface headers and stream
interface lines are also stored here.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Auto-generated by Headstart Utilities
ID	NUMBER		Yes	Primary key column
SFE_TYPE	VARCHAR2	(10)	Yes	Lookup code for the fee type. Valid values are SFO, SFP, SFR, SFI and SFN.
DATE_START	DATE			First due date for a recurring fee
DATE_PAID	DATE			assume start date
AMOUNT	NUMBER			Amount
IDC_ACCOUNTING_FLAG	VARCHAR2	(10)		From fee type set up
INCOME_OR_EXPENSE	VARCHAR2	(10)	Yes	Always send income
DESCRIPTION	VARCHAR2	(1995)		User entered description
FEE_INDEX_NUMBER	NUMBER		Yes	Index to determine relationship with Asset
LEVEL_INDEX_NUMBER	NUMBER	(3)		Sequence number for the payment level.
ADVANCE_OR_ARREARS	VARCHAR2	(10)	Yes	Should be one setting for the contract
LEVEL_TYPE	VARCHAR2	(30)		Payment level type.
LOCK_LEVEL_STEP	VARCHAR2	(10)		Whether modifications are allowed for the payment level for pricing.
PERIOD	VARCHAR2	(30)		Frequency of the payment.
NUMBER_OF_PERIODS	NUMBER	(6)		Number of payments for a payment level.
LEVEL_LINE_NUMBER	NUMBER	(5)		Reference to the fee index number
SIF_ID	NUMBER			Foreign key to table OKL_STREAM_INTERFACES
KLE_ID	NUMBER			Foreign key to table OKL_K_LINES
SIL_ID	NUMBER			Foreign key to table OKL_SIF_LINES
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
RATE	NUMBER	(18)		Rate for the payment level.
STRUCTURE	VARCHAR2	(200)		Structure of the payment level.
DAYS_IN_PERIOD	NUMBER			Number of days in a payment period.
QUERY_LEVEL_YN	VARCHAR2	(10)		Whether to query the payment level in the results from pricing engine.
CASH_EFFECT_YN	VARCHAR2	(3)		Cash effect YN flag
TAX_EFFECT_YN	VARCHAR2	(3)		Tax effect YN flag
STREAM_INTERFACE_ATTRIBUTE01	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE02	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE03	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE04	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE05	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE06	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE07	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE08	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE09	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE10	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE11	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE12	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE13	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE14	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE15	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE16	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE17	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE18	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE19	VARCHAR2	(450)		Generic attribute for extensions.
STREAM_INTERFACE_ATTRIBUTE20	VARCHAR2	(450)		Generic attribute for extensions.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
DAYS_IN_MONTH	VARCHAR2	(30)		Day Convention for Days In a Month
DAYS_IN_YEAR	VARCHAR2	(240)		Day Convention for Days In a Year
BALANCE_TYPE_CODE	VARCHAR2	(30)		This field is used to indicate if the paydown is for Solve for Payment or Solve for Term. The field will have the values 'PAYMENT' or 'TERM'
DOWN_PAYMENT_AMOUNT	NUMBER			This column indicates the down payment amount made on an asset line
ORIG_CONTRACT_LINE_ID	NUMBER			Foreign key to table okc_k_lines_b

Query Text

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


SELECT ROW_ID
,      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
,      OBJECT_VERSION_NUMBER
,      RATE
,      STRUCTURE
,      DAYS_IN_PERIOD
,      QUERY_LEVEL_YN
,      CASH_EFFECT_YN
,      TAX_EFFECT_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
,      DAYS_IN_MONTH
,      DAYS_IN_YEAR
,      BALANCE_TYPE_CODE
,      DOWN_PAYMENT_AMOUNT
,      ORIG_CONTRACT_LINE_ID
FROM APPS.OKL_SIF_FEES_V;

Dependencies

[top of page]

APPS.OKL_SIF_FEES_V references the following:

APPS: OKL_SIF_FEES

APPS.OKL_SIF_FEES_V is referenced by following:

APPS: OKL_AM_RESTRUCTURE_RENTS_PVT - show dependent code; OKL_CREATE_STREAMS_PVT - show dependent code; OKL_LA_STREAM_PVT - show dependent code; OKL_SFE_PVT - show dependent code; OKL_SFE_PVT - show dependent code; OKL_SIT_PVT - show dependent code; OKL_ST_CODE_CONVERSIONS - show dependent code