eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_SUBLEDGER_REPORT dependencies on PO_RTRN_DTL

Line 293: CURSOR c_po_rtrn_dtl(v_doc_id NUMBER, v_line_id NUMBER) IS

289: WHERE
290: h.po_id = v_po_id;
291: c_po_ordr c_po_ordr_hdr%ROWTYPE;
292:
293: CURSOR c_po_rtrn_dtl(v_doc_id NUMBER, v_line_id NUMBER) IS
294: SELECT
295: r.orgn_code orgn_code,
296: r.recv_no recv_no,
297: r.recv_date recv_date,

Line 305: po_rtrn_dtl rd,

301: v.vendor_name vendor_name,
302: nvl(rd.po_id, 0) po_id,
303: nvl(rd.poline_id,0) poline_id
304: FROM
305: po_rtrn_dtl rd,
306: po_rtrn_hdr rh,
307: po_recv_hdr r,
308: po_vend_mst v
309: WHERE

Line 314: c_po_rtrn c_po_rtrn_dtl%ROWTYPE;

310: rd.line_id = v_line_id
311: AND rd.return_id = v_doc_id
312: AND rd.recv_id = r.recv_id
313: AND rh.return_vendor_id = v.vendor_id;
314: c_po_rtrn c_po_rtrn_dtl%ROWTYPE;
315:
316: CURSOR c_op_ordr_dtl(v_doc_id NUMBER, v_line_id NUMBER) IS
317: SELECT
318: h.orgn_code orgn_code,

Line 706: OPEN c_po_rtrn_dtl(r.doc_id, r.line_id);

702: LPAD(L_GMF_BILL_CURR,16,' ')||': '||RPAD(c_po_recv.billing_currency,4,' ')||
703: LPAD(L_GMF_XCHG_RATE,18,' ')||': '||RPAD(to_char(c_po_recv.receipt_exchange_rate),15,' '));
704: END IF;
705: ELSIF (r.doc_type = 'RTRN') THEN
706: OPEN c_po_rtrn_dtl(r.doc_id, r.line_id);
707: FETCH c_po_rtrn_dtl INTO c_po_rtrn;
708: CLOSE c_po_rtrn_dtl;
709: /* Bug 2641704 Replaced with next line PRINT_LINE ( '|'||LPAD(L_GMF_RECEIPT,16,' ')||': '||RPAD(c_po_rtrn.orgn_code,4,' ') || ' ' ||RPAD(c_po_rtrn.recv_no,16,' ')||' '|| */
710: PRINT_LINE ( '|'||LPAD(L_GMF_RECEIPT,16,' ')||': '||RPAD((c_po_rtrn.orgn_code||' '||c_po_rtrn.recv_no),37,' ')||' '||

Line 707: FETCH c_po_rtrn_dtl INTO c_po_rtrn;

703: LPAD(L_GMF_XCHG_RATE,18,' ')||': '||RPAD(to_char(c_po_recv.receipt_exchange_rate),15,' '));
704: END IF;
705: ELSIF (r.doc_type = 'RTRN') THEN
706: OPEN c_po_rtrn_dtl(r.doc_id, r.line_id);
707: FETCH c_po_rtrn_dtl INTO c_po_rtrn;
708: CLOSE c_po_rtrn_dtl;
709: /* Bug 2641704 Replaced with next line PRINT_LINE ( '|'||LPAD(L_GMF_RECEIPT,16,' ')||': '||RPAD(c_po_rtrn.orgn_code,4,' ') || ' ' ||RPAD(c_po_rtrn.recv_no,16,' ')||' '|| */
710: PRINT_LINE ( '|'||LPAD(L_GMF_RECEIPT,16,' ')||': '||RPAD((c_po_rtrn.orgn_code||' '||c_po_rtrn.recv_no),37,' ')||' '||
711: LPAD(L_GMF_RECEIPT_DATE,14,' ')||': '||to_char(c_po_rtrn.recv_date)||' '||LPAD(L_GMF_VENDOR,12,' ')||': '||RPAD(c_po_rtrn.vendor_no,16,' ')|| RPAD(c_po_rtrn.vendor_name,16,' '));

Line 708: CLOSE c_po_rtrn_dtl;

704: END IF;
705: ELSIF (r.doc_type = 'RTRN') THEN
706: OPEN c_po_rtrn_dtl(r.doc_id, r.line_id);
707: FETCH c_po_rtrn_dtl INTO c_po_rtrn;
708: CLOSE c_po_rtrn_dtl;
709: /* Bug 2641704 Replaced with next line PRINT_LINE ( '|'||LPAD(L_GMF_RECEIPT,16,' ')||': '||RPAD(c_po_rtrn.orgn_code,4,' ') || ' ' ||RPAD(c_po_rtrn.recv_no,16,' ')||' '|| */
710: PRINT_LINE ( '|'||LPAD(L_GMF_RECEIPT,16,' ')||': '||RPAD((c_po_rtrn.orgn_code||' '||c_po_rtrn.recv_no),37,' ')||' '||
711: LPAD(L_GMF_RECEIPT_DATE,14,' ')||': '||to_char(c_po_rtrn.recv_date)||' '||LPAD(L_GMF_VENDOR,12,' ')||': '||RPAD(c_po_rtrn.vendor_no,16,' ')|| RPAD(c_po_rtrn.vendor_name,16,' '));
712: IF (c_po_rtrn.po_id > 0) THEN