select --msi.inventory_item_id
        --,msi.organization_id
     msi.segment1                                        物料编码
    ,msi.Description                                    物料描述
    ,msi.INVENTORY_ITEM_STATUS_CODE           状态
    ,decode(cic.ITEM_COST,'',0,cic.ITEM_COST) 成本
    ,cic.COST_TYPE_ID                               成本类型
    ,msi.creation_date                               创建日期
from   inv.mtl_system_items_b msi,
          bom.cst_item_costs cic

where   msi.organization_id=X
   and msi.INVENTORY_ITEM_STATUS_CODE<>'New'
   and msi.INVENTORY_ITEM_ID=cic.INVENTORY_ITEM_ID
   and cic.organization_id=msi.organization_id
   and cic.COST_TYPE_ID in (1)
   and decode(cic.ITEM_COST,'',0,cic.ITEM_COST)=0
    and msi.INVENTORY_ITEM_STATUS_CODE not in ('Inactive','PHActive')
    order by msi.creation_date

05-11 20:20