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_AMORTIZATION_SCHEDULES_V

Object Details

Object Name:	LNS_AMORTIZATION_SCHEDULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_AMORTIZATION_SCHEDULES_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	Mandatory
LOAN_ID	NUMBER	(15)	Yes
AMORTIZATION_SCHEDULE_ID	NUMBER	(15)	Yes
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_CREDIT	NUMBER
PRIN_ADJ	NUMBER
PRINCIPAL_PAID	NUMBER
INT_CASH	NUMBER
INT_LOAN_PMT_CREDIT	NUMBER
INT_NET_CREDIT	NUMBER
INT_OTHER_CREDIT	NUMBER
INT_CREDIT	NUMBER
INT_ADJ	NUMBER
INTEREST_PAID	NUMBER
FEE_CASH	NUMBER
FEE_LOAN_PMT_CREDIT	NUMBER
FEE_NET_CREDIT	NUMBER
FEE_OTHER_CREDIT	NUMBER
FEE_CREDIT	NUMBER
FEE_ADJ	NUMBER
FEE_PAID	NUMBER
PRINCIPAL_BALANCE	NUMBER
FUNDED_AMOUNT	NUMBER
TOTAL_BILLED_AMOUNT	NUMBER
TOTAL_AR_BILLED_AMOUNT	NUMBER
TOTAL_REMAINING_AMOUNT	NUMBER
LAST_APPLIED_DATE	DATE
REVERSED_CODE	VARCHAR2	(1)
REVERSED_DESC	VARCHAR2	(80)	Yes
CREATION_DATE	DATE		Yes
PARENT_AMORTIZATION_ID	NUMBER
BILL_TYPE_CODE	VARCHAR2	(9)
BILL_TYPE_DESC	VARCHAR2	(80)	Yes
CREDIT_ENABLED_CODE	VARCHAR2	(15)
REBILL_ENABLED_CODE	VARCHAR2	(15)
PRINCIPAL_REMAINING	NUMBER
INTEREST_REMAINING	NUMBER
FEE_REMAINING	NUMBER
PRINCIPAL_TRX_ID	NUMBER
INTEREST_TRX_ID	NUMBER
FEE_TRX_ID	NUMBER
STATEMENT_XML	CLOB	(4000)
LOAN_STATUS	VARCHAR2	(30)	Yes
ORG_ID	NUMBER	(15)	Yes
CURRENCY	VARCHAR2	(15)	Yes
LEGAL_ENTITY_ID	NUMBER	(15)
PHASE	VARCHAR2	(30)

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_CREDIT
,      PRIN_ADJ
,      PRINCIPAL_PAID
,      INT_CASH
,      INT_LOAN_PMT_CREDIT
,      INT_NET_CREDIT
,      INT_OTHER_CREDIT
,      INT_CREDIT
,      INT_ADJ
,      INTEREST_PAID
,      FEE_CASH
,      FEE_LOAN_PMT_CREDIT
,      FEE_NET_CREDIT
,      FEE_OTHER_CREDIT
,      FEE_CREDIT
,      FEE_ADJ
,      FEE_PAID
,      PRINCIPAL_BALANCE
,      FUNDED_AMOUNT
,      TOTAL_BILLED_AMOUNT
,      TOTAL_AR_BILLED_AMOUNT
,      TOTAL_REMAINING_AMOUNT
,      LAST_APPLIED_DATE
,      REVERSED_CODE
,      REVERSED_DESC
,      CREATION_DATE
,      PARENT_AMORTIZATION_ID
,      BILL_TYPE_CODE
,      BILL_TYPE_DESC
,      CREDIT_ENABLED_CODE
,      REBILL_ENABLED_CODE
,      PRINCIPAL_REMAINING
,      INTEREST_REMAINING
,      FEE_REMAINING
,      PRINCIPAL_TRX_ID
,      INTEREST_TRX_ID
,      FEE_TRX_ID
,      STATEMENT_XML
,      LOAN_STATUS
,      ORG_ID
,      CURRENCY
,      LEGAL_ENTITY_ID
,      PHASE
FROM APPS.LNS_AMORTIZATION_SCHEDULES_V;