[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RA_CUSTOMER_TRX_CM_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AR.RA_CUSTOMER_TRX_CM_V
|
| Subobject Name: | |
| Status: | VALID |
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.
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CUSTOMER_TRX_ID
, TRX_NUMBER
, OLD_TRX_NUMBER
, TRX_DATE
, TERM_DUE_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
, 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_ADDRESS_ID
, BILL_TO_CONTACT_ID
, BILL_TO_TAXPAYER_ID
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_ADDRESS_ID
, SHIP_TO_CONTACT_ID
, SHIP_TO_TAXPAYER_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
, CT_COMMITMENT_TRX_DATE
, GD_COMMITMENT_GL_DATE
, ORIG_SYSTEM_BATCH_NAME
, SHIP_DATE_ACTUAL
, WAYBILL_NUMBER
, FOB_POINT
, SHIP_VIA
, 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
, DEFAULT_USSGL_TRX_CODE_CONTEXT
, DEFAULT_USSGL_TRANSACTION_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, POST_REQUEST_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, POSTING_CONTROL_ID
, RA_POST_LOOP_NUMBER
, CT_COMMITMENT_NUMBER
, 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
, RACO_BILL_TO_CONTACT_NAME
, 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
, RACO_SHIP_TO_CONTACT_NAME
, RAC_SOLD_TO_CUSTOMER_NAME
, RAC_SOLD_TO_CUSTOMER_NUM
, RAC_PAYING_CUSTOMER_NAME
, RAC_PAYING_CUSTOMER_NUM
, SU_PAYING_CUSTOMER_LOCATION
, RAA_CONCAT_REMIT_TO_ADDRESS
, RAA_REMIT_TO_ADDRESS1
, RAA_REMIT_TO_ADDRESS2
, RAA_REMIT_TO_ADDRESS3
, APBA_BANK_ACCOUNT_NAME
, APBA_BANK_ACCOUNT_NUM
, APB_CUSTOMER_BANK_NAME
, APB_CUSTOMER_BANK_BRANCH_NAME
, ARM_RECEIPT_METHOD_NAME
, BS_BATCH_SOURCE_NAME
, BS_COPY_DOC_NUMBER_FLAG
, BS_COPY_INV_TIDFF_TO_CM_FLAG
, BS_BATCH_SOURCE_TYPE
, RAB_BATCH_OPTION_DB
, RAB_BATCH_NAME
, RAB_BATCH_DATE
, RAB_GL_DATE
, RAB_BATCH_SOURCE_ID
, CTT_TYPE_NAME
, CTT_CLASS
, RAS_PRIMARY_SALESREP_NAME
, RAS_PRIMARY_SALESREP_NUM
, RAT_TERM_NAME
, SOA_AGREEMENT_NAME
, AL_REASON_MEANING
, CT_REFERENCE
, GD_GL_DATE
, GDCT_USER_EXCHANGE_RATE_TYPE
, AL_STATUS_MEANING
, CT_INVOICE_FOR_CB
, PS_DISPUTE_AMOUNT
, PS_DISPUTE_DATE
, REV_RECOG_RUN_FLAG
, POSTED_FLAG
, SELECTED_FOR_PAYMENT_FLAG
, ACTIVITY_FLAG
, RULES_FLAG
, PRINTED_FLAG
, CTT_POST_TO_GL
, CTT_OPEN_RECEIVABLES_FLAG
, CTT_CREATION_SIGN
, CTT_ALLOW_FREIGHT_FLAG
, CTT_ALLOW_OVERAPP_FLAG
, CTT_NATURAL_APP_ONLY_FLAG
, ATCHMT_FLAG
, GLOBAL_ATTRIBUTE_CATEGORY
, 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_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30
, DEFAULT_REFERENCE
FROM APPS.RA_CUSTOMER_TRX_CM_V;
APPS
ARPT_SQL_FUNC_UTIL
- show dependent code
AR_LOOKUPS
AR_RECEIPT_METHODS
FND_ATTACHMENT_UTIL_PKG
- show dependent code
GL_DAILY_CONVERSION_TYPES
HZ_CUST_ACCOUNTS
HZ_CUST_ACCOUNT_ROLES
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_LOCATIONS
HZ_PARTIES
HZ_PARTY_SITES
HZ_RELATIONSHIPS
RA_BATCHES_ALL
RA_BATCH_SOURCES_ALL
RA_CUSTOMER_TRX
RA_CUSTOMER_TRX_ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_TYPES_ALL
RA_SALESREPS
RA_TERMS
SO_AGREEMENTS
APPS.RA_CUSTOMER_TRX_CM_V is not referenced by any database object
|
|
|
|