Simple Query To Fetch Implemented Engineering Change Order 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 '&Assembly%' 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