Identify Purchased Items with Inventory Completion in Cardex

SELECT * FROM proddta.F4102 WHERE
ibstkt = 'P' AND
 EXISTS
(SELECT * FROM proddta.F4111 WHERE ilmcu = ibmcu AND ilitm = ibitm AND ildct = 'IC' AND ildgl <=111304)