How to find item cost
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'