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

Object Details

Object Name:	ECE_CDMO_TRX_NUMBER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_CDMO_TRX_NUMBER_V
Subobject Name:
Status:	VALID

View Type

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

The ECE_CDMO_TRX_NUMBER_V view contains the transaction no and document type for completed Credit/debit Memo(812 CREADV/DEBADV) transactions.
The ECE_CDMO_TRX_NUMBER_V view is based on the data stored in RA_CUSTOMERS_TRX,RA_CUSTOMERS,RA_ADDRESSES and ECE_TP_DETAILS tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction Number
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Customer Transaction ID
DOCUMENT_TYPE	VARCHAR2	(20)		Document Type
CUSTOMER_ID	NUMBER	(15)	Yes	Customer ID
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Customer Name

Query Text

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


SELECT TRX_NUMBER
,      CUSTOMER_TRX_ID
,      DOCUMENT_TYPE
,      CUSTOMER_ID
,      CUSTOMER_NAME
FROM APPS.ECE_CDMO_TRX_NUMBER_V;

Dependencies

[top of page]

APPS.ECE_CDMO_TRX_NUMBER_V references the following:

APPS: ECE_TP_DETAILS; ECE_TP_HEADERS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; RA_CUSTOMER_TRX; RA_CUST_TRX_TYPES

APPS.ECE_CDMO_TRX_NUMBER_V is not referenced by any database object