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_ITEM_COST_DETAILS_V1

Product:	AX - Global Accounting Engine
Description:	Standard cost and/or average cost of items
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MP.ORGANIZATION_ID
, CICD.INVENTORY_ITEM_ID
, CICD.COST_TYPE_ID
, CICD.LEVEL_TYPE
, CICD.COST_ELEMENT_ID
, CICD.RESOURCE_ID
FROM CST_ITEM_COST_DETAILS CICD
, MTL_PARAMETERS MP
WHERE CICD.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.PRIMARY_COST_METHOD = 1 AND CICD.COST_TYPE_ID = MP.PRIMARY_COST_METHOD AND CICD.COST_ELEMENT_ID = 2 UNION SELECT MP.ORGANIZATION_ID
, CICD.INVENTORY_ITEM_ID
, CICD.COST_TYPE_ID
, CICD.LEVEL_TYPE
, CICD.COST_ELEMENT_ID
, CICD.RESOURCE_ID
FROM CST_ITEM_COST_DETAILS CICD
, MTL_PARAMETERS MP WHERE CICD.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.PRIMARY_COST_METHOD = 2 AND CICD.COST_TYPE_ID = MP.AVG_RATES_COST_TYPE_ID AND CICD.COST_ELEMENT_ID = 2

Columns

Name
ORGANIZATION_ID
INVENTORY_ITEM_ID
COST_TYPE_ID
LEVEL_TYPE
COST_ELEMENT_ID
RESOURCE_ID