I don't understand what roll the Primary OPCD plays in this? What is this? If you know the PFP why is it needed? Also what is the PNC?
If you pick either AT30AA or AT31AA and look in the FRF_WITH_PNC you find 14004 for both of them. If you take 14004 and to the PART_PNC_ADHOC table you get 179 PART_NOs for PNC 14004. All of these PART_NOs have 14002 as the first five digits. So at least in this example specifying the Primary OPCD does nothing for you or is there something I'm not seeing.
I need to get to bed now, but I'll take another look at this tomorrow.
If you pick either AT30AA or AT31AA and look in the FRF_WITH_PNC you find 14004 for both of them. If you take 14004 and to the PART_PNC_ADHOC table you get 179 PART_NOs for PNC 14004. All of these PART_NOs have 14002 as the first five digits. So at least in this example specifying the Primary OPCD does nothing for you or is there something I'm not seeing.
I need to get to bed now, but I'll take another look at this tomorrow.