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