[Home] [Help]
View: LNS_AR_AMORTIZATIONS_V
Product: | LNS - Loans |
Description: | This view contains basic billing and payment information for every loan in the system. |
Implementation/DBA Data: |
APPS.LNS_AR_AMORTIZATIONS_V
|
View Text
SELECT TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
FROM DUAL
Columns
Name |
LOAN_ID |
AMORTIZATION_SCHEDULE_ID |
PAYMENT_NUMBER |
DUE_DATE |
PRINCIPAL_AMOUNT |
INTEREST_AMOUNT |
FEE_AMOUNT |
PRIN_CASH |
PRIN_LOAN_PMT_CREDIT |
PRIN_NET_CREDIT |
PRIN_OTHER_CREDIT |
PRIN_NEG_ADJ |
PRIN_POS_ADJ |
INT_CASH |
INT_LOAN_PMT_CREDIT |
INT_NET_CREDIT |
INT_OTHER_CREDIT |
INT_NEG_ADJ |
INT_POS_ADJ |
FEE_CASH |
FEE_LOAN_PMT_CREDIT |
FEE_NET_CREDIT |
FEE_OTHER_CREDIT |
FEE_NEG_ADJ |
FEE_POS_ADJ |
PRIN_TD_CASH |
PRIN_TD_LOAN_PMT_CREDIT |
PRIN_TD_NET_CREDIT |
PRIN_TD_OTHER_CREDIT |
PRIN_TD_NEG_ADJ |
PRIN_TD_POS_ADJ |
INT_TD_CASH |
INT_TD_LOAN_PMT_CREDIT |
INT_TD_NET_CREDIT |
INT_TD_OTHER_CREDIT |
INT_TD_NEG_ADJ |
INT_TD_POS_ADJ |
FEE_TD_CASH |
FEE_TD_LOAN_PMT_CREDIT |
FEE_TD_NET_CREDIT |
FEE_TD_OTHER_CREDIT |
FEE_TD_NEG_ADJ |
FEE_TD_POS_ADJ |
TOTAL_PRIN_TD_CASH |
TOTAL_PRIN_TD_LOAN_PMT_CREDIT |
TOTAL_PRIN_TD_NET_CREDIT |
TOTAL_PRIN_TD_OTHER_CREDIT |
TOTAL_PRIN_TD_NEG_ADJ |
TOTAL_PRIN_TD_POS_ADJ |
FUNDED_AMOUNT |
TOTAL_BILLED_AMOUNT |
TOTAL_AR_BILLED_AMOUNT |
TOTAL_REMAINING_AMOUNT |
TOTAL_APPLIED_AMOUNT |
LAST_APPLIED_DATE |
REVERSED_CODE |
TOTAL_ADJUSTED_AMOUNT |
TOTAL_CREDITED_AMOUNT |
LAST_CREDITED_DATE |
CREATION_DATE |
PARENT_AMORTIZATION_ID |
BILL_TYPE_CODE |
PRINCIPAL_REMAINING |
INTEREST_REMAINING |
FEE_REMAINING |
PRINCIPAL_TRX_ID |
INTEREST_TRX_ID |
FEE_TRX_ID |
STATEMENT_XML |
LOAN_STATUS |
ORG_ID |
CURRENCY |
PRIN_USSGL_TRX_CODE |
INT_USSGL_TRX_CODE |
FEE_USSGL_TRX_CODE |
LEGAL_ENTITY_ID |
PHASE |