208: GROUP BY recv_um1;
209:
210: CURSOR rtrn_qty_cur IS
211: SELECT NVL(SUM(return_qty1), 0),return_um1
212: FROM po_rtrn_dtl dtl , po_rtrn_hdr hdr
213: WHERE dtl.po_id = G_po_id
214: AND dtl.poline_id = G_poline_id
215: AND dtl.return_id = hdr.return_id
216: AND hdr.delete_mark <> 1
318: /*Bug# 1094230 */
319: /*
320: SELECT NVL(SUM(return_qty1), 0)
321: INTO v_returned_qty
322: FROM po_rtrn_dtl dtl , po_rtrn_hdr hdr
323: WHERE dtl.po_id = G_po_id
324: AND dtl.poline_id = G_poline_id
325: AND dtl.return_id = hdr.return_id;
326: