eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.LNS_AR_AMORTIZATIONS_V

Object Details

Object Name:	LNS_AR_AMORTIZATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_AR_AMORTIZATIONS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length
LOAN_ID	NUMBER
AMORTIZATION_SCHEDULE_ID	NUMBER
PAYMENT_NUMBER	NUMBER
DUE_DATE	DATE
PRINCIPAL_AMOUNT	NUMBER
INTEREST_AMOUNT	NUMBER
FEE_AMOUNT	NUMBER
PRIN_CASH	NUMBER
PRIN_LOAN_PMT_CREDIT	NUMBER
PRIN_NET_CREDIT	NUMBER
PRIN_OTHER_CREDIT	NUMBER
PRIN_NEG_ADJ	NUMBER
PRIN_POS_ADJ	NUMBER
INT_CASH	NUMBER
INT_LOAN_PMT_CREDIT	NUMBER
INT_NET_CREDIT	NUMBER
INT_OTHER_CREDIT	NUMBER
INT_NEG_ADJ	NUMBER
INT_POS_ADJ	NUMBER
FEE_CASH	NUMBER
FEE_LOAN_PMT_CREDIT	NUMBER
FEE_NET_CREDIT	NUMBER
FEE_OTHER_CREDIT	NUMBER
FEE_NEG_ADJ	NUMBER
FEE_POS_ADJ	NUMBER
PRIN_TD_CASH	NUMBER
PRIN_TD_LOAN_PMT_CREDIT	NUMBER
PRIN_TD_NET_CREDIT	NUMBER
PRIN_TD_OTHER_CREDIT	NUMBER
PRIN_TD_NEG_ADJ	NUMBER
PRIN_TD_POS_ADJ	NUMBER
INT_TD_CASH	NUMBER
INT_TD_LOAN_PMT_CREDIT	NUMBER
INT_TD_NET_CREDIT	NUMBER
INT_TD_OTHER_CREDIT	NUMBER
INT_TD_NEG_ADJ	NUMBER
INT_TD_POS_ADJ	NUMBER
FEE_TD_CASH	NUMBER
FEE_TD_LOAN_PMT_CREDIT	NUMBER
FEE_TD_NET_CREDIT	NUMBER
FEE_TD_OTHER_CREDIT	NUMBER
FEE_TD_NEG_ADJ	NUMBER
FEE_TD_POS_ADJ	NUMBER
TOTAL_PRIN_TD_CASH	NUMBER
TOTAL_PRIN_TD_LOAN_PMT_CREDIT	NUMBER
TOTAL_PRIN_TD_NET_CREDIT	NUMBER
TOTAL_PRIN_TD_OTHER_CREDIT	NUMBER
TOTAL_PRIN_TD_NEG_ADJ	NUMBER
TOTAL_PRIN_TD_POS_ADJ	NUMBER
FUNDED_AMOUNT	NUMBER
TOTAL_BILLED_AMOUNT	NUMBER
TOTAL_AR_BILLED_AMOUNT	NUMBER
TOTAL_REMAINING_AMOUNT	NUMBER
TOTAL_APPLIED_AMOUNT	NUMBER
LAST_APPLIED_DATE	DATE
REVERSED_CODE	VARCHAR2	(0)
TOTAL_ADJUSTED_AMOUNT	NUMBER
TOTAL_CREDITED_AMOUNT	NUMBER
LAST_CREDITED_DATE	DATE
CREATION_DATE	DATE
PARENT_AMORTIZATION_ID	NUMBER
BILL_TYPE_CODE	VARCHAR2	(0)
PRINCIPAL_REMAINING	NUMBER
INTEREST_REMAINING	NUMBER
FEE_REMAINING	NUMBER
PRINCIPAL_TRX_ID	NUMBER
INTEREST_TRX_ID	NUMBER
FEE_TRX_ID	NUMBER
STATEMENT_XML	VARCHAR2	(0)
LOAN_STATUS	VARCHAR2	(0)
ORG_ID	NUMBER
CURRENCY	VARCHAR2	(0)
PRIN_USSGL_TRX_CODE	VARCHAR2	(0)
INT_USSGL_TRX_CODE	VARCHAR2	(0)
FEE_USSGL_TRX_CODE	VARCHAR2	(0)
LEGAL_ENTITY_ID	NUMBER
PHASE	VARCHAR2	(0)

Query Text

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


SELECT 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
FROM APPS.LNS_AR_AMORTIZATIONS_V;

Dependencies

[top of page]

APPS.LNS_AR_AMORTIZATIONS_V references the following:

PUBLIC: DUAL

APPS.LNS_AR_AMORTIZATIONS_V is not referenced by any database object