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