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: GML.OP_ORDR_DTL_EFC

Object Details

Object Name:	OP_ORDR_DTL_EFC
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_ORDR_DTL_EFC
Subobject Name:
Status:	VALID

Shadow table of OP_ORDR_DTL for EFC migration.
Stores the original values of columns of OP_ORDR_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_ORDR_DTL and only the columns
that are actually converted to Euro currency.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER		Yes	Surrogate ID for sles order line
BASE_CURRENCY	VARCHAR2	(4)	Yes	Currency of organization identified with the order
EXCHANGE_RATE	NUMBER		Yes	Exchange rate between billing currency and base currency
SET_OF_BOOKS_ID	NUMBER		Yes	Surrogate ID for set of books

Query Text

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


SELECT LINE_ID
,      BASE_CURRENCY
,      EXCHANGE_RATE
,      SET_OF_BOOKS_ID
FROM GML.OP_ORDR_DTL_EFC;

Dependencies

[top of page]

GML.OP_ORDR_DTL_EFC does not reference any database object

GML.OP_ORDR_DTL_EFC is referenced by following:

APPS: OP_ORDR_DTL_EFC