[Home] [Help] [Dependency Information]

VIEW: APPS.RA_CUSTOMER_TRX_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_DATE
,      TERM_DUE_DATE
,      COMPLETE_FLAG
,      STATUS_TRX
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      INVOICE_CURRENCY_CODE
,      PURCHASE_ORDER
,      INTERNAL_NOTES
,      SHIP_DATE_ACTUAL
,      WAYBILL_NUMBER
,      DOC_SEQUENCE_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      CT_COMMITMENT_NUMBER
,      CT_PREV_TRX_NUMBER
,      BS_PREV_SOURCE_NAME
,      CT_RELATED_TRX_NUMBER
,      RAC_BILL_TO_CUSTOMER_NAME
,      RAC_BILL_TO_CUSTOMER_NUM
,      SU_BILL_TO_LOCATION
,      RAA_BILL_TO_ADDRESS1
,      RAA_BILL_TO_ADDRESS2
,      RAA_BILL_TO_ADDRESS3
,      RAC_SHIP_TO_CUSTOMER_NAME
,      RAC_SHIP_TO_CUSTOMER_NUM
,      SU_SHIP_TO_LOCATION
,      RAA_SHIP_TO_ADDRESS1
,      RAA_SHIP_TO_ADDRESS2
,      RAA_SHIP_TO_ADDRESS3
,      BS_BATCH_SOURCE_NAME
,      CTT_TYPE_NAME
,      CTT_CLASS
,      RAS_PRIMARY_SALESREP_NAME
,      RAT_TERM_NAME
,      SOA_AGREEMENT_NAME
,      OF_SHIP_VIA_NAME
,      OF_ORGANIZATION_ID
,      CT_REFERENCE
,      GD_GL_DATE
,      CTT_OPEN_RECEIVABLES_FLAG
,      BATCH_SOURCE_ID
FROM APPS.RA_CUSTOMER_TRX_V;

Dependencies

[top of page]

APPS

ARH_ADDR_PKG - show dependent code

ARPT_SQL_FUNC_UTIL - show dependent code

FND_TERRITORIES_VL

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES

HZ_CUST_SITE_USES

HZ_LOCATIONS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

ORG_FREIGHT

RA_BATCH_SOURCES

RA_CUSTOMER_TRX

RA_CUST_TRX_LINE_GL_DIST

RA_CUST_TRX_TYPES

APPS

IGI_EXP_AVAILABLE_TRX_V

IGI_EXP_DU_LINES_V