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_ALL_MRC_V

Object Details

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

View Type

A multiple reporting currency view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Invoice identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Conversion type used to convert foreign currency transactions
EXCHANGE_DATE	DATE			Date that determines currency conversion rate to convert transaction currency amounts into reporting currency amounts
EXCHANGE_RATE	NUMBER			Currency conversion rate used to convert the transactional currency amount to reporting currency amount
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction number
CUST_TRX_TYPE_ID	NUMBER	(15)	Yes	Transaction type identifier
TRX_DATE	DATE		Yes	Invoice date
BILL_TO_CONTACT_ID	NUMBER	(15)		Contact identifier to send bills to
BATCH_ID	NUMBER	(15)		Batch identifier
BATCH_SOURCE_ID	NUMBER	(15)		Batch source identifier
REASON_CODE	VARCHAR2	(30)		Reason code identifier
SOLD_TO_CUSTOMER_ID	NUMBER	(15)		Customer identifier
SOLD_TO_CONTACT_ID	NUMBER	(15)		Sold to contact identifier
SOLD_TO_SITE_USE_ID	NUMBER	(15)		Sold to site use identifier
BILL_TO_CUSTOMER_ID	NUMBER	(15)		Customer identifier
BILL_TO_SITE_USE_ID	NUMBER	(15)		Site use identifier billed
SHIP_TO_CUSTOMER_ID	NUMBER	(15)		Customer identifier
SHIP_TO_CONTACT_ID	NUMBER	(15)		Contact identifier for shipments
SHIP_TO_SITE_USE_ID	NUMBER	(15)		Site identifier for the shipments
SHIPMENT_ID	NUMBER	(15)		Not currently used
REMIT_TO_ADDRESS_ID	NUMBER	(15)		Remit to address identifier
TERM_ID	NUMBER	(15)		Payment term identifier
TERM_DUE_DATE	DATE			Due date of the first payment
PREVIOUS_CUSTOMER_TRX_ID	NUMBER	(15)		Identifier for invoice credited
PRIMARY_SALESREP_ID	NUMBER	(15)		Sale rep given primary credit for the transaction
PRINTING_ORIGINAL_DATE	DATE			Date the first installment is printed
PRINTING_LAST_PRINTED	DATE			Last date any installment was printed
PRINTING_OPTION	VARCHAR2	(20)		Revenue Accounting lookup code for INVOICE_PRINT_OPTIONS
PRINTING_COUNT	NUMBER	(15)		This column shows the number of times this invoice was printed. If there are multiple installments for this invoice, this will increment once for every installment that was printed.
PRINTING_PENDING	VARCHAR2	(1)		Indicates if this invoice is waiting to be printed. Y for yes, N otherwise.
PURCHASE_ORDER	VARCHAR2	(50)		Purchase order
PURCHASE_ORDER_REVISION	VARCHAR2	(50)		Purchase order revision
PURCHASE_ORDER_DATE	DATE			Date of purchase order
CUSTOMER_REFERENCE	VARCHAR2	(30)		Customer identifier from foreign system
CUSTOMER_REFERENCE_DATE	DATE			Additional comments
COMMENTS	VARCHAR2	(1760)		Stores comments entered in the Transactions workbench. Value can be printed on an invoice using the Print Invoice view.
INTERNAL_NOTES	VARCHAR2	(240)		Stores the special instruction entered in the Transactions workbench. Value can be printed on an invoice with using the Print Invoice View
TERRITORY_ID	NUMBER	(15)		Territory identifier
INVOICE_CURRENCY_CODE	VARCHAR2	(15)		Invoice currency
INITIAL_CUSTOMER_TRX_ID	NUMBER	(15)		Identifier of a related commitment
AGREEMENT_ID	NUMBER	(15)		Agreement identifier
END_DATE_COMMITMENT	DATE			Date a commitment becomes active
START_DATE_COMMITMENT	DATE			Date a commitment becomes inactive
LAST_PRINTED_SEQUENCE_NUM	NUMBER	(15)		Last installment printed
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ORIG_SYSTEM_BATCH_NAME	VARCHAR2	(40)		Batch identifier from foreign system
POST_REQUEST_ID	NUMBER	(15)		No longer used
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
FINANCE_CHARGES	VARCHAR2	(1)		Indicates if finance charges are included. Y for yes, N otherwise.
COMPLETE_FLAG	VARCHAR2	(1)	Yes	Indicates if the invoice is complete. Y for yes, N otherwise.
POSTING_CONTROL_ID	NUMBER	(15)		Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted
BILL_TO_ADDRESS_ID	NUMBER	(15)		Identifies the bill-to address
RA_POST_LOOP_NUMBER	NUMBER	(15)		No longer used
SHIP_TO_ADDRESS_ID	NUMBER	(15)		Identifies the ship-to address
CREDIT_METHOD_FOR_RULES	VARCHAR2	(30)		Rule to use when crediting invoice account assignments for invoices that use invoicing and accounting rules
CREDIT_METHOD_FOR_INSTALLMENTS	VARCHAR2	(30)		Rule to use when crediting the payment schedules of split term transactions
RECEIPT_METHOD_ID	NUMBER	(15)		Receipt method identifier
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
RELATED_CUSTOMER_TRX_ID	NUMBER	(15)		Related transaction identifier
INVOICING_RULE_ID	NUMBER	(15)		Invoicing Rule identifier
SHIP_VIA	VARCHAR2	(30)		Ship via
SHIP_DATE_ACTUAL	DATE			Ship date
WAYBILL_NUMBER	VARCHAR2	(50)		Waybill number
FOB_POINT	VARCHAR2	(30)		Free on Board point
CUSTOMER_BANK_ACCOUNT_ID	NUMBER	(15)		Identifies the customer bank account
INTERFACE_HEADER_ATTRIBUTE1	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE2	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE3	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE4	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE5	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE6	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE7	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE8	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_CONTEXT	VARCHAR2	(30)		Interface header context
DEFAULT_USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)		Default context value for the USSGL Transaction Code Flexfield
INTERFACE_HEADER_ATTRIBUTE10	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE11	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE12	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE13	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE14	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE15	VARCHAR2	(150)		Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE9	VARCHAR2	(150)		Interface header attribute value
DEFAULT_USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Default value for the USSGL Transaction Code Flexfield
RECURRED_FROM_TRX_NUMBER	VARCHAR2	(20)		Model transaction for this record
STATUS_TRX	VARCHAR2	(30)		The status of the transaction
DOC_SEQUENCE_ID	NUMBER	(15)		Identifies the document sequence
DOC_SEQUENCE_VALUE	NUMBER	(15)		The value of the document sequence
PAYING_CUSTOMER_ID	NUMBER	(15)		This column is required when the RECEIPT_METHOD_ID column is an automatic payment method. Otherwise, this column should be left null.
PAYING_SITE_USE_ID	NUMBER	(15)		This column is required when the RECEIPT_METHOD_ID column is an automatic payment method. Otherwise, this column should be left null.
RELATED_BATCH_SOURCE_ID	NUMBER	(15)		Related batch source identifier
DEFAULT_TAX_EXEMPT_FLAG	VARCHAR2	(1)		This column defaults to the tax exempt flag in RA_CUSTOMER_TRX_LINES_ALL upon manual data entry.
CREATED_FROM	VARCHAR2	(30)	Yes	Populated by code that points to form or program that created this row
ORG_ID	NUMBER	(15)		Organization identifier
WH_UPDATE_DATE	DATE			Date sent to data warehouse
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE21	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE22	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE23	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE24	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE25	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE26	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE27	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE28	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE29	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE30	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
EDI_PROCESSED_FLAG	VARCHAR2	(1)		Indicates if this invoice was processed by EDI. Y for yes, N otherwise.
EDI_PROCESSED_STATUS	VARCHAR2	(10)		Status of the invoice (used by EDI)
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion rate type pairs
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion rate pairs
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion date pairs
ADDRESS_VERIFICATION_CODE	VARCHAR2	(80)		Credit card address verification code returned by Oracle payment server
APPROVAL_CODE	VARCHAR2	(80)		Payment approval code returned by credit card issuer
OLD_TRX_NUMBER	VARCHAR2	(20)		If the transaction batch source option copy document number to transaction number is set to Y, this column stores the old transaction number.
PAYMENT_SERVER_ORDER_NUM	VARCHAR2	(80)		A number that indicates the credit card payment was authorized by Oracle Payment Server.
BR_AMOUNT	NUMBER			The control amount of a bills receivable
BR_UNPAID_FLAG	VARCHAR2	(1)		Indicates if a bills receivable is unpaid. It is Y if the bills receivable is unpaid. Otherwise, it is N.
BR_ON_HOLD_FLAG	VARCHAR2	(1)		Indicates if a bills receivable is on hold. It is Y if the bills receivable is on hold. Otherwise, it is N.
DRAWEE_ID	NUMBER	(15)		Drawee customer identifier for a bills receivable
DRAWEE_CONTACT_ID	NUMBER	(15)		Drawee contact identifier for a bills receivable
DRAWEE_SITE_USE_ID	NUMBER	(15)		Drawee site identifier for a bills receivable
DRAWEE_BANK_ACCOUNT_ID	NUMBER	(15)		Drawee bank account identifier for a bills receivable
REMITTANCE_BANK_ACCOUNT_ID	NUMBER	(15)		Identifies the user bank account for depositing the receipt
OVERRIDE_REMIT_ACCOUNT_FLAG	VARCHAR2	(1)		Indicates if the remittance bank account can be overridden by the remittance selection process. Y for yes, N otherwise.
SPECIAL_INSTRUCTIONS	VARCHAR2	(240)		Special instructions that appear on a bills receivable
REMITTANCE_BATCH_ID	NUMBER	(15)		This is the foreign key to the AR_BATCHES table. It points to the latest approved bills receivable remittance batch used to remit this transaction.
PREPAYMENT_FLAG	VARCHAR2	(1)		Indicates whether this transaction is a prepayment transaction
CT_REFERENCE	VARCHAR2	(150)		Derived Reference Field. Derived from Interface Header attribute based on the batch source
CONTRACT_ID	NUMBER			Identifies the contract from Oracle Contracts Core that is associated with this line
BILL_TEMPLATE_ID	NUMBER	(15)
REVERSED_CASH_RECEIPT_ID	NUMBER	(15)

