Question:

What table(s) do I find the relationship between a Parent Assembly P/N and its Component P/Ns?  Put another way, how can I determine which Parent Assembly P/N(s) a Component is used on?  What is the linking data element?

How can I see which Parent is driving the need for an MRP required quantity such as the information displayed on top portion of the MRP Demands and AVL screen?

Suggested Resolution:

Once you find the uniq_key of your subject component, search the BOM_DET table uniq_key for that same field. The BOMPARENT field associated with the Uniq_key will be the Uniq_key for the parent part.

Finding the AVL is a different matter. First, you have to check the parent part in the inventor table to see if a customer number is associated with it. This is in the BOMCUSTNO field. If there is, then check the avl of the consigned component for that customer. If it isn’t associated with a customer, then check the internal AVL for the component.