APPS.WIP_MTL_ROLLBACK_CLEANUP SQL Statements

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

Line: 3

Procedure DELETE_ROWS (trx_header_id NUMBER) IS
BEGIN
      -- Delete predefined serial numbers
      delete mtl_serial_numbers
      where group_mark_id = trx_header_id ;

Line: 10

      update mtl_serial_numbers
      set group_mark_id = null,
          line_mark_id = null,
          lot_line_mark_id = null
      where group_mark_id = trx_header_id;

Line: 17

      delete mtl_serial_numbers_temp
      where group_header_id = trx_header_id;

Line: 20

      delete mtl_transaction_lots_temp
      where group_header_id = trx_header_id;

Line: 23

      delete mtl_material_transactions_temp
      where transaction_header_id = trx_header_id;

Line: 31

end DELETE_ROWS;