Oracle EBS-SQL (BOM-18):检查BOM与工艺路线对照.sql
/*有工艺路线，无BOM清单*/
select msi.segment1,
msi.description
from apps.BOM_OPERATIONAL_ROUTINGS bor,
apps.mtl_system_items_b msi
where msi.organization_id=Y
and bor.organization_id=msi.organization_id
and bor.assembly_item_id=msi.inventory_item_id
and not exists (select ‘X‘
from apps.BOM_BILL_OF_MATERIALS bbom
where bbom.assembly_item_id=bor.assembly_item_id
and bbom.organization_id=bor.organization_id)
--------------------------------------------------------------------------------------------
/*无工艺路线，有BOM清单*/
select msi.segment1,
msi.description
from apps.BOM_BILL_OF_MATERIALS bbom,
apps.mtl_system_items_b msi
where msi.organization_id=Y
and bbom.organization_id=msi.organization_id
and bbom.assembly_item_id=msi.inventory_item_id
and not exists (select ‘X‘
from apps.BOM_OPERATIONAL_ROUTINGS bor
where bor.assembly_item_id=bbom.assembly_item_id
and bor.organization_id=bbom.organization_id)
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
