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.OE_RA_CUSTOMER_TRX_V

Object Details

Object Name:	OE_RA_CUSTOMER_TRX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_RA_CUSTOMER_TRX_V
Subobject Name:
Status:	VALID

View Type

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

This view is used to get information about invoices/credit memos generated against an order/return or order line/return line.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Invoice Identifier - unique key of table RA_CUSTOMER_TRX_ALL
TRX_NUMBER	VARCHAR2	(20)	Yes	Invoice Number or Transaction Number
BATCH_SOURCE	VARCHAR2	(50)		Batch Source Name defined in table RA_BATCH_SOURCES_ALL.
TYPE	VARCHAR2	(20)		Receivables Transaction Type Name
TRX_DATE	DATE		Yes	Invoice Date
BALANCE	NUMBER			Remaining amount due on the Invoice
INVOICE_AMOUNT	NUMBER			Total Amount on the Invoice
CREATION_DATE	DATE		Yes	Standard WHO Column -date when this row was created
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column -user who created this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column -date when a user last updated this row
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column -user who last updated this row(foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column -operating system login of user who last updated this row(foreign key to FND_LOGINS.LOGIN_ID)
ROW_ID	ROWID	(10)		Internal ROWID of RA_CUSTOMER_TRX
ORDER_NUMBER	VARCHAR2	(150)		Sales Order Number
ORDER_TYPE	VARCHAR2	(150)		Sales Order Transaction Type Name
LINE_ID	VARCHAR2	(150)		Unique Identifier of sales order line stored in OE_ORDER_LINES_ALL table.

Query Text

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


SELECT CUSTOMER_TRX_ID
,      TRX_NUMBER
,      BATCH_SOURCE
,      TYPE
,      TRX_DATE
,      BALANCE
,      INVOICE_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ROW_ID
,      ORDER_NUMBER
,      ORDER_TYPE
,      LINE_ID
FROM APPS.OE_RA_CUSTOMER_TRX_V;

Dependencies

[top of page]

APPS.OE_RA_CUSTOMER_TRX_V references the following:

APPS: OE_INVOICE_PUB - show dependent code; RA_BATCH_SOURCES_ALL; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL; RA_CUST_TRX_TYPES_ALL

APPS.OE_RA_CUSTOMER_TRX_V is not referenced by any database object