SQL Language (MOSC)

MOSC Banner

Converting start with connect by to Recursive with

edited Mar 25, 2014 12:00PM in SQL Language (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center