物料成本

--基于视图 CST_MGD_LIFO_ITEM_COSTS_V 可取所有数据
SELECT pp.legal_entity 法人主体id,
       xep.name 法人主体名字,
       pic.pac_period_id 期间id,
       pp.period_name 期间,
       msi.segment1 物料编码,
       msi.description 物料,
       round(pic.item_cost, 6) 物料成本
  FROM cst_pac_item_costs           pic,
       cst_cost_groups              cg,
       cst_pac_periods              pp,
       cst_cost_types               ct,
       xle_firstparty_information_v xfi,
       mtl_system_items_vl          msi,
       xle_entity_profiles          xep
 WHERE cg.cost_group_id = pic.cost_group_id
   AND pp.pac_period_id = pic.pac_period_id
   AND pp.cost_type_id = ct.cost_type_id
   AND xfi.legal_entity_id = pp.legal_entity
   AND msi.organization_id = cg.organization_id
   AND msi.inventory_item_id = pic.inventory_item_id
   AND xep.legal_entity_id = pp.legal_entity