[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
INV.MTL_PAC_ACT_CST_DTL_TEMP does not reference any database object
INV.MTL_PAC_ACT_CST_DTL_TEMP is referenced by following:
|
|
|