DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.RA_CUSTOMER_TRX_MRC_V

Object Details
Object Name: RA_CUSTOMER_TRX_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.RA_CUSTOMER_TRX_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)
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)
Identifies the template id of the presented bill
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
,      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_MRC_V;

Dependencies

[top of page]

APPS.RA_CUSTOMER_TRX_MRC_V references the following:

SchemaAPPS
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_MC_CUSTOMER_TRX

APPS.RA_CUSTOMER_TRX_MRC_V is not referenced by any database object