DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_TP_BATCHES

Line 35: 1. jai_rcv_tp_batches

31:
32: This clean up also has introduced two tables which help in tracking
33: third party invoices.
34:
35: 1. jai_rcv_tp_batches
36: 2. jai_rcv_tp_invoices
37:
38:
39: 14-mar-2005 bug#4284505 ssumaith - version 115.1

Line 199: select jai_rcv_tp_batches_s.nextval from dual;

195: GROUP BY jrt.shipment_header_id
196: ORDER BY jrt.shipment_header_id;
197:
198: cursor c_get_tp_batch_id is
199: select jai_rcv_tp_batches_s.nextval from dual;
200:
201: cursor c_no_of_invoice_generated(cp_batch_id number) is
202: select count(batch_invoice_id)
203: from jai_rcv_tp_invoices

Line 285: insert into jai_rcv_tp_batches

281: p_simulation => nvl(p_simulation, 'N')
282: );
283:
284:
285: insert into jai_rcv_tp_batches
286: (
287: batch_id ,
288: shipment_header_id ,
289: process_flag ,