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

TABLE: GML.OP_PRSL_DTL_EFC

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


Shadow table of OP_PRSL_DTL for EFC migration.
Stores the original values of columns of OP_PRSL_DTL that are to be
converted to Euro currency as a part of EFC migration. The table
consists of the primary key columns of OP_PRSL_DTL 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
PRESALES_ORDLINE_ID NUMBER (10) Yes Surrogate ID for order line
EXCHANGE_RATE NUMBER
Yes Exchange rate
SET_OF_BOOKS_ID NUMBER (15) Yes Surrogate ID for set of books
Query Text

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


SELECT PRESALES_ORDLINE_ID
,      EXCHANGE_RATE
,      SET_OF_BOOKS_ID
FROM GML.OP_PRSL_DTL_EFC;

Dependencies

[top of page]

GML.OP_PRSL_DTL_EFC does not reference any database object

GML.OP_PRSL_DTL_EFC is referenced by following:

SchemaGML
ViewOP_PRSL_DTL_EFC#