Total Pageviews

December 3, 2016

12/03/2016 01:13:00 AM

Oracle EBS :Inventory:Item Cost


Oracle apps 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, sysdatecmm.cost_type_id ,0) cost
from mtl_system_items_b msi, CM_MTHD_MST cmm
where cmm.cost_mthd_desc='Standard Cost'