APPS.MRP_RESCHEDULE_PO SQL Statements

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

Line: 56

    select ALLOW_RELEASE_FLAG, instance_code
      from MRP_AP_APPS_INSTANCES_ALL
     where instance_id = p_instance_id
       and nvl(A2M_DBLINK, '-1') = p_dblink;

Line: 102

   ' select old_need_by_date,'||
          ' new_need_by_date,'||
          ' po_header_id,'||
          ' po_line_id,'||
          ' po_number,'||
          ' action'||
 ' from msc_purchase_order_interface'||p_dblink||
 ' where sr_instance_id = '||p_instance_id||
   ' and batch_id ='||p_batch_id ||
   ' order by action, po_number ';

Line: 214

             x_need_by_dates_old.delete;

Line: 215

             X_need_by_dates.delete;

Line: 216

             X_po_line_ids.delete;

Line: 217

             X_shipment_nums.delete;

Line: 218

             x_estimated_pickup_dates.delete;

Line: 219

             x_ship_methods.delete;

Line: 288

 sql_stmt:= ' delete from msc_purchase_order_interface'||p_dblink||
             ' where sr_instance_id = :p_instance_id '||
             ' and batch_id = :p_batch_id ';

Line: 366

      select nvl(poll.promised_date,poll.need_by_date),1
      from   po_line_locations_all poll
      where  poll.po_line_id = v_line_id
        and  poll.po_header_id = v_header_id
        and  poll.shipment_num = nvl(v_ship_num,poll.shipment_num);

Line: 374

            SELECT org_id
            FROM po_headers_all
            WHERE po_header_id = p_po_header_id;

Line: 384

 select line_num
 from po_lines_all
 where po_line_id = p_line_id;

Line: 454

         v_promised_date.delete;

Line: 455

         v_rec.delete;