TPP’s from TP and Unit of Use

In this example, we will find all Trade Product Packs (TPP) from a Trade Product (TP) and a Unit of Use Quantity.

Example

We would like to find all trade product packs for Panadeine that have a size of 24 units.

(
 (^ 929360041000036105|Trade product pack reference set| : 700000101000036108|has TP| = 13481000168104|Panadeine|) 
 AND 
 (^ 929360041000036105|Trade product pack reference set| : 700000131000036101|UoU.Quantity.Refset|= #24)
)

The result of this query is formed from the intersection of two queries - the first query finds all members of the TPP reference set that have the trade product Panadeine. The second query finds all members of the TPP refset that have a Unit of Use quantity of 24.

This would be easily modified to return CTPPs using the Containered trade product pack reference set in the ECL instead of the TPP reference set.