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_SHIPMENT_HEADERS

Object Details

Object Name:	RCV_MC_SHIPMENT_HEADERS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.RCV_MC_SHIPMENT_HEADERS
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_SHIPMENT_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
SHIPMENT_HEADER_ID	NUMBER	(15)	Yes	Receipt header identifier
CONVERSION_RATE_TYPE	VARCHAR2	(30)		Conversion type for the exchange rate
CONVERSION_DATE	DATE			Conversion date for the exchange rate
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
,      SHIPMENT_HEADER_ID
,      CONVERSION_RATE_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
FROM PO.RCV_MC_SHIPMENT_HEADERS;

Dependencies

[top of page]

PO.RCV_MC_SHIPMENT_HEADERS does not reference any database object

PO.RCV_MC_SHIPMENT_HEADERS is referenced by following:

PO: RCV_MC_SHIPMENT_HEADERS#