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]

TABLE: PO.RCV_MC_TRANSACTIONS

Object Details

Object Name:	RCV_MC_TRANSACTIONS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.RCV_MC_TRANSACTIONS
Subobject Name:
Status:	VALID

RCV_MC_SHIPMENT_HEADERS is the MRC sub-table for RCV_SHIPMENT_HEADERS. It stores currency related information about shipment and receipt headers for each reporting Set of Books associated with the parent record in RCV_SHIPMENT_HEADERS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_MC_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
TRANSACTION_ID	NUMBER	(15)	Yes	Receipt transaction identifier
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Conversion type for the exchange rate
CURRENCY_CONVERSION_DATE	DATE			Conversion date for the exchange rate
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate used to convert the transactional currency amount to reporting currency amount

Query Text

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


SELECT SET_OF_BOOKS_ID
,      TRANSACTION_ID
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
FROM PO.RCV_MC_TRANSACTIONS;

Dependencies

[top of page]

PO.RCV_MC_TRANSACTIONS does not reference any database object

PO.RCV_MC_TRANSACTIONS is referenced by following:

PO: RCV_MC_TRANSACTIONS#