物料成本

--基于视图 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