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]

TABLE: LNS.LNS_FEES_ALL

Object Details

Object Name:	LNS_FEES_ALL
Object Type:	TABLE
Owner:	LNS
FND Design Data:	LNS.LNS_FEES_ALL
Subobject Name:
Status:	VALID

LNS_FEES is a setup table where loan fees are defined and stored. They can then be assigned to a loan upon creating the loan application.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FEE_ID	NUMBER	(15)	Yes	Fee Id
FEE_NAME	VARCHAR2	(50)	Yes	Fee Name
FEE_DESCRIPTION	VARCHAR2	(250)		Fee Description
FEE_CATEGORY	VARCHAR2	(30)		Fee Category (lookup type: 'FEE_CATEGORY')
FEE_TYPE	VARCHAR2	(30)		Fee Type as driven by Fee Category (lookups type: 'ORIGINATION_FEE_APPLICABLE_TO', 'SERVICING_FEE_APPLICABLE_TO', 'MEMO_FEE_APPLICABLE_TO')
FEE	NUMBER			Fee (amount or rate percentage based on RATE_TYPE)
FEE_BASIS	VARCHAR2	(30)		Basis of Fee (lookup type: 'FEE_BASIS')
START_DATE_ACTIVE	DATE			Start date active
END_DATE_ACTIVE	DATE			End date active
NUMBER_GRACE_DAYS	NUMBER			Number of grace days allowed (applies to Late Payment)
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
RATE_TYPE	VARCHAR2	(30)		Rate Type (lookup type: 'RATE_TYPE')
BILLING_OPTION	VARCHAR2	(30)		Billing option as driven by Fee Category (lookup types: 'ORIGINATION_FEE_BILLING_OPTION', 'SERVICING_FEE_BILLING_OPTION', 'MEMO_FEE_BILLING_OPTION')
COLLECTED_THIRD_PARTY_FLAG	VARCHAR2	(1)		Flag to indicate if fee is collected for third party
CURRENCY_CODE	VARCHAR2	(30)		Currency Code
MINIMUM_OVERDUE_AMOUNT	NUMBER			Minimum overdue amount
FEE_BASIS_RULE	VARCHAR2	(30)		Fee Basis Rule
FEE_WAIVABLE_FLAG	VARCHAR2	(1)		Fee Waivable Flag
FEE_EDITABLE_FLAG	VARCHAR2	(1)		Fee Editable Flag
ORG_ID	NUMBER	(15)	Yes	Organization ID
CUSTOM_PROCEDURE	VARCHAR2	(250)		Custom Procudure

Query Text

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


SELECT FEE_ID
,      FEE_NAME
,      FEE_DESCRIPTION
,      FEE_CATEGORY
,      FEE_TYPE
,      FEE
,      FEE_BASIS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      NUMBER_GRACE_DAYS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      RATE_TYPE
,      BILLING_OPTION
,      COLLECTED_THIRD_PARTY_FLAG
,      CURRENCY_CODE
,      MINIMUM_OVERDUE_AMOUNT
,      FEE_BASIS_RULE
,      FEE_WAIVABLE_FLAG
,      FEE_EDITABLE_FLAG
,      ORG_ID
,      CUSTOM_PROCEDURE
FROM LNS.LNS_FEES_ALL;

Dependencies

[top of page]

LNS.LNS_FEES_ALL does not reference any database object

LNS.LNS_FEES_ALL is referenced by following:

LNS: LNS_FEES_ALL#