Simple Query To Fetch Bill Of Material (BOM) Information

SELECT

     substr(iasy.segment1,1,20) "Assembly",

                 substr(icmp.segment1,1,20) "Component",

                 substr(comp.component_quantity,1,8) "Quantity",

                 substr(comp.effectivity_date,1,8) "From",

                 substr(comp.disable_date,1,8) "To Date"

FROM

                 mtl_system_items_B iasy,

                 bom_bill_of_materials bom,

                 bom_inventory_components comp,

                 mtl_system_items_B icmp

WHERE

                 iasy.segment1 LIKE '&Item%' AND

                 iasy.organization_id = 207 AND

                 iasy.inventory_item_id = bom.assembly_item_id AND

                 iasy.organization_id = bom.organization_id AND

                 bom.bill_sequence_id = comp.bill_sequence_id AND

                 comp.component_item_id = icmp.inventory_item_id AND

                 icmp.organization_id = 207

Thanks & Regards,

S.Grace Paul Regan