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_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Amortization Schedules View

[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
PRINCIPAL_PAID	NUMBER			Principal Paid
INTEREST_PAID	NUMBER			Interest Paid
FEE_PAID	NUMBER			Fee Paid
PRINCIPAL_BALANCE	NUMBER			Principal Balance
FUNDED_AMOUNT	NUMBER			Loan Funded Amount
TOTAL_BILLED_AMOUNT	NUMBER			Total Billed Amount
TOTAL_AR_BILLED_AMOUNT	NUMBER			Total Billed Amount from AR
TOTAL_REMAINING_AMOUNT	NUMBER			Total Remaining Amount
LAST_APPLIED_DATE	DATE			Last Applied Date
REVERSED_CODE	VARCHAR2	(1)		Reversed Code
REVERSED_DESC	VARCHAR2	(80)	Yes	Reversed Description
CREATION_DATE	DATE		Yes	Amortization Creation Date
PARENT_AMORTIZATION_ID	NUMBER			Identifies the Parent Amortization
BILL_TYPE_CODE	VARCHAR2	(9)		Bill Type Code
BILL_TYPE_DESC	VARCHAR2	(80)	Yes	Bill Type Description
CREDIT_ENABLED_CODE	VARCHAR2	(15)		Credit Enabled Code
REBILL_ENABLED_CODE	VARCHAR2	(15)		Rebill Enabled Code
PRINCIPAL_REMAINING	NUMBER			Remaining Principal Amount
INTEREST_REMAINING	NUMBER			Remaining Interest Amount
FEE_REMAINING	NUMBER			Remaining Fee Amount
PRINCIPAL_TRX_ID	NUMBER			Identifies the Principal Transaction
INTEREST_TRX_ID	NUMBER			Identifies the Interest Transaction
FEE_TRX_ID	NUMBER			Identifies the Fee Transaction
STATEMENT_XML	CLOB	(4000)		Billing Statement
LOAN_STATUS	VARCHAR2	(30)	Yes	Loan Status
ORG_ID	NUMBER	(15)	Yes	Identifies the Org
LOAN_CURRENCY	VARCHAR2	(15)	Yes	Loan Currency
LEGAL_ENTITY_ID	NUMBER	(15)		Identifies the Legal Entity
PHASE	VARCHAR2	(30)		Phase
TRX_DATE	DATE			Trx Date
GL_DATE	DATE			Gl Date

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
,      PRINCIPAL_PAID
,      INTEREST_PAID
,      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
,      LOAN_CURRENCY
,      LEGAL_ENTITY_ID
,      PHASE
,      TRX_DATE
,      GL_DATE
FROM APPS.LNS_AM_SCHEDS_V;

Dependencies

[top of page]

APPS.LNS_AM_SCHEDS_V references the following:

APPS: AR_ADJUSTMENTS_ALL; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIVABLE_APPLICATIONS_ALL; FND_GLOBAL - show dependent code; FND_LOOKUPS; LNS_AMORTIZATION_SCHEDS; LNS_DISB_HEADERS; LNS_DISB_LINES; LNS_LOAN_AMOUNT_ADJS; LNS_LOAN_HEADERS_ALL; LNS_LOAN_LINES; LNS_LOOKUPS

APPS.LNS_AM_SCHEDS_V is referenced by following:

APPS: LNS_BILLING_BATCH_PUB - show dependent code; LNS_CUSTOM_PUB - show dependent code; LNS_FINANCIALS - show dependent code