Converting start with connect by to Recursive with
I have a query to display the list of all assembly where the component item is used. Is it possible to convert this to Recursive with Clause?
SELECT LEVEL, bbom.assembly_item_id, msi1.segment1 PARENT,
bic.component_item_id,
(SELECT msi2.segment1
FROM mtl_system_items msi2
WHERE inventory_item_id = bic.component_item_id
AND organization_id = :p_org_id) comp,
bic.component_quantity
FROM bom_bill_of_materials bbom,
apps.bom_inventory_components bic,
mtl_system_items msi1
WHERE bbom.bill_sequence_id = bic.bill_sequence_id
AND bbom.assembly_item_id = msi1.inventory_item_id
AND bbom.organization_id = msi1.organization_id