Bom components query in oracle apps

Bom components query in oracle apps

In this post , You will get the Bom components query in oracle apps which helps to list all the components under the single BOM item. This query helps to extract the BOM components information's in oracle apps.

 

 

Table Using Bom components query in oracle apps

 

1.Bom_inventory_components

 

2.Bom_bill_of_materials

 

 

Bom components query in oracle apps

 

select

bom.assembly_item_id,

(select msi.segment1 from mtl_system_items msi where msi.inventory_item_id=bom.assembly_item_id and msi.organization_id=85) parent_item,

lpad(' ',2*(level-1),' ')||

(select msi.segment1 from mtl_system_items msi where

msi.inventory_item_id=bic.component_item_id and msi.organization_id=207) child_item,

bic.component_item_id child_item_id, ,

bic.bill_sequence_id , ,

bic.operation_seq_num ,

bic.bom_item_type ,

bic.item_num ,

 

level,

bic.component_quantity

 

 

 

 

from

bom_inventory_components bic,

(select * from bom_bill_of_materials where organization_id=85) bom

where bom.bill_sequence_id=bic.bill_sequence_id

start with bom.assembly_item_id=:P_BOM_ITEM_ID

connect by prior bic.component_item_id=bom.assembly_item_id;