select c.segment1                                                                          物料编码,

         c.description                                                                         物料描述,

         f.item_cost                                                                                 成本,

         DECODE(f.based_on_rollup_flag,'1','基于累积','2','不基于累积')     成本类型

  from

    --bom.cst_item_cost_details            b,

       inv.mtl_system_items_b               c,

       bom.bom_bill_of_materials           d,

    --bom.bom_inventory_components   e,

       bom.cst_item_costs                      f

 where c.organization_id=94

    and d.organization_id=c.organization_id

    and f.organization_id=c.organization_id

 --and b.organization_id=c.organization_id

    and f.based_on_rollup_flag='2'

    and f.cost_type_id='1000'

    and c.inventory_item_id=f.inventory_item_id

    and c.inventory_item_status_code='Active'

    and c.item_type<>'P'

    and d.assembly_item_id=c.inventory_item_id

 --and d.bill_sequence_id=e.bill_sequence_id

   and d.bill_sequence_id in (select t.bill_sequence_id

                                           from bom.bom_inventory_components t)

 --and e.component_item_id=c.