APPS.MRP_RELEASE_SO SQL Statements

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

Line: 23

  select header_id
    from oe_order_lines
   where line_id = p_line_id;

Line: 29

  select org_id
  from oe_order_lines_all
  where line_id = p_line_id;

Line: 50

   ' select schedule_ship_date,'||
          ' schedule_arrival_date,'||
          ' earliest_ship_date, '||
          ' header_id,'||
          ' line_id,'||
          ' org_id,'||
          ' operating_unit,'||
          ' delivery_lead_time,'||
          ' ship_method, '||
          ' orig_schedule_ship_date,'||
          ' orig_schedule_arrival_date,'||
          ' orig_org_id,'||
          ' orig_ship_method, '||
          ' quantity, '||
          ' decode(firm_flag,1,''Y'',''N''), '||
          ' orig_item_id, '||
          ' inventory_item_id '||
 ' from msc_sales_order_interface'||p_dblink||
 ' where sr_instance_id = : p_instance_id '||
   ' and source_type is null '||
   ' and batch_id = :p_batch_id ';

Line: 129

   ' select schedule_ship_date,'||
          ' schedule_arrival_date,'||
          ' earliest_ship_date, '||
          ' header_id,'||
          ' line_id,'||
          ' org_id,'||
          ' quantity '||
 ' from msc_sales_order_interface'||p_dblink||
 ' where sr_instance_id = : p_instance_id '||
   ' and source_type =100 '||
   ' and batch_id = :p_batch_id ';

Line: 178

         OE_SCHEDULE_GRP.Update_Scheduling_Results(
              p_so_table,
              p_batch_id,
              x_return_status);

Line: 188

      AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results(
              1.0,
              FND_API.g_false,
              FND_API.g_false,
              FND_API.g_valid_level_full,
              p_crm_so_table,
              x_crm_return_status);

Line: 205

                ' update msc_sales_order_interface'||p_dblink||
                 '   set return_status = :p_status '||
                 ' where sr_instance_id = :p_instance_id '||
                   ' and batch_id = :p_batch_id '||
                   ' and line_id = :p_line_id ';

Line: 212

FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_so_table(a).line_id||', om return status ='||p_so_table(a).x_return_status);

Line: 223

FND_FILE.PUT_LINE(FND_FILE.LOG,'update scceeds for line id'||p_so_table(a).line_id);

Line: 233

                ' update msc_sales_order_interface'||p_dblink||
                 '   set return_status = :p_status '||
                 ' where sr_instance_id = :p_instance_id '||
                   ' and batch_id = :p_batch_id '||
                   ' and source_type = 100 ';

Line: 241

        FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_crm_so_table(a).order_line_id);

Line: 245

        FND_FILE.PUT_LINE(FND_FILE.LOG,'update successfully for line id '||p_crm_so_table(a).order_line_id);

Line: 250

                ' delete from msc_sales_order_interface'||p_dblink||
                 ' where sr_instance_id = :p_instance_id '||
                   ' and batch_id = :p_batch_id '||
                   ' and return_status is null ';