APPS.ICX_AK_JAVA_QUERY SQL Statements

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

Line: 106

procedure update_oc_kids(p_group_id in number) is

cursor option_classes is
select row_id,
       sort_order
from   icx_config_components_web_v
where  group_id = p_group_id
and    bom_item_type in (1,2)
order by sort_order;

Line: 122

  select count(*) into l_option_count
  from icx_config_components_web_v
  where group_id = p_group_id
  and   bom_item_type = 4
  and   substr(sort_order,1,length(sort_order)-4) = oc.sort_order
  and   selected_flag = 'Y';

Line: 129

  update icx_config_components_web_v
  set number_kids = l_option_count
  where row_id = oc.row_id;