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_PRIN_TRX_ACTIVITIES_V

Object Details

Object Name:	LNS_PRIN_TRX_ACTIVITIES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

Principal Transaction Activities View

[View Source]

Columns

Name	Datatype	Length	Comments
LOAN_ID	NUMBER	(15)	Identifies the Loan
LOAN_AMORTIZATION_ID	NUMBER		Identifies the Amortization Schedule
PAYMENT_NUMBER	NUMBER		Payment Number
DUE_DATE	DATE		Due Date
PRINCIPAL_DUE	NUMBER		Billed Principal Amount
INTEREST_DUE	NUMBER		Billed Interest Amount
FEE_DUE	NUMBER		Billed Fee Amount
PARENT_AMORTIZATION_ID	NUMBER		Parent Amortization
BILLED_CUSTOMER_TRX_ID	NUMBER		Billed Transaction
BILLED_PAYMENT_SCHEDULE_ID	NUMBER		Billed Payment Schedule
BILLED_TRX_NUMBER	VARCHAR2	(59)	Billed Transaction Number
ACTIVITY_CODE	VARCHAR2	(20)	Activity Code
ACTIVITY_AMOUNT	NUMBER		Activity Amount
ACTIVITY_NUMBER	VARCHAR2	(270)	Activity Number
ACTIVITY_DATE	DATE		Activity Date
ACTUAL_BALANCE	NUMBER		Actual Balance
THEORETICAL_BALANCE	NUMBER		Projected Balance
DAYS_LATE	NUMBER		Days Late
ORG_ID	NUMBER	(15)	Identifies the Org
DISPLAY_ORDER	NUMBER		Display Order
INTEREST_RATE	NUMBER		Current Interest Rate

Query Text

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


SELECT LOAN_ID
,      LOAN_AMORTIZATION_ID
,      PAYMENT_NUMBER
,      DUE_DATE
,      PRINCIPAL_DUE
,      INTEREST_DUE
,      FEE_DUE
,      PARENT_AMORTIZATION_ID
,      BILLED_CUSTOMER_TRX_ID
,      BILLED_PAYMENT_SCHEDULE_ID
,      BILLED_TRX_NUMBER
,      ACTIVITY_CODE
,      ACTIVITY_AMOUNT
,      ACTIVITY_NUMBER
,      ACTIVITY_DATE
,      ACTUAL_BALANCE
,      THEORETICAL_BALANCE
,      DAYS_LATE
,      ORG_ID
,      DISPLAY_ORDER
,      INTEREST_RATE
FROM APPS.LNS_PRIN_TRX_ACTIVITIES_V;

Dependencies

[top of page]

APPS.LNS_PRIN_TRX_ACTIVITIES_V references the following:

APPS: AR_ADJUSTMENTS_ALL; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIVABLES_TRX_ALL; AR_RECEIVABLE_APPLICATIONS_ALL; LNS_AMORTIZATION_SCHEDS; LNS_DISB_HEADERS; LNS_DISB_LINES; LNS_LOAN_AMOUNT_ADJS; LNS_LOAN_HEADERS_ALL; LNS_LOAN_LINES; LNS_RATE_SCHEDULES; LNS_TERMS; RA_CUSTOMER_TRX_ALL

APPS.LNS_PRIN_TRX_ACTIVITIES_V is referenced by following:

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