Indented Routing Script

[jasmine.hue]

Hi,

Can anyone share some idea on how to write the SQL script for Indented Routing? As you all aware, Oracle E-Biz has a special form to retrieve the indented BOM from system, however there is no routing information. [:(] So, my user is requesting a report on indented routing.

Hope you can share.

[:)] Thanks & Good Day,
Jasmine

[mido_emam]

You can find the below SQL to get the Components,

But i have another inquiry to get in the same query also the resources.


select 'Material' Material ,
(select msi.segment1 from mtl_system_items msi where msi.inventory_item_id=bom.assembly_item_id and msi.organization_id=144) parent_item,
bom.assembly_item_id,
lpad('',2*(level-1))||
(select msi.segment1 from mtl_system_items msi where msi.inventory_item_id=bic.component_item_id and msi.organization_id=144) child_item,
bic.component_item_id child_item_id,
bic.bill_sequence_id ,
bic.operation_seq_num ,
level,
bic.component_quantity
from
bom_inventory_components bic,
(select * from bom_bill_of_materials where organization_id=144) bom
where bom.bill_sequence_id=bic.bill_sequence_id
start with bom.assembly_item_id=602817
connect by prior bic.component_item_id=bom.assembly_item_id



If any one can help me in this query please.
it <span id='hl' style='background-color: yellow'><u><b>TOP URGENT</b></u></span id='hl'>