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

TABLE: GML.PO_BPOS_HDR_EFC

Object Details
Object Name: PO_BPOS_HDR_EFC
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.PO_BPOS_HDR_EFC
Subobject Name:
Status: VALID


Shadow table of PO_BPOS_HDR for EFC migration.
Stores the original values of columns of PO_BPOS_HDR that are to be
converted to Euro currency as a part of EFC migration. The table
consists of the primary key columns of PO_BPOS_HDR and only the columns
that are actually converted to Euro currency.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BPO_ID NUMBER
Yes Unique surrogate.
CONTRACT_EXCHANGE_RATE NUMBER
Yes Home/contract_currency exchange rate.
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books ID
Query Text

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


SELECT BPO_ID
,      CONTRACT_EXCHANGE_RATE
,      SET_OF_BOOKS_ID
FROM GML.PO_BPOS_HDR_EFC;

Dependencies

[top of page]

GML.PO_BPOS_HDR_EFC does not reference any database object

GML.PO_BPOS_HDR_EFC is referenced by following:

SchemaAPPS
SynonymPO_BPOS_HDR_EFC