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

Object Details

Object Name:	XTR_AR_ORIG_TRX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_AR_ORIG_TRX_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	Mandatory
CUSTOMER_TRX_ID	NUMBER	(15)	Yes
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes
BATCH_SOURCE_ID	NUMBER	(15)
SOURCE_NAME	VARCHAR2	(50)
CUST_TRX_TYPE_ID	NUMBER	(15)	Yes
TRX_TYPE_NAME	VARCHAR2	(20)
ORG_ID	NUMBER	(15)
ORG_NAME	VARCHAR2	(240)	Yes
CUSTOMER_ID	NUMBER	(15)
CUSTOMER_NAME	VARCHAR2	(360)
COMPANY_CODE	VARCHAR2	(7)	Yes
TRX_DATE	DATE		Yes
TRX_NUMBER	VARCHAR2	(20)	Yes
CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT	NUMBER
DUE_DATE	DATE		Yes

Query Text

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


SELECT CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      BATCH_SOURCE_ID
,      SOURCE_NAME
,      CUST_TRX_TYPE_ID
,      TRX_TYPE_NAME
,      ORG_ID
,      ORG_NAME
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      COMPANY_CODE
,      TRX_DATE
,      TRX_NUMBER
,      CURRENCY_CODE
,      AMOUNT
,      DUE_DATE
FROM APPS.XTR_AR_ORIG_TRX_V;

Dependencies

[top of page]

APPS.XTR_AR_ORIG_TRX_V references the following:

APPS: AR_PAYMENT_SCHEDULES_ALL; GL_LEDGER_LE_V; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS; HZ_PARTIES; RA_BATCH_SOURCES_ALL; RA_CUSTOMER_TRX_ALL; RA_CUST_TRX_TYPES_ALL; XTR_PARTIES_V; XTR_USER_ACCESS - show dependent code

APPS.XTR_AR_ORIG_TRX_V is not referenced by any database object