[Home] [Help] [Dependency Information]
Object Name: | MTL_CST_LAYER_ACT_COST_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_CST_LAYER_ACT_COST_DETAILS |
Subobject Name: | |
Status: | VALID |
MTL_CST_LAYER_ACT_COST_DETAILS stores the details of the layers consumed or created by a transaction.
For issue transactions, it stores the layer quantities consumed and the cost at which they were consumed.
For receipt transactions, it stores the layer created and replenished (if any) along with the cost details.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_CST_LAYER_ACT_CST_DTLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRANSACTION_ID
ORGANIZATION_ID LAYER_ID INV_LAYER_ID COST_ELEMENT_ID LEVEL_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | Transaction identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
LAYER_ID | NUMBER | Yes | Layer identifier | |
INV_LAYER_ID | NUMBER | Yes | Inventory layer identifier | |
LAYER_QUANTITY | NUMBER | Yes | Current inventory layer quantity | |
LEVEL_TYPE | NUMBER | Yes | Level identifier | |
COST_ELEMENT_ID | NUMBER | Yes | Cost element identifier | |
ACTUAL_COST | NUMBER | Actual cost of the transaction | ||
LAYER_COST | NUMBER | Cost of the layer involved | ||
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 | Item identifier | |
VARIANCE_AMOUNT | NUMBER | Variance amount | ||
USER_ENTERED | VARCHAR2 | (1) | Yes | Specifies whether this row is entered by the user or the cost processor |
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 TRANSACTION_ID
, ORGANIZATION_ID
, LAYER_ID
, INV_LAYER_ID
, LAYER_QUANTITY
, LEVEL_TYPE
, COST_ELEMENT_ID
, ACTUAL_COST
, LAYER_COST
, 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
, VARIANCE_AMOUNT
, USER_ENTERED
, PAYBACK_VARIANCE_AMOUNT
, ONHAND_VARIANCE_AMOUNT
FROM INV.MTL_CST_LAYER_ACT_COST_DETAILS;
INV.MTL_CST_LAYER_ACT_COST_DETAILS does not reference any database object
INV.MTL_CST_LAYER_ACT_COST_DETAILS is referenced by following:
|
|
|