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_AM_SCHEDS_DTL_V

Object Details

Object Name:	LNS_AM_SCHEDS_DTL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_AM_SCHEDS_DTL_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	Comments
LOAN_ID	NUMBER	(15)	Yes	Identifies the Loan
AMORTIZATION_SCHEDULE_ID	NUMBER	(15)	Yes	Identifies the Amortization Schedule
PAYMENT_NUMBER	NUMBER			Payment Number
DUE_DATE	DATE			Due Date
PRINCIPAL_AMOUNT	NUMBER			Billed Principal Amount
INTEREST_AMOUNT	NUMBER			Billed Interest Amount
FEE_AMOUNT	NUMBER			Billed Fee Amount
PRIN_CASH	NUMBER			Principal Paid in Cash
PRIN_LOAN_PMT_CREDIT	NUMBER			Principal Paid as Credit Memo
PRIN_NET_CREDIT	NUMBER			Principal Paid as Netting Credit Memo
PRIN_OTHER_CREDIT	NUMBER			Other Credit Memos on Principal
PRIN_CREDIT	NUMBER			Credit Memos on Principal
PRIN_ADJ	NUMBER			Adjustements on Principal
INT_CASH	NUMBER			Interest Paid in Cash
INT_LOAN_PMT_CREDIT	NUMBER			Interest Paid as Credit Memo
INT_NET_CREDIT	NUMBER			Interest Paid as Netting Credit Memo
INT_OTHER_CREDIT	NUMBER			Other Credit Memos on Interest
INT_CREDIT	NUMBER			Credit Memos on Interest
INT_ADJ	NUMBER			Adjustements on Interest
FEE_CASH	NUMBER			Fee Paid in Cash
FEE_LOAN_PMT_CREDIT	NUMBER			Fee Paid as Credit Memo
FEE_NET_CREDIT	NUMBER			Fee Paid as Netting Credit Memo
FEE_OTHER_CREDIT	NUMBER			Other Credit Memos on Fee
FEE_CREDIT	NUMBER			Credit Memos on Fee
FEE_ADJ	NUMBER			Adjustements on Fee
TOTAL_BILLED_AMOUNT	NUMBER			Total Billed Amount
REVERSED_CODE	VARCHAR2	(1)		Reversed Code
BILL_TYPE_CODE	VARCHAR2	(9)		Bill Type Code
BILL_TYPE_DESC	VARCHAR2	(80)	Yes	Bill Type Description
PRINCIPAL_REMAINING	NUMBER			Principal Remaining Amount
INTEREST_REMAINING	NUMBER			Interest Remaining Amount
FEE_REMAINING	NUMBER			Fee Remaining Amount
PHASE	VARCHAR2	(30)		Phase

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
,      INT_CASH
,      INT_LOAN_PMT_CREDIT
,      INT_NET_CREDIT
,      INT_OTHER_CREDIT
,      INT_CREDIT
,      INT_ADJ
,      FEE_CASH
,      FEE_LOAN_PMT_CREDIT
,      FEE_NET_CREDIT
,      FEE_OTHER_CREDIT
,      FEE_CREDIT
,      FEE_ADJ
,      TOTAL_BILLED_AMOUNT
,      REVERSED_CODE
,      BILL_TYPE_CODE
,      BILL_TYPE_DESC
,      PRINCIPAL_REMAINING
,      INTEREST_REMAINING
,      FEE_REMAINING
,      PHASE
FROM APPS.LNS_AM_SCHEDS_DTL_V;

Dependencies

[top of page]

APPS.LNS_AM_SCHEDS_DTL_V references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; FND_GLOBAL - show dependent code; LNS_AMORTIZATION_SCHEDS; LNS_LOAN_HEADERS_ALL; LNS_LOOKUPS

APPS.LNS_AM_SCHEDS_DTL_V is not referenced by any database object