APPS.GMF_SUBLEDGER_REPORT dependencies on PO_RECV_DTL

Line 264: CURSOR c_po_recv_dtl(v_doc_id NUMBER, v_line_id NUMBER) IS

260: reference_no;
261:
262: /* VC Bug 1924250 - Detail info on documents */
263: /* Cursor for running report on test subledger table */
264: CURSOR c_po_recv_dtl(v_doc_id NUMBER, v_line_id NUMBER) IS
265: SELECT
266: h.billing_currency billing_currency,
267: h.receipt_exchange_rate receipt_exchange_rate,
268: v.vendor_no vendor_no,

Line 273: po_recv_dtl d,

269: v.vendor_name vendor_name,
270: nvl(d.po_id,0) po_id,
271: nvl(d.poline_id,0) poline_id
272: FROM
273: po_recv_dtl d,
274: po_recv_hdr h,
275: po_vend_mst v
276: WHERE
277: d.recv_id = v_doc_id

Line 281: c_po_recv c_po_recv_dtl%ROWTYPE;

277: d.recv_id = v_doc_id
278: AND d.line_id = v_line_id
279: AND d.recv_id = h.recv_id
280: AND d.shipvend_id = v.vendor_id;
281: c_po_recv c_po_recv_dtl%ROWTYPE;
282:
283: CURSOR c_po_ordr_hdr(v_po_id NUMBER) IS
284: SELECT
285: h.orgn_code orgn_code,

Line 687: OPEN c_po_recv_dtl(r.doc_id, r.line_id);

683: ' '||LPAD(L_GMF_DOC_DATE,18,' ')||': '||r.doc_date ); /* Bug 2641704 */
684:
685: /* VC Bug 1924250 - Detail info on documents */
686: IF (r.doc_type = 'RECV') THEN
687: OPEN c_po_recv_dtl(r.doc_id, r.line_id);
688: FETCH c_po_recv_dtl INTO c_po_recv;
689: CLOSE c_po_recv_dtl;
690: PRINT_LINE ( '|'||LPAD(L_GMF_VENDOR,16,' ')||': '||RPAD(c_po_recv.vendor_no,32,' ')||
691: RPAD(c_po_recv.vendor_name,40,' '));

Line 688: FETCH c_po_recv_dtl INTO c_po_recv;

684:
685: /* VC Bug 1924250 - Detail info on documents */
686: IF (r.doc_type = 'RECV') THEN
687: OPEN c_po_recv_dtl(r.doc_id, r.line_id);
688: FETCH c_po_recv_dtl INTO c_po_recv;
689: CLOSE c_po_recv_dtl;
690: PRINT_LINE ( '|'||LPAD(L_GMF_VENDOR,16,' ')||': '||RPAD(c_po_recv.vendor_no,32,' ')||
691: RPAD(c_po_recv.vendor_name,40,' '));
692: IF (c_po_recv.po_id > 0) THEN

Line 689: CLOSE c_po_recv_dtl;

685: /* VC Bug 1924250 - Detail info on documents */
686: IF (r.doc_type = 'RECV') THEN
687: OPEN c_po_recv_dtl(r.doc_id, r.line_id);
688: FETCH c_po_recv_dtl INTO c_po_recv;
689: CLOSE c_po_recv_dtl;
690: PRINT_LINE ( '|'||LPAD(L_GMF_VENDOR,16,' ')||': '||RPAD(c_po_recv.vendor_no,32,' ')||
691: RPAD(c_po_recv.vendor_name,40,' '));
692: IF (c_po_recv.po_id > 0) THEN
693: OPEN c_po_ordr_hdr(c_po_recv.po_id);