[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_PAYMENTS_SUMMARY_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  LNS.LNS_PAYMENTS_SUMMARY_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOAN_ID | NUMBER | (15) | Yes | Loan identifier |
| NEXT_PAYMENT_AMORTIZATION_ID | NUMBER | Amortization schedule identifier for next loan payment | ||
| NEXT_PAYMENT_NUMBER | NUMBER | Payment number of next loan payment | ||
| NEXT_PAYMENT_DUE_DATE | DATE | Due date of next loan payment | ||
| NEXT_PAYMENT_PRINCIPAL_DUE | NUMBER | Principal amount due for next loan payment | ||
| NEXT_PAYMENT_INTEREST_DUE | NUMBER | Interest amount due for next loan payment | ||
| NEXT_PAYMENT_FEE_DUE | NUMBER | Fee amount due for next loan payment | ||
| NEXT_PAYMENT_TOTAL_DUE | NUMBER | Total amount due for next loan payment | ||
| PRINCIPAL_PAID_TODATE | NUMBER | Total loan principal paid excluding manual bills | ||
| INTEREST_PAID_TODATE | NUMBER | Total loan interest paid | ||
| FEE_PAID_TODATE | NUMBER | Total loan fees paid | ||
| TOTAL_PRIN_PAID_TODATE | NUMBER | Total loan principal paid to date | ||
| TOTAL_PRINCIPAL_BALANCE | NUMBER | Total remaining unpaid loan amount | ||
| PRINCIPAL_BALANCE | NUMBER | Total remaining unpaid loan amount excluding manual bills | ||
| FUNDED_AMOUNT | NUMBER | Initial loan funded amount | ||
| PRINCIPAL_PAID_YTD | NUMBER | Total principal paid year to date | ||
| INTEREST_PAID_YTD | NUMBER | Total interest paid year to date | ||
| FEE_PAID_YTD | NUMBER | |||
| PRINCIPAL_PAID_LAST_YEAR | NUMBER | Total principal paid last year | ||
| INTEREST_PAID_LAST_YEAR | NUMBER | Total interest paid last year | ||
| FEE_PAID_LAST_YEAR | NUMBER | |||
| PRINCIPAL_OVERDUE | NUMBER | Total principal amount overdue | ||
| INTEREST_OVERDUE | NUMBER | Total interest amount overdue | ||
| FEE_OVERDUE | NUMBER | Total fee amount overdue | ||
| TOTAL_OVERDUE | NUMBER | Total amount overdue | ||
| NUMBER_OVERDUE_BILLS | NUMBER | Number of overdue installments | ||
| LAST_OVERDUE_DATE | DATE | Date of last missed payment | ||
| OLDEST_OVERDUE_DATE | DATE | Date of oldest missed payment | ||
| LAST_PAYMENT_AMOUNT | NUMBER | Last loan payment amount | ||
| LAST_PAYMENT_DATE | DATE | Last loan payment date | ||
| ORG_ID | NUMBER | (15) | Yes | |
| LEGAL_ENTITY_ID | NUMBER | (15) | ||
| CURRENT_PHASE | VARCHAR2 | (30) |
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
, PRINCIPAL_PAID_YTD
, INTEREST_PAID_YTD
, FEE_PAID_YTD
, PRINCIPAL_PAID_LAST_YEAR
, INTEREST_PAID_LAST_YEAR
, FEE_PAID_LAST_YEAR
, PRINCIPAL_OVERDUE
, INTEREST_OVERDUE
, FEE_OVERDUE
, TOTAL_OVERDUE
, NUMBER_OVERDUE_BILLS
, LAST_OVERDUE_DATE
, OLDEST_OVERDUE_DATE
, LAST_PAYMENT_AMOUNT
, LAST_PAYMENT_DATE
, ORG_ID
, LEGAL_ENTITY_ID
, CURRENT_PHASE
FROM APPS.LNS_PAYMENTS_SUMMARY_V;
APPS
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
LNS_AMORTIZATION_SCHEDS
LNS_LOAN_HEADERS_ALL
APPS
LNS_WORK_FLOW
- show dependent code
|
|
|
|