Oracle EBS-SQL (BOM-1):检查供应类型错误.sql
--检查供应类型错误SELECT MSI.SEGMENT1 物料编码,
MSI.DESCRIPTION 物料描述,
DECODE(MSI.WIP_SUPPLY_TYPE,'6','虚拟项','1','推式' ,'2','装配拉式','3','工序拉式')供应类型,
MSI.WIP_SUPPLY_SUBINVENTORY供应子库,
msi.creation_date 日期
FROM INV.MTL_SYSTEM_ITEMS_B MSI
WHERE MSI.ORGANIZATION_ID = x
and msi.MRP_PLANNING_CODE=3
and msi.item_type='P'
and (msi.WIP_SUPPLY_TYPE!='1'
and msi.WIP_SUPPLY_TYPE!='2'
and msi.WIP_SUPPLY_TYPE!='3')
and msi.WIP_SUPPLY_SUBINVENTORY is null
--and msi.inventory_item_status_code='Active'
页:
[1]