Oracle EBS :Inventory:Item Cost

Oracle EBS :Inventory:Item Cost

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'