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_ACT_CST_DTL_TEMP

Object Details

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

MTL_PAC_ACT_CST_DTL_TEMP is used to temporarily hold data during the interorg iteration process

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_PAC_ACT_CST_DTL_TEMP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID PAC_PERIOD_ID COST_GROUP_ID COST_ELEMENT_ID LEVEL_TYPE
MTL_PAC_ACT_CST_DTL_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_GROUP_ID PAC_PERIOD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COST_GROUP_ID	NUMBER		Yes	cost group id
TRANSACTION_ID	NUMBER		Yes	transaction id
PAC_PERIOD_ID	NUMBER		Yes	pac period id
COST_TYPE_ID	NUMBER		Yes	cost type id
COST_ELEMENT_ID	NUMBER		Yes	cost element id
LEVEL_TYPE	NUMBER		Yes	level type
INVENTORY_ITEM_ID	NUMBER		Yes	inventory item id
COST_LAYER_ID	NUMBER		Yes	cost layer id
PRIOR_COST	NUMBER			prior cost
ACTUAL_COST	NUMBER			actual cost
NEW_COST	NUMBER			new 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	user entered
INSERTION_FLAG	VARCHAR2	(1)	Yes	insertion flag
TRANSACTION_COSTED_DATE	DATE			transaction cost date
NEW_ONHAND_QUANTITY	NUMBER			new onhand quantity
NEW_BUY_QUANTITY	NUMBER			new buy quantity
NEW_MAKE_QUANTITY	NUMBER			new make quantity
SHIPMENT_NUMBER	VARCHAR2	(30)		shipment number
TRANSFER_TRANSACTION_ID	NUMBER			transfer transaction id
TRANSFER_COST	NUMBER			transfer cost
TRANSPORTATION_COST	NUMBER			transportation cost
MOH_ABSORPTION_COST	NUMBER			Material Overhead Absorption Cost retrieved from MTL_PAC_COST_SUBELEMENTS.
VARIANCE_AMOUNT	NUMBER			Variance Amount of PAC transaction
WIP_VARIANCE	NUMBER			WIP Variance of PAC transaction

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
,      NEW_ONHAND_QUANTITY
,      NEW_BUY_QUANTITY
,      NEW_MAKE_QUANTITY
,      SHIPMENT_NUMBER
,      TRANSFER_TRANSACTION_ID
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      MOH_ABSORPTION_COST
,      VARIANCE_AMOUNT
,      WIP_VARIANCE
FROM INV.MTL_PAC_ACT_CST_DTL_TEMP;

Dependencies

[top of page]

INV.MTL_PAC_ACT_CST_DTL_TEMP does not reference any database object

INV.MTL_PAC_ACT_CST_DTL_TEMP is referenced by following:

APPS: MTL_PAC_ACT_CST_DTL_TEMP