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

VIEW: APPS.LNS_LOAN_PAYMENT_SUMMARY_V

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

View Type

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


This view contains basic billing and payment summary information for every loan in the system. This is public view for other applications.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Yes Loan identifier
TOTAL_PRINCIPAL_BALANCE NUMBER

Total remaining unpaid amount for this loan
NEXT_PAYMENT_DUE_DATE DATE

Due date of next due installment
NEXT_PAYMENT_TOTAL_DUE NUMBER

Due date of next due installment
TOTAL_OVERDUE NUMBER

Total amount overdue
LAST_OVERDUE_DATE DATE

Last date payment was missed
OLDEST_OVERDUE_DATE DATE

Oldest OVerdue Invoice
LAST_PAYMENT_AMOUNT NUMBER

Last payment amount on the loan
LAST_PAYMENT_DATE DATE

Last payment date on the loan
ORG_ID NUMBER (15) Yes Organization ID
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity ID
CURRENT_PHASE VARCHAR2 (30)
Current Phase
Query Text

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


SELECT LOAN_ID
,      TOTAL_PRINCIPAL_BALANCE
,      NEXT_PAYMENT_DUE_DATE
,      NEXT_PAYMENT_TOTAL_DUE
,      TOTAL_OVERDUE
,      LAST_OVERDUE_DATE
,      OLDEST_OVERDUE_DATE
,      LAST_PAYMENT_AMOUNT
,      LAST_PAYMENT_DATE
,      ORG_ID
,      LEGAL_ENTITY_ID
,      CURRENT_PHASE
FROM APPS.LNS_LOAN_PAYMENT_SUMMARY_V;

Dependencies

[top of page]

APPS.LNS_LOAN_PAYMENT_SUMMARY_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymLNS_AMORTIZATION_SCHEDS
SynonymLNS_LOAN_HEADERS_ALL

APPS.LNS_LOAN_PAYMENT_SUMMARY_V is not referenced by any database object