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_FEE_ASSIGNMENTS

Object Details

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

LNS_FEE_ASSIGNMENTS stores the assignments of fees to existing loans. It allows the user to override the following default properties setup in LNS_FEES: Fee Type, Fee, Fee Basis, Number of Grace Days, Collected for Third Party Flag, Billing Option, Rate Type. Begin Installment Number and End Installment Number are mandatory when the Billing Option is 'Amortize'. Number of Payments is required for Memo Fees which has Billing Option that is 'Due Before First Loan Payment'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_FEE_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FEE_ASSIGNMENT_ID
LNS_FEE_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOAN_ID
LNS_FEE_ASSIGNMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_ID
LNS_FEE_ASSIGNMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISB_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FEE_ASSIGNMENT_ID	NUMBER	(15)	Yes	Fee Assignment Id
LOAN_ID	NUMBER	(15)		Loan Id
FEE_ID	NUMBER	(15)	Yes	Fee Id
FEE_TYPE	VARCHAR2	(30)		Type of Fee (lookup type: 'FEE_TYPE')
FEE	NUMBER			Fee (Amount or rate percentage based on RATE_TYPE)
FEE_BASIS	VARCHAR2	(30)		Basis of Fee (lookup type: 'FEE_BASIS')
NUMBER_GRACE_DAYS	NUMBER			Number of grace days alowed for late payment
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE			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
COLLECTED_THIRD_PARTY_FLAG	VARCHAR2	(1)		Flag to indicate if fee is collected for third party
BILLING_OPTION	VARCHAR2	(30)		Billing option (lookup types: 'ORIGINATION_FEE_BILLING_OPTION', 'SERVICING_FEE_BILLING_OPTION', 'MEMO_FEE_BILLING_OPTION')
RATE_TYPE	VARCHAR2	(30)		Rate Type (lookup type: 'RATE_TYPE')
BEGIN_INSTALLMENT_NUMBER	NUMBER			Installment number of loan for which the fee begins to apply
END_INSTALLMENT_NUMBER	NUMBER			Installment number of loan for which the fee ends to apply
NUMBER_OF_PAYMENTS	NUMBER			Number of payments (applies to Memo Fees only)
START_DATE_ACTIVE	DATE			Start date active
END_DATE_ACTIVE	DATE			End date active
DISB_HEADER_ID	NUMBER	(15)		FK to LNS_DISB_HEADERS
OPEN_PHASE_FLAG	VARCHAR2	(1)		Fee is in Open Phase
DELETE_DISABLED_FLAG	VARCHAR2	(1)		Disable Deleting Fee

Query Text

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


SELECT FEE_ASSIGNMENT_ID
,      LOAN_ID
,      FEE_ID
,      FEE_TYPE
,      FEE
,      FEE_BASIS
,      NUMBER_GRACE_DAYS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      COLLECTED_THIRD_PARTY_FLAG
,      BILLING_OPTION
,      RATE_TYPE
,      BEGIN_INSTALLMENT_NUMBER
,      END_INSTALLMENT_NUMBER
,      NUMBER_OF_PAYMENTS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DISB_HEADER_ID
,      OPEN_PHASE_FLAG
,      DELETE_DISABLED_FLAG
FROM LNS.LNS_FEE_ASSIGNMENTS;

Dependencies

[top of page]

LNS.LNS_FEE_ASSIGNMENTS does not reference any database object

LNS.LNS_FEE_ASSIGNMENTS is referenced by following:

APPS: LNS_FEE_ASSIGNMENTS