Inventory Turnover Report Query

SELECT 
(select qty_on_hand from arPprtrx_qty_on_hand(P.PRODUCT_CODE, :BEG,0, NULL)) beg_qty,
(select qty_on_hand from arPprtrx_qty_on_hand(P.PRODUCT_CODE, :END,0, NULL)) end_qty,
(select sum(qty_sold) from artslsdt sd where sd.product_code=p.product_code) qty_sold,
 P.product_code,p.description_1,p.product_class
FROM ARTPROD p
WHERE P.STOCKED='Y'

Most Excellent Queries