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

TABLE: INV.MTL_PAC_ACTUAL_COST_DETAIL_EFC

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


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


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

New Buy Cost
PRIOR_MAKE_COST NUMBER

Prior Make Cost
COST_GROUP_ID NUMBER
Yes Cost Group Identifier
ACTUAL_COST NUMBER

Actual Cost
NEW_COST NUMBER

New Cost
PAC_PERIOD_ID NUMBER
Yes Period Actual Costing Period Identifier
TRANSACTION_ID NUMBER
Yes Transaction Identifier
PRIOR_BUY_COST NUMBER

Prior Buy Cost
PRIOR_COST NUMBER

Prior Cost
LEVEL_TYPE NUMBER
Yes Level Type
VARIANCE_AMOUNT NUMBER

Variance Amount
COST_ELEMENT_ID NUMBER
Yes Cost Element Identifier
NEW_MAKE_COST NUMBER

New Make Cost
SET_OF_BOOKS_ID NUMBER

Set Of Books Identifier
Query Text

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


SELECT NEW_BUY_COST
,      PRIOR_MAKE_COST
,      COST_GROUP_ID
,      ACTUAL_COST
,      NEW_COST
,      PAC_PERIOD_ID
,      TRANSACTION_ID
,      PRIOR_BUY_COST
,      PRIOR_COST
,      LEVEL_TYPE
,      VARIANCE_AMOUNT
,      COST_ELEMENT_ID
,      NEW_MAKE_COST
,      SET_OF_BOOKS_ID
FROM INV.MTL_PAC_ACTUAL_COST_DETAIL_EFC;

Dependencies

[top of page]

INV.MTL_PAC_ACTUAL_COST_DETAIL_EFC does not reference any database object

INV.MTL_PAC_ACTUAL_COST_DETAIL_EFC is referenced by following:

SchemaINV
ViewMTL_PAC_ACTUAL_COST_DETAIL_EF#