[Home] [Help] [Dependency Information]

VIEW: APPS.RA_CUSTOMER_TRX_RA_V

Object Details

Object Name:	RA_CUSTOMER_TRX_RA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.RA_CUSTOMER_TRX_RA_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
,      OLD_TRX_NUMBER
,      CT_MODEL_TRX_NUMBER
,      TRX_DATE
,      PREVIOUS_CUSTOMER_TRX_ID
,      INITIAL_CUSTOMER_TRX_ID
,      RELATED_BATCH_SOURCE_ID
,      RELATED_CUSTOMER_TRX_ID
,      CUST_TRX_TYPE_ID
,      BATCH_ID
,      BATCH_SOURCE_ID
,      REASON_CODE
,      TERM_ID
,      PRIMARY_SALESREP_ID
,      AGREEMENT_ID
,      CREDIT_METHOD_FOR_RULES
,      CREDIT_METHOD_FOR_INSTALLMENTS
,      RECEIPT_METHOD_ID
,      INVOICING_RULE_ID
,      SHIP_VIA
,      FOB_POINT
,      FINANCE_CHARGES
,      COMPLETE_FLAG
,      CUSTOMER_BANK_ACCOUNT_ID
,      RECURRED_FROM_TRX_NUMBER
,      STATUS_TRX
,      DEFAULT_TAX_EXEMPT_FLAG
,      SOLD_TO_CUSTOMER_ID
,      SOLD_TO_SITE_USE_ID
,      SOLD_TO_CONTACT_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      REMIT_TO_ADDRESS_ID
,      INVOICE_CURRENCY_CODE
,      CREATED_FROM
,      SET_OF_BOOKS_ID
,      PRINTING_ORIGINAL_DATE
,      PRINTING_LAST_PRINTED
,      PRINTING_OPTION
,      PRINTING_COUNT
,      PRINTING_PENDING
,      LAST_PRINTED_SEQUENCE_NUM
,      PURCHASE_ORDER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      CUSTOMER_REFERENCE
,      CUSTOMER_REFERENCE_DATE
,      COMMENTS
,      INTERNAL_NOTES
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      TERRITORY_ID
,      END_DATE_COMMITMENT
,      START_DATE_COMMITMENT
,      ORIG_SYSTEM_BATCH_NAME
,      SHIP_DATE_ACTUAL
,      WAYBILL_NUMBER
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      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
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      DEFAULT_USSGL_TRANSACTION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      RAC_BILL_TO_CUSTOMER_NAME
,      RAC_BILL_TO_CUSTOMER_NUM
,      BS_BATCH_SOURCE_NAME
,      BS_AUTO_TRX_NUMBERING_FLAG
,      BS_COPY_DOC_NUMBER_FLAG
,      CTT_TYPE_NAME
,      CTT_CLASS
,      CTT_POST_TO_GL_FLAG
,      CTT_OPEN_RECEIVABLES_FLAG
,      CTT_ALLOW_FREIGHT_FLAG
,      CTT_CREATION_SIGN
,      CTT_ALLOW_OVERAPPLICATION_FLAG
,      CTT_NATURAL_APP_ONLY_FLAG
,      CTT_TAX_CALCULATION_FLAG
,      CTT_DEFAULT_STATUS
,      CTT_DEFAULT_TERM
,      CTT_DEFAULT_PRINTING_OPTION
,      RULES_FLAG
,      PRINTED_FLAG
,      CM_AGAINST_TRX_FLAG
,      CUSTOMER_STATUS
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      BS_BATCH_SOURCE_TYPE
,      ORG_ID
,      LEGAL_ENTITY_ID
FROM APPS.RA_CUSTOMER_TRX_RA_V;

Dependencies

[top of page]

APPS

HZ_CUST_ACCOUNTS

HZ_PARTIES

RA_BATCH_SOURCES_ALL

RA_CUSTOMER_TRX

RA_CUST_TRX_TYPES_ALL

APPS.RA_CUSTOMER_TRX_RA_V is not referenced by any database object