Skip to content FND Design Data [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: ViewAPPS.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