[Home] [Help]
[Dependency Information]
Object Name: | MTL_CST_ACTUAL_COST_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
MTL_CST_ACTUAL_COST_DETAILS stores actual cost, prior cost, and new
cost information for a transaction by element and by level.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_CST_ACTUAL_COST_DETAILS_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() |
MTL_CST_ACTUAL_COST_DETAILS_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAYER_ID | NUMBER | Yes | Layer identifier | |
TRANSACTION_ID | NUMBER | Yes | Transaction identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
COST_ELEMENT_ID | NUMBER | Yes | Cost element identifier | |
LEVEL_TYPE | NUMBER | Yes | Level type | |
TRANSACTION_ACTION_ID | NUMBER | Yes | Transaction action identifier | |
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 | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ACTUAL_COST | NUMBER | Actual cost of the transaction | ||
PRIOR_COST | NUMBER | Prior average cost | ||
NEW_COST | NUMBER | New average cost | ||
INSERTION_FLAG | VARCHAR2 | (1) | Yes | Used to determine which cost detail rows to insert into CST_LAYER_COST_DETAILS |
VARIANCE_AMOUNT | NUMBER | Variance that arises from average cost computation | ||
USER_ENTERED | VARCHAR2 | (1) | Yes | Specifies whether this row is entered by the user or the cost processor |
TRANSACTION_COSTED_DATE | DATE | Transaction date | ||
PAYBACK_VARIANCE_AMOUNT | NUMBER | Payback variance amount | ||
ONHAND_VARIANCE_AMOUNT | NUMBER | Onhand variance amount |
Cut, paste (and edit) the following text to query this object:
SELECT LAYER_ID
, TRANSACTION_ID
, ORGANIZATION_ID
, COST_ELEMENT_ID
, LEVEL_TYPE
, TRANSACTION_ACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID
, ACTUAL_COST
, PRIOR_COST
, NEW_COST
, INSERTION_FLAG
, VARIANCE_AMOUNT
, USER_ENTERED
, TRANSACTION_COSTED_DATE
, PAYBACK_VARIANCE_AMOUNT
, ONHAND_VARIANCE_AMOUNT
FROM INV.MTL_CST_ACTUAL_COST_DETAILS;
INV.MTL_CST_ACTUAL_COST_DETAILS does not reference any database object
INV.MTL_CST_ACTUAL_COST_DETAILS is referenced by following:
|
|
|