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.

[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