APPS.MRP_RELEASE_SO SQL Statements

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

Line: 23

  select header_id, top_model_line_id,org_id, item_type_code,
        order_quantity_uom
    from oe_order_lines_all
   where line_id = p_line_id;

Line: 30

  select primary_uom_code
  from mtl_system_items
  where inventory_item_id = p_item_id
  and   organization_id = p_org_id;

Line: 36

 SELECT h.order_number ,
        l.line_number||'.'|| l.shipment_number ||'.'||
        l.option_number ||'.'|| l.component_number ||'.'||l.service_number
FROM oe_order_lines_all l,
     oe_order_headers_all h
WHERE l.header_id = h.header_id
AND l.line_id = p_line_id;

Line: 56

  select line_id,
         header_id,
         org_id,
         nvl(ship_model_complete_flag,'N') ship_model_complete_flag
    from oe_order_lines_all
   where top_model_line_id = p_top_model_line_id
     and line_id <> p_line_id
     order by header_id;

Line: 127

     select
           date1, --schedule_ship_date,
           date2, --schedule_arrival_date,
           date3, --earliest_ship_date,
           number1, -- header_id,
           number2, -- line_id,
           number3, -- org_id,
           number4, -- operating_unit,
           number5, -- delivery_lead_time,
           char1, -- ship_method,
           date4, -- orig_schedule_ship_date,
           date5, -- orig_schedule_arrival_date,
           number6, -- orig_org_id,
           char2, -- orig_ship_method,
           number7, --quantity,
           char3, -- firm_flag,
           number8, -- orig_item_id,
           number9 -- inventory_item_id
        from msc_form_query
       where query_id = p_batch_id
        order by number1; -- header_id

Line: 154

       insert into msc_form_query
                        (query_ID,
                        LAST_UPDATE_DATE,
                        LAST_UPDATED_BY,
                        CREATION_DATE,
                        CREATED_BY,
           date1, --schedule_ship_date,
           date2, --schedule_arrival_date,
           date3, --earliest_ship_date,
           number1, -- header_id,
           number2, -- line_id,
           number3, -- org_id,
           number4, -- operating_unit,
           number5, -- delivery_lead_time,
           char1, -- ship_method,
           date4, -- orig_schedule_ship_date,
           date5, -- orig_schedule_arrival_date,
           number6, -- orig_org_id,
           char2, -- orig_ship_method,
           number7, --quantity,
           char3, -- firm_flag,
           number8, -- orig_item_id,
           number9) -- inventory_item_id)
                values (
                        p_batch_id,
                        sysdate,
                        -1,
                        sysdate,
                        -1,
			p_so_table(a).schedule_ship_date,
                        p_so_table(a).schedule_arrival_date,
                        p_so_table(a).earliest_ship_date,
                        p_so_table(a).header_id,
                        p_so_table(a).line_id,
                        p_so_table(a).Ship_from_org_id,
                        p_so_table(a).org_id,
                        p_so_table(a).delivery_lead_time,
                        p_so_table(a).shipping_method_code,
                        p_so_table(a).orig_schedule_ship_date,
                        p_so_table(a).orig_schedule_arrival_date,
                        p_so_table(a).orig_ship_from_org_id,
                        p_so_table(a).orig_shipping_method_code,
                        p_so_table(a).orig_ordered_quantity,
                        p_so_table(a).firm_demand_flag,
                        p_so_table(a).orig_inventory_item_id,
                        p_so_table(a).inventory_item_id);

Line: 344

   ' 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: 519

   ' 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: 574

         OE_SCHEDULE_GRP.Update_Scheduling_Results(
              p_so_table,
              p_batch_id,
              x_return_status);

Line: 584

      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: 602

                ' 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: 615

FND_FILE.PUT_LINE(FND_FILE.LOG,'update fails for line id '||p_so_table(a).line_id||', Order Number: '||p_order_num||', Line Number: '||p_line_num||', om return status ='||p_so_table(a).x_return_status);

Line: 626

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

Line: 641

                ' 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: 649

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

Line: 653

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

Line: 658

                ' 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 ';