Inventory Valuation

Inventory valuation vs G/L valuation (By Inventory G/L Account):

select p.inventory_gl,sum(qty_on_hand*p.standard_cost) Value_STD,
(select sum(trx_amount) from glttrx a where a.gl_account=p.inventory_gl) GLBal
 from artprod p
inner join ARPPRTRX_QTY_ON_HAND(p.product_code,'12/31/13',2359,0) x on 1=1 
where p.stocked='Y' and inventory_gl is not null
group by p.inventory_gl
</PRE?\>