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
BOM data
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
<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
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
-
- Posts: 51
- Joined: Thu Jan 18, 2007 11:34 am
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 1 guest