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

VIEW: APPS.LNS_PAY_SUM_OVERDUE_V

Object Details
Object Name: LNS_PAY_SUM_OVERDUE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewLNS.LNS_PAY_SUM_OVERDUE_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 overdue information for every loan in the system


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Yes Identifies the Loan
PRINCIPAL_OVERDUE NUMBER

Principal Overdue Amount
INTEREST_OVERDUE NUMBER

Interest Overdue Amount
FEE_OVERDUE NUMBER

Fee Overdue Amount
TOTAL_OVERDUE NUMBER

Total Overdue Amount
NUMBER_OVERDUE_BILLS NUMBER

Number Overdue Bills
LAST_OVERDUE_DATE DATE

Latest Overdue Date
OLDEST_OVERDUE_DATE DATE

Earliest Overdue Date
LAST_PAYMENT_AMOUNT NUMBER

Last Payment Amount
LAST_PAYMENT_DATE DATE

Last Payment Date
Query Text

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


SELECT LOAN_ID
,      PRINCIPAL_OVERDUE
,      INTEREST_OVERDUE
,      FEE_OVERDUE
,      TOTAL_OVERDUE
,      NUMBER_OVERDUE_BILLS
,      LAST_OVERDUE_DATE
,      OLDEST_OVERDUE_DATE
,      LAST_PAYMENT_AMOUNT
,      LAST_PAYMENT_DATE
FROM APPS.LNS_PAY_SUM_OVERDUE_V;

Dependencies

[top of page]

APPS.LNS_PAY_SUM_OVERDUE_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymLNS_AMORTIZATION_SCHEDS
SynonymLNS_LOAN_HEADERS_ALL
APPS.LNS_PAY_SUM_OVERDUE_V is referenced by following:

SchemaAPPS
Package BodyLNS_OCM_ADP_PUB - show dependent code
Package BodyLNS_WORK_FLOW - show dependent code