APPS.ICX_AK_JAVA_QUERY dependencies on ICX_CONFIG_COMPONENTS_WEB_V

Line 111: from icx_config_components_web_v

107:
108: cursor option_classes is
109: select row_id,
110: sort_order
111: from icx_config_components_web_v
112: where group_id = p_group_id
113: and bom_item_type in (1,2)
114: order by sort_order;
115:

Line 123: from icx_config_components_web_v

119:
120: for oc in option_classes loop
121:
122: select count(*) into l_option_count
123: from icx_config_components_web_v
124: where group_id = p_group_id
125: and bom_item_type = 4
126: and substr(sort_order,1,length(sort_order)-4) = oc.sort_order
127: and selected_flag = 'Y';

Line 129: update icx_config_components_web_v

125: and bom_item_type = 4
126: and substr(sort_order,1,length(sort_order)-4) = oc.sort_order
127: and selected_flag = 'Y';
128:
129: update icx_config_components_web_v
130: set number_kids = l_option_count
131: where row_id = oc.row_id;
132:
133: end loop;