BOM data

[sachin_salvi]

I want an SQL which will give the BOM details... same as we get in Indented Bill of Materials.

We have a company which has max Bill level 10 defined... I want to extract the BOM and OHQ for each FG product.

Pls assist me for the same.


Sachin

[ahmadbilal]

<b>Try it to extract BOM</b>

SELECT comp_operation_seq_id, operation_seq_num, operation_sequence_id,
description, last_update_date, last_updated_by, creation_date,
created_by, last_update_login, component_sequence_id, bill_sequence_id,
consuming_operation_flag, consumption_quantity, supply_subinventory,
supply_locator_id, wip_supply_type, attribute_category, attribute1,
attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
attribute8, attribute9, attribute10, attribute11, attribute12,
attribute13, attribute14, attribute15, row_id
FROM bom_component_operations_v

[sajeedmujawar]

Hi Sachin,

I also work on BOM, WIP. Where are you based?

Regards,
Sajeed

[Waliabi]

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_components bic,mtl_item_flexfields mif
where bom.common_bill_sequence_id = bic.bill_sequence_id and bom.assembly_item_id = mif.inventory_item_id
and bom.assembly_item_id = 3011