ERPstuff - Oracle EBS Community

Hi Guys,
This will give you details of bom and its components

select mif.segment1,mif.description,bom.assembly_item_id,bom.organization_id,bom.common_bill_sequence_id,
bic.component_item_id, bom.bill_sequence_id,bom.creation_date,bic.bill_sequence_id
from bom_bill_of_materials bom,bom_inventory ...

Hi guys,
There are six tables involved in BOM interface.

1.BOM_BILLS_OF_MTLS_INTERFACE ------ bom header information
2. BOM_INVENTORY_COMPONENTS ------ bom components details

If you do not have routing then use on these two tables for import.

3. BOM_ASSY_COMMENT_INTERFACE

4.BOM_REF_DESGS ...