APPS.GML_PO_RECV1_PKG dependencies on PO_RTRN_DTL

Line 152: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;

148: v_po_no po_ordr_hdr.po_no%TYPE;
149: v_line_no po_ordr_dtl.line_no%TYPE;
150: v_org_id gl_plcy_mst.org_id%TYPE;
151: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
152: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;
153: v_received_qty po_recv_dtl.recv_qty1%TYPE;
154: v_status po_ordr_dtl.po_status%TYPE;
155: v_actual_received_qty NUMBER;
156: v_created_by po_recv_dtl.created_by%TYPE;

Line 212: FROM po_rtrn_dtl dtl , po_rtrn_hdr hdr

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

Line 322: FROM po_rtrn_dtl dtl , po_rtrn_hdr hdr

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: