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

TABLE: INV.MTL_MATERIAL_TRANSACTIONS_EFC

Object Details
Object Name: MTL_MATERIAL_TRANSACTIONS_EFC
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_MATERIAL_TRANSACTIONS_EFC
Subobject Name:
Status: VALID


MTL_MATERIAL_TRANSACTIONS_EFC is used exclusively as an archive table
for the "Euro as a functional currency" project. It mirrors the table
MTL_MATERIAL_TRANSACTIONS prior to conversion to the euro currency.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSPORTATION_COST NUMBER

Transportation Cost
TRANSACTION_ID NUMBER
Yes Transaction Identifier
NEW_COST NUMBER

New Cost
ACTUAL_COST NUMBER

Actual Cost
PRIOR_COST NUMBER

Prior Cost
ENCUMBRANCE_AMOUNT NUMBER

Encumbrance Amount
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
VARIANCE_AMOUNT NUMBER

Variance Amount
TRANSFER_COST NUMBER

Transfer Cost
TRANSACTION_COST NUMBER

Transaction Cost
SET_OF_BOOKS_ID NUMBER

Set Of Books Identifier
Query Text

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


SELECT TRANSPORTATION_COST
,      TRANSACTION_ID
,      NEW_COST
,      ACTUAL_COST
,      PRIOR_COST
,      ENCUMBRANCE_AMOUNT
,      CURRENCY_CONVERSION_RATE
,      VARIANCE_AMOUNT
,      TRANSFER_COST
,      TRANSACTION_COST
,      SET_OF_BOOKS_ID
FROM INV.MTL_MATERIAL_TRANSACTIONS_EFC;

Dependencies

[top of page]

INV.MTL_MATERIAL_TRANSACTIONS_EFC does not reference any database object

INV.MTL_MATERIAL_TRANSACTIONS_EFC is referenced by following:

SchemaINV
ViewMTL_MATERIAL_TRANSACTIONS_EFC#