oracle 动态bom,Oracle EBS-SQL (BOM-5):检查有BOM但物料状态为NEW的物料.sql

select DISTINCT

msi.segment1 成品编码

,msi.description

成品描述

,msi.item_type

物料类型

,msi.inventory_item_status_code

状态

,msi.build_in_wip_flag

允许制造

from

INV.MTL_SYSTEM_ITEMS_B

msi,

apps.BOM_BILL_OF_MATERIALS bom,

apps.BOM_INVENTORY_COMPONENTS

bic

where

msi.organization_id=X

and

bom.ORGANIZATION_ID=X

and

bom.assembly_item_id=msi.inventory_item_id

and

bom.bill_sequence_id=bic.bill_sequence_id

and bic.DISABLE_DATE

is null

--and msi.build_in_wip_flag =‘N‘   --可制造

and msi.inventory_item_status_code=‘New‘

order by msi.segment1

原文：http://www.cnblogs.com/st-sun/p/3778382.html