[Home] [Help] [Dependency Information]
Object Name: | MTL_MATERIAL_TRANSACTIONS_EFC |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.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.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
INV.MTL_MATERIAL_TRANSACTIONS_EFC does not reference any database object
INV.MTL_MATERIAL_TRANSACTIONS_EFC is referenced by following:
|
|
|