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_RECEIVABLE_ACTIVITIES_V

Object Details

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

View Type

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

This view contains payment activities for all installments of all loans in the system

[View Source]

Columns

Name	Datatype	Length	Comments
LOAN_ID	NUMBER	(15)	Activity for loan identifier
LOAN_AMORTIZATION_ID	NUMBER	(15)	Activity for amortization schedule identifier
PAYMENT_NUMBER	NUMBER		Activity for payment number
DUE_DATE	DATE		Installment Due Date
BILLED_CUSTOMER_TRX_ID	NUMBER	(15)	Billed customer transaction identifier from Receivables
BILLED_PAYMENT_SCHEDULE_ID	NUMBER	(15)	Billed payment schedule identifier from Receivables
BILLED_CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Billed CUSTOMER_TRX_LINE_ID from Receivables
LINE_TYPE_CODE	VARCHAR2	(30)	Billed line type, such as PRIN, INT, FEE
LINE_TYPE_DESC	VARCHAR2	(80)	Meaning of line type
LINE_DESC	VARCHAR2	(240)	Billed line description
BILLED_TRX_NUMBER	VARCHAR2	(20)	Billed transaction number from Receivables
ACTIVITY_CODE	VARCHAR2	(30)	Payment activity code, such as PMT, CM, ADJ
ACTIVITY_DESC	VARCHAR2	(163)	Meaning of activity code
ACTIVITY_AMOUNT	NUMBER		Activity amount in original transaction currency
ACTIVITY_NUMBER	VARCHAR2	(30)	Activity number from Receivables
ACTIVITY_DATE	DATE		Activity date
BALANCE_BY_ACTIVITY_DATE	NUMBER		Principal balance by activity date
RECEIVABLES_APPLICATION_ID	NUMBER		Receivables identifier for payments and credit memos
CASH_RECEIPT_ID	NUMBER		Cash receipt identifier for payments and credit memos
ADJUSTMENT_ID	NUMBER		Adjustments identifier
CREATION_DATE	DATE		Activity creation date
CREATED_BY	NUMBER	(15)	Activity created by user
LAST_UPDATE_LOGIN	NUMBER	(15)	Activity last updated by this login
LAST_UPDATE_DATE	DATE		Activity last update date
LAST_UPDATED_BY	NUMBER	(15)	Activity last updated by user
TRX_CURRENCY	VARCHAR2	(15)	Original transaction currency
RECEIPT_AMT_APPLIED_FROM	NUMBER		Payment amount in original receipt currency. Set for payments only.
RECEIPT_CURRENCY	VARCHAR2	(15)	Original receipt currency. Set for payments only.
TRX_TO_RECEIPT_RATE	NUMBER		Transaction to receipt exchange rate. Set for payments only.
ORG_ID	NUMBER	(15)	Identifies the Org
LEGAL_ENTITY_ID	NUMBER	(15)	Identifies Legal Entity
PHASE	VARCHAR2	(30)	Installment Phase

Query Text

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


SELECT LOAN_ID
,      LOAN_AMORTIZATION_ID
,      PAYMENT_NUMBER
,      DUE_DATE
,      BILLED_CUSTOMER_TRX_ID
,      BILLED_PAYMENT_SCHEDULE_ID
,      BILLED_CUSTOMER_TRX_LINE_ID
,      LINE_TYPE_CODE
,      LINE_TYPE_DESC
,      LINE_DESC
,      BILLED_TRX_NUMBER
,      ACTIVITY_CODE
,      ACTIVITY_DESC
,      ACTIVITY_AMOUNT
,      ACTIVITY_NUMBER
,      ACTIVITY_DATE
,      BALANCE_BY_ACTIVITY_DATE
,      RECEIVABLES_APPLICATION_ID
,      CASH_RECEIPT_ID
,      ADJUSTMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRX_CURRENCY
,      RECEIPT_AMT_APPLIED_FROM
,      RECEIPT_CURRENCY
,      TRX_TO_RECEIPT_RATE
,      ORG_ID
,      LEGAL_ENTITY_ID
,      PHASE
FROM APPS.LNS_RECEIVABLE_ACTIVITIES_V;

Dependencies

[top of page]

APPS.LNS_RECEIVABLE_ACTIVITIES_V references the following:

APPS: AR_ADJUSTMENTS_ALL; AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIVABLES_TRX_ALL; AR_RECEIVABLE_APPLICATIONS_ALL; FND_GLOBAL - show dependent code; LNS_AMORTIZATION_LINES; LNS_AMORTIZATION_SCHEDS; LNS_LOAN_HEADERS_ALL; LNS_LOOKUPS; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL

APPS.LNS_RECEIVABLE_ACTIVITIES_V is not referenced by any database object