[原创]在ORACLE ERP中反查BOM的实现方法

本例在Oracle EBS11i 11.5.10版本测试通过.

---反查BOMITPUB个人空间 Q,KYS(}!No
SELECT MSI.SEGMENT1, msi.descriptionITPUB个人空间?E#d`0\"L?B
  FROM MTL_SYSTEM_ITEMS_B MSIITPUB个人空间$|9n yL Z@"`T
 WHERE MSI.ORGANIZATION_ID = 103
#^#y5_(m`5zo({Z5yf0   AND MSI.Inventory_Item_Id inITPUB个人空间z$D*V5hG
       (SELECT bom.assembly_item_id
o(N rWt0          FROM bom_bill_of_materials bom, bom_inventory_components bicITPUB个人空间cV7}h*},P._v3z)Z
         WHERE bom.organization_id = 103
0Xk"e%U.|0           AND NVL(bom.common_bill_sequence_id, bom.bill_sequence_id) =ITPUB个人空间a'bmE~%i3~
               bic.bill_sequence_idITPUB个人空间,zY8SVw?,b5\0m
         START WITH bic.component_item_id INITPUB个人空间T5s
{(o5R3W#r
                    (select msi.inventory_item_id
cu,yOi`$n8J0                       from mtl_system_items_b msiITPUB个人空间b |8j_4DH"DIg%j
                      where msi.segment1 = '项目编码')ITPUB个人空间8s!]sS8V7Z'wB7h!Io6R
        CONNECT BY PRIOR bom.assembly_item_id = bic.component_item_id)