Nth level BOM explosion query based on condition
Please help me in sql query of BOM explosion based on condition.
There is a page two list value for Items : lov are value 1,value2.
Input : item number , value 1
Output: exploded BOM with condition.
Condition: while traversing the BOM, we need to validate the component/subassembly p2 list value. If list value is value1 ,ignore that component/subassembly (Do not traverse it).
This check should be at every level of traversal.
I see a similar question asked by you on BOM Nth level data which few of the folks responded in the below thread
Can you let us know the exact issue you are facing while using the existing query with the new conditions you shared. Your requirement seems specific to particular list values of items across level. So along with items you can join the P2 value and define your where-used condition. Should be simple to achieve. Let us know if you try and get stuck.