How to find item cost

Another common issue when writing queries is getting an item cost.

Here are the APIs to use in queries:

For discrete manufacturing:

cst_cost_api.get_item_cost(1,inventory_item_id, organization_id,NULL,NULL)

here is a sample query:

select segment1 item,

cst_cost_api.get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) cost

from mtl_system_items_b

If you are in an OPM organization the above won't work and instead you need to call

select msi.segment1 item,

GMF_CMCOMMON.get_cmpt_cost( inventory_item_id, organization_id, sysdate, cmm.cost_type_id ,0) cost

from mtl_system_items_b msi, CM_MTHD_MST cmm

where cmm.cost_mthd_desc='Standard Cost'

References:

http://piotrbelter.blogspot.com/2009/06/how-to-find-item-cost.html