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.LNS_PAY_SUM_V

Object Details

Object Name:	LNS_PAY_SUM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_PAY_SUM_V
Subobject Name:
Status:	VALID

View Type

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

This view contains payment summary information for every loan in the system

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOAN_ID	NUMBER	(15)	Yes	Identifies the Loan
NEXT_PAYMENT_AMORTIZATION_ID	NUMBER			Identifies the Next Due Amortization
NEXT_PAYMENT_NUMBER	NUMBER			Next Due Payment Number
NEXT_PAYMENT_DUE_DATE	DATE			Next Due Date
NEXT_PAYMENT_PRINCIPAL_DUE	NUMBER			Next Due Principal Amount
NEXT_PAYMENT_INTEREST_DUE	NUMBER			Next Due Interest Amount
NEXT_PAYMENT_FEE_DUE	NUMBER			Next Due Fee Amount
NEXT_PAYMENT_TOTAL_DUE	NUMBER			Next Due Total Amount
PRINCIPAL_PAID_TODATE	NUMBER			Principal Paid To Date
INTEREST_PAID_TODATE	NUMBER			Interest Paid To Date
FEE_PAID_TODATE	NUMBER			Fee Paid To Date
TOTAL_PRIN_PAID_TODATE	NUMBER			Total Principal Paid To Date
TOTAL_PRINCIPAL_BALANCE	NUMBER			Total Principal Balance
PRINCIPAL_BALANCE	NUMBER			Principal Balance
FUNDED_AMOUNT	NUMBER			Loan Funded Amount
CURRENT_PHASE	VARCHAR2	(30)		Current Loan Phase

Query Text

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


SELECT LOAN_ID
,      NEXT_PAYMENT_AMORTIZATION_ID
,      NEXT_PAYMENT_NUMBER
,      NEXT_PAYMENT_DUE_DATE
,      NEXT_PAYMENT_PRINCIPAL_DUE
,      NEXT_PAYMENT_INTEREST_DUE
,      NEXT_PAYMENT_FEE_DUE
,      NEXT_PAYMENT_TOTAL_DUE
,      PRINCIPAL_PAID_TODATE
,      INTEREST_PAID_TODATE
,      FEE_PAID_TODATE
,      TOTAL_PRIN_PAID_TODATE
,      TOTAL_PRINCIPAL_BALANCE
,      PRINCIPAL_BALANCE
,      FUNDED_AMOUNT
,      CURRENT_PHASE
FROM APPS.LNS_PAY_SUM_V;

Dependencies

[top of page]

APPS.LNS_PAY_SUM_V references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; LNS_AMORTIZATION_SCHEDS; LNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_V is referenced by following:

APPS: LNS_BILLING_BATCH_PUB - show dependent code; LNS_BILLING_UTIL_PUB - show dependent code; LNS_OCM_ADP_PUB - show dependent code; LNS_REP_UTILS - show dependent code; LNS_WORK_FLOW - show dependent code