APPS.INV_OA_GEN_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

             /*-- Bulk insert the lot and serial records records
              FORALL i IN 1 .. p_assembly_lot_serial_tbl.COUNT
                INSERT INTO MTL_ALLOCATIONS_GTMP
                (Lot_number,
                 serial_number)
                 VALUES
                 (p_assembly_lot_serial_tbl(i).lot_number,
                  p_assembly_lot_serial_tbl(i).serial_number);  */

Line: 20

        DELETE MTL_ALLOCATIONS_GTMP;

Line: 23

	      INSERT INTO MTL_ALLOCATIONS_GTMP
	      (Lot_number,
	       serial_number)
	       VALUES
	       (p_assembly_lot_serial_tbl(i).lot_number,
                p_assembly_lot_serial_tbl(i).serial_number);