Conversion de Oracle a PostgreSQL Projecto Compiere

Hola a todos!

nuevamente pidiendo su ayuda para convertir esta sentencia de Oracle a
PostgreSQL

SELECT s.M_AttributeSetInstance_ID, asi.Description,
asi.Lot, asi.SerNo, asi.GuaranteeDate, l.Value
tyOnHand, s.QtyReserved, s.QtyOrdered,
(TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))-p.GuaranteeDaysMin,
TRUNC(asi.GuaranteeDate)-TRUNC(SysDate), CASE WHE
0 THEN
TRUNC(((TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))/p.GuaranteeDays)*100)
ELSE 0 END FROM M_Storage s INNER JOIN M_Locator l ON
(s.M_Locator_ID=l.
JOIN M_Product p ON (s.M_Product_ID=p.M_Product_ID)
LEFT OUTER JOIN M_AttributeSetInstance asi ON
(s.M_AttributeSetInstance_ID=asi.M_AttributeSetInsta
rehouse_ID=? AND s.M_Product_ID=? AND s.AD_Client_ID IN
(0,11) AND (s.QtyOnHand<>0 OR s.QtyReserved<>0 OR
s.QtyOrdered<>0) ORDER BY asi.GuaranteeDate,

alguna sugerencia?

Saludos
Victor
www.e-evolution.com