group + decode

SELECT G.PO_ID,
       G.PROD_ID,
       G.UNIT_ID,
       G.PO_SCHD_DATE,
       SUM(PO_QTY) PO_QTY,
       SUM(DECODE(G.PO_STAT_CD, '90', G.PO_QTY, 0)) MOVE_QTY
  FROM TB_PO_DTL G
 WHERE G.PO_STAT_CD IN ('30', '90')
 GROUP BY G.PO_ID, G.PROD_ID, G.UNIT_ID, G.PO_SCHD_DATE

[img]http://dl.iteye.com/upload/attachment/0073/4804/e6ddca22-3c92-307c-b4e4-58616e2618e8.png[/img]