APPS.GMF_SUBLEDGER_REPORT dependencies on OP_ORDR_DTL

Line 316: CURSOR c_op_ordr_dtl(v_doc_id NUMBER, v_line_id NUMBER) IS

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,
319: h.order_no order_no,
320: h.order_date order_date,

Line 324: op_ordr_dtl d,

320: h.order_date order_date,
321: c.cust_no as cust_no,
322: c.cust_name cust_name
323: FROM
324: op_ordr_dtl d,
325: op_ordr_hdr h,
326: op_cust_mst c
327: WHERE
328: d.line_id = v_line_id

Line 332: c_op_ordr c_op_ordr_dtl%ROWTYPE;

328: d.line_id = v_line_id
329: AND d.bol_id = v_doc_id
330: AND d.order_id = h.order_id
331: AND d.shipcust_id = c.cust_id;
332: c_op_ordr c_op_ordr_dtl%ROWTYPE;
333:
334: CURSOR c_pm_btch_hdr(v_batch_id NUMBER) IS
335: SELECT
336: b.plant_code ,

Line 726: OPEN c_op_ordr_dtl(r.doc_id, r.line_id);

722: LPAD(L_GMF_BILL_CURR,16,' ')||': '||RPAD(c_po_rtrn.billing_currency,4,' ')||
723: LPAD(L_GMF_XCHG_RATE,18,' ')||': '||RPAD(to_char(c_po_rtrn.receipt_exchange_rate),15,' '));
724: END IF;
725: ELSIF (r.doc_type = 'OPSP') THEN
726: OPEN c_op_ordr_dtl(r.doc_id, r.line_id);
727: FETCH c_op_ordr_dtl INTO c_op_ordr;
728: CLOSE c_op_ordr_dtl;
729: PRINT_LINE ( '|'||LPAD(L_GMF_CUSTOMER,16,' ')||': '||RPAD(c_op_ordr.cust_no,32,' ')|| RPAD(c_op_ordr.cust_name,40,' '));
730: /* Bug 2641704 Replaced with next line PRINT_LINE ( '|'||LPAD(L_GMF_SO_NO,16,' ')||': '||RPAD(c_op_ordr.orgn_code,4,' ')||' '||RPAD(c_op_ordr.order_no,32,' ')|| */

Line 727: FETCH c_op_ordr_dtl INTO c_op_ordr;

723: LPAD(L_GMF_XCHG_RATE,18,' ')||': '||RPAD(to_char(c_po_rtrn.receipt_exchange_rate),15,' '));
724: END IF;
725: ELSIF (r.doc_type = 'OPSP') THEN
726: OPEN c_op_ordr_dtl(r.doc_id, r.line_id);
727: FETCH c_op_ordr_dtl INTO c_op_ordr;
728: CLOSE c_op_ordr_dtl;
729: PRINT_LINE ( '|'||LPAD(L_GMF_CUSTOMER,16,' ')||': '||RPAD(c_op_ordr.cust_no,32,' ')|| RPAD(c_op_ordr.cust_name,40,' '));
730: /* Bug 2641704 Replaced with next line PRINT_LINE ( '|'||LPAD(L_GMF_SO_NO,16,' ')||': '||RPAD(c_op_ordr.orgn_code,4,' ')||' '||RPAD(c_op_ordr.order_no,32,' ')|| */
731: PRINT_LINE ( '|'||LPAD(L_GMF_SO_NO,16,' ')||': '||RPAD((c_op_ordr.orgn_code||' '||c_op_ordr.order_no),37,' ')||

Line 728: CLOSE c_op_ordr_dtl;

724: END IF;
725: ELSIF (r.doc_type = 'OPSP') THEN
726: OPEN c_op_ordr_dtl(r.doc_id, r.line_id);
727: FETCH c_op_ordr_dtl INTO c_op_ordr;
728: CLOSE c_op_ordr_dtl;
729: PRINT_LINE ( '|'||LPAD(L_GMF_CUSTOMER,16,' ')||': '||RPAD(c_op_ordr.cust_no,32,' ')|| RPAD(c_op_ordr.cust_name,40,' '));
730: /* Bug 2641704 Replaced with next line PRINT_LINE ( '|'||LPAD(L_GMF_SO_NO,16,' ')||': '||RPAD(c_op_ordr.orgn_code,4,' ')||' '||RPAD(c_op_ordr.order_no,32,' ')|| */
731: PRINT_LINE ( '|'||LPAD(L_GMF_SO_NO,16,' ')||': '||RPAD((c_op_ordr.orgn_code||' '||c_op_ordr.order_no),37,' ')||
732: LPAD(L_GMF_SO_DATE,18,' ')||': '||to_char(c_op_ordr.order_date));