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_REC_ACT_CASH_CM_V

Object Details

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

View Type

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

This view contains cash and credit memo payment activities for all installments of all loans in the system

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOAN_ID	NUMBER	(15)	Yes	Identifies the Loan
LOAN_AMORTIZATION_ID	NUMBER	(15)	Yes	Identifies the Amortization Schedule
PAYMENT_NUMBER	NUMBER			Payment Number
DUE_DATE	DATE			Due Date
BILLED_CUSTOMER_TRX_ID	NUMBER	(15)		Identifies the Transaction
BILLED_PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Identifies the Payment Schedule
LINE_TYPE_CODE	VARCHAR2	(30)		Bill Type: PRIN, INT, FEE
LINE_TYPE_DESC	VARCHAR2	(80)	Yes	Bill Type Description: Principal, Interest, Fee
LINE_DESC	VARCHAR2	(240)		Description of the Line or Entire Transaction
BILLED_TRX_NUMBER	VARCHAR2	(30)		Transaction Number
ACTIVITY_CODE	VARCHAR2	(30)	Yes	Receivable Activity Code
ACTIVITY_DESC	VARCHAR2	(163)		Receivable Activity Description
ACTIVITY_AMOUNT	NUMBER			Receivable Activity Amount
ACTIVITY_NUMBER	VARCHAR2	(30)		Receivable Activity Number
ACTIVITY_DATE	DATE		Yes	Receivable Activity Date
RECEIVABLES_APPLICATION_ID	NUMBER	(15)	Yes	Identifies the Receivable Application
CASH_RECEIPT_ID	NUMBER	(15)		Identifies the Cash Receipt
ADJUSTMENT_ID	NUMBER			Identifies the Adjustment
CREATION_DATE	DATE		Yes	Creation Date
CREATED_BY	NUMBER	(15)	Yes	Created By
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By
TRX_CURRENCY	VARCHAR2	(15)	Yes	Transaction Currency
RECEIPT_AMT_APPLIED_FROM	NUMBER			Amount Applied In Receipt Currency
RECEIPT_CURRENCY	VARCHAR2	(15)		Receipt Currency
TRX_TO_RECEIPT_RATE	NUMBER			Transaction to Receipt Rate
ORG_ID	NUMBER	(15)	Yes	Identifies the Org
LEGAL_ENTITY_ID	NUMBER	(15)		Identifies the Legal Entity
PHASE	VARCHAR2	(30)		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
,      LINE_TYPE_CODE
,      LINE_TYPE_DESC
,      LINE_DESC
,      BILLED_TRX_NUMBER
,      ACTIVITY_CODE
,      ACTIVITY_DESC
,      ACTIVITY_AMOUNT
,      ACTIVITY_NUMBER
,      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_REC_ACT_CASH_CM_V;

Dependencies

[top of page]

APPS.LNS_REC_ACT_CASH_CM_V references the following:

APPS: AR_LOOKUPS; AR_PAYMENT_SCHEDULES_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_REC_ACT_CASH_CM_V is referenced by following:

APPS: LNS_FINANCIALS - show dependent code