Oracle 11g R2 BOM Item where used Query
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 .