[Home] [Help]
View: AX_CST_COST_DETAILS_V1
Product: | AX - Global Accounting Engine |
Description: | Transaction cost and actual cost of transactions |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TCD.ORGANIZATION_ID ORGANIZATION_ID
, TCD.TRANSACTION_ID TRANSACTION_ID
, TCD.COST_ELEMENT_ID COST_ELEMENT_ID
, TCD.LEVEL_TYPE LEVEL_TYPE
, TCD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TCD.TRANSACTION_COST TRANSACTION_COST
, ACD.ACTUAL_COST ACTUAL_COST
, (TCD.TRANSACTION_COST-ACD.ACTUAL_COST) PRICE_VARIANCE
, ACD.LAYER_ID
FROM MTL_CST_TXN_COST_DETAILS TCD
, MTL_CST_ACTUAL_COST_DETAILS ACD
WHERE TCD.ORGANIZATION_ID = ACD.ORGANIZATION_ID
AND TCD.TRANSACTION_ID = ACD.TRANSACTION_ID
AND TCD.COST_ELEMENT_ID = ACD.COST_ELEMENT_ID
AND TCD.LEVEL_TYPE = ACD.LEVEL_TYPE
AND TCD.INVENTORY_ITEM_ID = ACD.INVENTORY_ITEM_ID
Columns
Name |
ORGANIZATION_ID |
TRANSACTION_ID |
COST_ELEMENT_ID |
LEVEL_TYPE |
INVENTORY_ITEM_ID |
TRANSACTION_COST |
ACTUAL_COST |
PRICE_VARIANCE |
LAYER_ID |