DBA Data[Home] [Help]

APPS.JAI_AP_OI_PROCESSING_PKG dependencies on RCV_HEADERS_INTERFACE

Line 105: lv_shipment_num rcv_headers_interface.shipment_num%type;

101: lv_trx_id VARCHAR2(30);
102: lv_receipt_code VARCHAR2(20);
103: ln_shipment_line_id NUMBER;
104: ln_shipment_header_id NUMBER;
105: lv_shipment_num rcv_headers_interface.shipment_num%type;
106: lb_result BOOLEAN := FALSE ;
107: invs_rec ap_invoices_all%rowtype;
108: inv_lines_rec ap_invoice_lines_all%rowtype;
109: ln_vendor_id NUMBER;

Line 152: From rcv_headers_interface

148: lv_trx_id := inv_lines_rec.po_line_location_id ;
149: ELSE
150: Select shipment_num
151: INTO lv_shipment_num
152: From rcv_headers_interface
153: Where invoice_num =invs_rec.invoice_num;
154: lv_trx_id := inv_lines_rec.po_line_location_id ||'_'|| lv_shipment_num;
155:
156: END IF;