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

TABLE: PO.PO_MC_HEADERS

Object Details
Object Name: PO_MC_HEADERS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_MC_HEADERS
Subobject Name:
Status: VALID


PO_MC_HEADERS is the MRC sub-table for PO_HEADERS_ALL. It stores currency information about purchase orders for each reporting Set of Books associated with the parent record in PO_HEADERS_ALL.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_MC_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_HEADER_ID
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
PO_HEADER_ID NUMBER
Yes Document header identifier
RATE_TYPE VARCHAR2 (30)
Conversion type for the exchange rate
RATE_DATE DATE

Conversion date for the exchange rate
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
,      PO_HEADER_ID
,      RATE_TYPE
,      RATE_DATE
,      RATE
FROM PO.PO_MC_HEADERS;

Dependencies

[top of page]

PO.PO_MC_HEADERS does not reference any database object

PO.PO_MC_HEADERS is referenced by following:

SchemaPO
ViewPO_MC_HEADERS#