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: INV.MTL_PAC_ACTUAL_COST_DETAILS

Object Details

Object Name:	MTL_PAC_ACTUAL_COST_DETAILS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_PAC_ACTUAL_COST_DETAILS
Subobject Name:
Status:	VALID

MTL_PAC_ACTUAL_COST_DETAILS stores the elemental cost for a given transaction in a period.
The actual cost is the sum of transaction cost (for example, acquisition cost) and material overhead. Using the actual cost and prior cost, the new cost for that item is calculated.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_PAC_ACTUAL_COST_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID PAC_PERIOD_ID COST_GROUP_ID COST_ELEMENT_ID LEVEL_TYPE
MTL_PAC_ACTUAL_COST_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAC_PERIOD_ID COST_GROUP_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COST_GROUP_ID	NUMBER		Yes	Cost group identifier
TRANSACTION_ID	NUMBER		Yes	Transaction identifier
PAC_PERIOD_ID	NUMBER		Yes	Period identifier
COST_TYPE_ID	NUMBER		Yes	Cost type identifier
COST_ELEMENT_ID	NUMBER		Yes	Cost element identifier
LEVEL_TYPE	NUMBER		Yes	Level type
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
COST_LAYER_ID	NUMBER		Yes	Cost layer identifier
PRIOR_COST	NUMBER			Prior average cost
ACTUAL_COST	NUMBER			Actual cost of the transaction
NEW_COST	NUMBER			New average cost
PRIOR_BUY_COST	NUMBER			Prior buy cost
PRIOR_MAKE_COST	NUMBER			Prior make cost
NEW_BUY_COST	NUMBER			New buy cost
NEW_MAKE_COST	NUMBER			New make cost
USER_ENTERED	VARCHAR2	(1)	Yes	Specifies whether this row is entered by the user or cost processor
INSERTION_FLAG	VARCHAR2	(1)	Yes	Used to determine which cost detail rows to insert in CST_LAYER_COST_DETAILS
TRANSACTION_COSTED_DATE	DATE			Transaction date
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
REQUEST_ID	NUMBER			Extended Who column
PROGRAM_APPLICATION_ID	NUMBER			Extended Who column
PROGRAM_ID	NUMBER			Extended Who column
PROGRAM_UPDATE_DATE	DATE			Extended Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
VARIANCE_AMOUNT	NUMBER			Variance amount
WIP_VARIANCE	NUMBER			Variance for WIP related Inventory transaction originating from BOM based WIP requirements
TXN_CATEGORY	NUMBER			Transaction category identifier
ONHAND_VARIANCE_AMOUNT	NUMBER			Onhand variance amount

Query Text

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


SELECT COST_GROUP_ID
,      TRANSACTION_ID
,      PAC_PERIOD_ID
,      COST_TYPE_ID
,      COST_ELEMENT_ID
,      LEVEL_TYPE
,      INVENTORY_ITEM_ID
,      COST_LAYER_ID
,      PRIOR_COST
,      ACTUAL_COST
,      NEW_COST
,      PRIOR_BUY_COST
,      PRIOR_MAKE_COST
,      NEW_BUY_COST
,      NEW_MAKE_COST
,      USER_ENTERED
,      INSERTION_FLAG
,      TRANSACTION_COSTED_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VARIANCE_AMOUNT
,      WIP_VARIANCE
,      TXN_CATEGORY
,      ONHAND_VARIANCE_AMOUNT
FROM INV.MTL_PAC_ACTUAL_COST_DETAILS;

Dependencies

[top of page]

INV.MTL_PAC_ACTUAL_COST_DETAILS does not reference any database object

INV.MTL_PAC_ACTUAL_COST_DETAILS is referenced by following:

INV: MTL_PAC_ACTUAL_COST_DETAILS#