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

Object Details

Object Name:	RA_CUSTOMER_TRX_ALL2_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
CLAIM_NUMBER	VARCHAR2	(150)
CUSTOMER_REFERENCE	VARCHAR2	(150)
CUSTOMER_REASON	VARCHAR2	(150)
CLAIM_REASON	VARCHAR2	(150)
BILLING_PARTY_ID	VARCHAR2	(150)
BILLING_SITE_USE_ID	VARCHAR2	(150)
BILLING_INTERFACE_REQUEST_ID	VARCHAR2	(150)
BILLING_PERIOD	VARCHAR2	(150)
BILL_TO_PARTY_ID	VARCHAR2	(150)
PROJECT_NUMBER	VARCHAR2	(150)
DRAFT_INVOICE_NUMBER	VARCHAR2	(150)
AGREEMENT_NUMBER	VARCHAR2	(150)
PROJECT_ORGANIZATION	VARCHAR2	(150)
PROJECT_MANAGER	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(785)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      CLAIM_NUMBER
,      CUSTOMER_REFERENCE
,      CUSTOMER_REASON
,      CLAIM_REASON
,      BILLING_PARTY_ID
,      BILLING_SITE_USE_ID
,      BILLING_INTERFACE_REQUEST_ID
,      BILLING_PERIOD
,      BILL_TO_PARTY_ID
,      PROJECT_NUMBER
,      DRAFT_INVOICE_NUMBER
,      AGREEMENT_NUMBER
,      PROJECT_ORGANIZATION
,      PROJECT_MANAGER
,      CONCATENATED_SEGMENTS
FROM APPS.RA_CUSTOMER_TRX_ALL2_DFV;

Dependencies

[top of page]

APPS.RA_CUSTOMER_TRX_ALL2_DFV references the following:

APPS: RA_CUSTOMER_TRX_ALL

APPS.RA_CUSTOMER_TRX_ALL2_DFV is not referenced by any database object