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

Object Details

Object Name:	AR_DOCUMENT_TRANSFERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_DOCUMENT_TRANSFERS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
TRX_CLASS	VARCHAR2	(20)
TRX_TYPE_ID	NUMBER	(15)
CUST_CLASS	VARCHAR2	(30)	Customer class indentifier
CUST_ACCOUNT_ID	NUMBER	(15)	Customer account identifier
TRX_DATE	DATE
TRX_NUMBER	VARCHAR2	(20)
SOURCE_ID	NUMBER	(15)
SOURCE_ID_COLUMN	CHAR	(15)
SOURCE_TABLE	CHAR	(15)
TP_SOURCE_TABLE	CHAR	(14)
TP_SOURCE_ID	NUMBER	(15)
ECX_TRX_TYPE	VARCHAR2	(100)
ECX_TRX_SUBTYPE	VARCHAR2	(100)
ECX_PARTY_TYPE	VARCHAR2	(30)
EVENT_NAME	CHAR	(39)

Query Text

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


SELECT TRX_CLASS
,      TRX_TYPE_ID
,      CUST_CLASS
,      CUST_ACCOUNT_ID
,      TRX_DATE
,      TRX_NUMBER
,      SOURCE_ID
,      SOURCE_ID_COLUMN
,      SOURCE_TABLE
,      TP_SOURCE_TABLE
,      TP_SOURCE_ID
,      ECX_TRX_TYPE
,      ECX_TRX_SUBTYPE
,      ECX_PARTY_TYPE
,      EVENT_NAME
FROM APPS.AR_DOCUMENT_TRANSFERS_V;

Dependencies

[top of page]

APPS.AR_DOCUMENT_TRANSFERS_V references the following:

APPS: AR_DOCUMENT_TRANSFERS; ECX_TP_DETAILS_V; ECX_TP_HEADERS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES; HZ_CUST_SITE_USES; RA_CUSTOMER_TRX; RA_CUST_TRX_TYPES

APPS.AR_DOCUMENT_TRANSFERS_V is referenced by following:

APPS: AR_EXTRACT_DOCUMENT - show dependent code