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
Indented Routing Script
-
- Posts: 42
- Joined: Mon Aug 11, 2008 3:20 am
- Location: Malaysia
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'>
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'>
Who is online
Users browsing this forum: No registered users and 4 guests