Oracle MASTER BOM展开

关注

转载最新推荐文章于 2026-05-18 05:51:30 发布 1.3k 阅读 AI 写同款· GEO 优化 ›

BOM规范制作指南：从设计源头规避物料风险，节省项目成本物料清单（BOM）是连接产品设计、采购、生产和财务的核心数据枢纽，其本质是一份结构化的物料数据表。BOM通过精准定义物料的编码、型号、规格、封装、供应商及用量等关键属性，确保信息从设计到制造的无损传递。规范化的BOM能有效打通信息流，是实现成本精准核算、供应链协同和版本控制的基础，其技术价值在于从源头规避因信息错漏导致的采购停滞、生产事故和缺料停产等风险。在电子制造、硬件开发等领域，一份高质量的BOM是保障项目顺利落地、控制隐性成本的关键。本文聚焦于如何利用Altium Designer等EDA工具高效生成阅读详情

Oracle MASTER BOM展开

select rownum seq_num
   ,top_item
   ,lpad(to_char(level),decode(level,1,1,level+1),'.') bom_level
   ,bbm.ASSEMBLY_ITEM_ID
   ,msi.segment1 assembly_item
   ,msi.description assembly_description
   ,bbm.COMMON_ASSEMBLY_ITEM_ID
   ,bic.item_NUM
   ,bbm.COMMON_BILL_SEQUENCE_ID
   ,bbm.BILL_SEQUENCE_ID
   ,msic.segment1 component_item
   ,msic.description c_item_description
   ,bic.COMPONENT_ITEM_ID
   ,bic.COMPONENT_QUANTITY
   ,msic.primary_unit_of_measure
   ,bic.COMPONENT_YIELD_FACTOR
   ,bic.EFFECTIVITY_DATE
   ,bic.ATTRIBUTE1
   ,bic.ATTRIBUTE2
   ,bic.CHANGE_NOTICE
   ,ood.ORGANIZATION_CODE
   ,ood.ORGANIZATION_NAME
   ,ood.ORGANIZATION_ID


from bom_bill_of_materials bbm
,bom_inventory_components bic
,mtl_system_items_b msi
,mtl_system_items_b msic
,org_organization_definitions ood

where
   bbm.ASSEMBLY_ITEM_ID  = msi.inventory_item_id
  and bbm.ORGANIZATION_ID = msi.organization_id
  and bic.COMPONENT_ITEM_ID =msic.inventory_item_id
  and bic.PK2_VALUE       =msic.organization_id
  and bbm.BILL_SEQUENCE_ID=bic.BILL_SEQUENCE_ID
  and (bic.DISABLE_DATE is null or bic.DISABLE_DATE >= sysdate)
  and bic.EFFECTIVITY_DATE <= sysdate
  and ood.ORGANIZATION_ID=msi.organization_id


connect by bbm.ASSEMBLY_ITEM_ID = prior bic.COMPONENT_ITEM_ID
start with msi.segment1=:P_ITEM
and ood.ORGANIZATION_CODE =:P_ORG