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

VIEW: APPS.LNS_PAY_SUM_YEARLY_V

Object Details
Object Name: LNS_PAY_SUM_YEARLY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewLNS.LNS_PAY_SUM_YEARLY_V
Subobject Name:
Status: VALID

View Type

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


This view contains year-to-date and last year 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
PRINCIPAL_PAID_YTD NUMBER

Principal Paid YTD
INTEREST_PAID_YTD NUMBER

Interest Paid YTD
FEE_PAID_YTD NUMBER

Fee Paid YTD
PRINCIPAL_PAID_LAST_YEAR NUMBER

Principal Paid Last Year
INTEREST_PAID_LAST_YEAR NUMBER

Interest Paid Last Year
FEE_PAID_LAST_YEAR NUMBER

Fee Paid Last Year
Query Text

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


SELECT LOAN_ID
,      PRINCIPAL_PAID_YTD
,      INTEREST_PAID_YTD
,      FEE_PAID_YTD
,      PRINCIPAL_PAID_LAST_YEAR
,      INTEREST_PAID_LAST_YEAR
,      FEE_PAID_LAST_YEAR
FROM APPS.LNS_PAY_SUM_YEARLY_V;

Dependencies

[top of page]

APPS.LNS_PAY_SUM_YEARLY_V references the following:

SchemaAPPS
SynonymAR_ADJUSTMENTS_ALL
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymLNS_AMORTIZATION_SCHEDS
SynonymLNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_YEARLY_V is not referenced by any database object