Query Text

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


SELECT CUSTOMER_TRX_ID
,      SET_OF_BOOKS_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TRX_NUMBER
,      CUST_TRX_TYPE_ID
,      TRX_DATE
,      BILL_TO_CONTACT_ID
,      BATCH_ID
,      BATCH_SOURCE_ID
,      REASON_CODE
,      SOLD_TO_CUSTOMER_ID
,      SOLD_TO_CONTACT_ID
,      SOLD_TO_SITE_USE_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_SITE_USE_ID
,      SHIPMENT_ID
,      REMIT_TO_ADDRESS_ID
,      TERM_ID
,      TERM_DUE_DATE
,      PREVIOUS_CUSTOMER_TRX_ID
,      PRIMARY_SALESREP_ID
,      PRINTING_ORIGINAL_DATE
,      PRINTING_LAST_PRINTED
,      PRINTING_OPTION
,      PRINTING_COUNT
,      PRINTING_PENDING
,      PURCHASE_ORDER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      CUSTOMER_REFERENCE
,      CUSTOMER_REFERENCE_DATE
,      COMMENTS
,      INTERNAL_NOTES
,      TERRITORY_ID
,      INVOICE_CURRENCY_CODE
,      INITIAL_CUSTOMER_TRX_ID
,      AGREEMENT_ID
,      END_DATE_COMMITMENT
,      START_DATE_COMMITMENT
,      LAST_PRINTED_SEQUENCE_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORIG_SYSTEM_BATCH_NAME
,      POST_REQUEST_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FINANCE_CHARGES
,      COMPLETE_FLAG
,      POSTING_CONTROL_ID
,      BILL_TO_ADDRESS_ID
,      RA_POST_LOOP_NUMBER
,      SHIP_TO_ADDRESS_ID
,      CREDIT_METHOD_FOR_RULES
,      CREDIT_METHOD_FOR_INSTALLMENTS
,      RECEIPT_METHOD_ID
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RELATED_CUSTOMER_TRX_ID
,      INVOICING_RULE_ID
,      SHIP_VIA
,      SHIP_DATE_ACTUAL
,      WAYBILL_NUMBER
,      FOB_POINT
,      CUSTOMER_BANK_ACCOUNT_ID
,      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_CONTEXT
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      INTERFACE_HEADER_ATTRIBUTE9
,      DEFAULT_USSGL_TRANSACTION_CODE
,      RECURRED_FROM_TRX_NUMBER
,      STATUS_TRX
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      RELATED_BATCH_SOURCE_ID
,      DEFAULT_TAX_EXEMPT_FLAG
,      CREATED_FROM
,      ORG_ID
,      WH_UPDATE_DATE
,      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
,      GLOBAL_ATTRIBUTE_CATEGORY
,      EDI_PROCESSED_FLAG
,      EDI_PROCESSED_STATUS
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_DATE
,      ADDRESS_VERIFICATION_CODE
,      APPROVAL_CODE
,      OLD_TRX_NUMBER
,      PAYMENT_SERVER_ORDER_NUM
,      BR_AMOUNT
,      BR_UNPAID_FLAG
,      BR_ON_HOLD_FLAG
,      DRAWEE_ID
,      DRAWEE_CONTACT_ID
,      DRAWEE_SITE_USE_ID
,      DRAWEE_BANK_ACCOUNT_ID
,      REMITTANCE_BANK_ACCOUNT_ID
,      OVERRIDE_REMIT_ACCOUNT_FLAG
,      SPECIAL_INSTRUCTIONS
,      REMITTANCE_BATCH_ID
,      PREPAYMENT_FLAG
,      CT_REFERENCE
,      CONTRACT_ID
,      BILL_TEMPLATE_ID
,      REVERSED_CASH_RECEIPT_ID
FROM APPS.RA_CUSTOMER_TRX_ALL_MRC_V;

Dependencies

[top of page]

APPS.RA_CUSTOMER_TRX_ALL_MRC_V references the following:

APPS: RA_CUSTOMER_TRX_ALL; RA_MC_CUSTOMER_TRX

APPS.RA_CUSTOMER_TRX_ALL_MRC_V is referenced by following:

APPS: AR_AEL_SL_ADJ_MRC_V; AR_AEL_SL_INV_MRC_V; AR_AEL_SL_REC_MRC_V