Hi!

We all know that Total Quantity (%ELT COUNT%) can be captured in the BOM table. I am trying to capture all the BOM related data from the database itself same like PDM, I know its quite ambitious requirement, but it will be constructive to run BOM Automation form the DB through writing queries.

If you have any sample queries or suggestion please share them in comments. 

Update - I can get all the BOM related data except Quantity Variable  (%ELT COUNT%), then how to find the (%ELT COUNT%) in DB?

Thank you!