SQL Performance (MOSC)

MOSC Banner

Oracle 11g R2 BOM Item where used Query

edited Sep 24, 2014 5:02AM in SQL Performance (MOSC) 5 commentsAnswered

I have a custom view which gives the listing of all the final assemblies where a particular given component is used across different organizations.

  The final assemblies also further needs to be searched as components in the same view.

   select  all the final assemblies  from  view  where component ='x'

  this will give list of all final assemblies across different organizations which are using the component X.

  This final assemblies further will be searched as a component to get another level of the components .... nth level it should go.

   How to use the Recursive with Logic  to use this  feature to nth level  .

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