APPS.GMF_SUBLEDGER_REPORT dependencies on PO_RECV_HST

Line 393: CURSOR c_po_recv_hst(v_sub_event_code VARCHAR2,

389: c_pur_ship c_pur_ship_dtl%ROWTYPE;
390: /* End Bug#2088655 */
391:
392: /* VC Bug 2048108 - Detail info on lines */
393: CURSOR c_po_recv_hst(v_sub_event_code VARCHAR2,
394: v_recv_id NUMBER, v_recv_line_id NUMBER) IS
395: SELECT
396: h.net_price,
397: h.price_um

Line 399: po_recv_hst h,

395: SELECT
396: h.net_price,
397: h.price_um
398: FROM
399: po_recv_hst h,
400: gl_sevt_mst sb
401: WHERE
402: h.recv_id = v_recv_id
403: AND h.recv_line_id = v_recv_line_id

Line 407: c_recv_hst c_po_recv_hst%ROWTYPE;

403: AND h.recv_line_id = v_recv_line_id
404: AND sb.sub_event_type = h.sub_event_type
405: AND sb.sub_event_code = v_sub_event_code;
406:
407: c_recv_hst c_po_recv_hst%ROWTYPE;
408:
409: CURSOR c_ic_tran_pnd(v_doc_type VARCHAR2,
410: v_doc_id NUMBER, v_line_id NUMBER) IS
411: SELECT

Line 858: OPEN c_po_recv_hst(r.sub_event_code, r.doc_id, r.line_id);

854: c_recv_hst.net_price := c_pur_ship.po_unit_price;
855: c_recv_hst.price_um := c_pur_ship.price_um;
856: ELSE
857: -- Bug 2048108 Print Unit Price for po receipts and returns
858: OPEN c_po_recv_hst(r.sub_event_code, r.doc_id, r.line_id);
859: FETCH c_po_recv_hst INTO c_recv_hst;
860: IF ( c_po_recv_hst%NOTFOUND ) THEN
861: c_recv_hst.net_price := NULL;
862: c_recv_hst.price_um := NULL;

Line 859: FETCH c_po_recv_hst INTO c_recv_hst;

855: c_recv_hst.price_um := c_pur_ship.price_um;
856: ELSE
857: -- Bug 2048108 Print Unit Price for po receipts and returns
858: OPEN c_po_recv_hst(r.sub_event_code, r.doc_id, r.line_id);
859: FETCH c_po_recv_hst INTO c_recv_hst;
860: IF ( c_po_recv_hst%NOTFOUND ) THEN
861: c_recv_hst.net_price := NULL;
862: c_recv_hst.price_um := NULL;
863: END IF;

Line 860: IF ( c_po_recv_hst%NOTFOUND ) THEN

856: ELSE
857: -- Bug 2048108 Print Unit Price for po receipts and returns
858: OPEN c_po_recv_hst(r.sub_event_code, r.doc_id, r.line_id);
859: FETCH c_po_recv_hst INTO c_recv_hst;
860: IF ( c_po_recv_hst%NOTFOUND ) THEN
861: c_recv_hst.net_price := NULL;
862: c_recv_hst.price_um := NULL;
863: END IF;
864: CLOSE c_po_recv_hst;

Line 864: CLOSE c_po_recv_hst;

860: IF ( c_po_recv_hst%NOTFOUND ) THEN
861: c_recv_hst.net_price := NULL;
862: c_recv_hst.price_um := NULL;
863: END IF;
864: CLOSE c_po_recv_hst;
865: END IF;
866: /* End Bug#2088655 */
867: PRINT_LINE ('|'||LPAD(L_GMF_LINE, 8, ' ')||' '||RPAD(L_GMF_ITEM,32,' ')||' '||
868: RPAD(L_GMF_TRANS_DATE,13,' ')||' '||RPAD(L_GMF_WHSE, 6, ' ')||' '||