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

TABLE: INV.MTL_CST_ACTUAL_COST_DETAIL_EFC

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


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


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization Identifier
TRANSACTION_ID NUMBER
Yes Transaction Identifier
NEW_COST NUMBER

New Cost
ACTUAL_COST NUMBER

Actual Cost
PRIOR_COST NUMBER

Prior Cost
PAYBACK_VARIANCE_AMOUNT NUMBER

Payback Variance Amount
LAYER_ID NUMBER
Yes Layer Identifier
LEVEL_TYPE NUMBER
Yes Level Type
VARIANCE_AMOUNT NUMBER

Variance Amount
COST_ELEMENT_ID NUMBER
Yes Cost Element Identifier
TRANSACTION_ACTION_ID NUMBER
Yes Transaction Action Identifier
SET_OF_BOOKS_ID NUMBER

Set Of Books Identifier
Query Text

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


SELECT ORGANIZATION_ID
,      TRANSACTION_ID
,      NEW_COST
,      ACTUAL_COST
,      PRIOR_COST
,      PAYBACK_VARIANCE_AMOUNT
,      LAYER_ID
,      LEVEL_TYPE
,      VARIANCE_AMOUNT
,      COST_ELEMENT_ID
,      TRANSACTION_ACTION_ID
,      SET_OF_BOOKS_ID
FROM INV.MTL_CST_ACTUAL_COST_DETAIL_EFC;

Dependencies

[top of page]

INV.MTL_CST_ACTUAL_COST_DETAIL_EFC does not reference any database object

INV.MTL_CST_ACTUAL_COST_DETAIL_EFC is referenced by following:

SchemaINV
ViewMTL_CST_ACTUAL_COST_DETAIL_EF#