[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ic.inventory_item_id,
ic.organization_id,
prh.segment8,
prh.category_id,
prh.description
from mtl_item_categories ic,
mtl_categories_b prc,
mtl_categories_b prh
where prc.category_id = ic.category_id
and prc.structure_id = prc_structure_id
and ic.category_set_id = prc_category_set_id
and prh.enabled_flag = 'Y'
and prh.segment8 = prc.segment1
and prh.structure_id = prh_structure_id
and not EXISTS
(select 'x'
from mtl_item_categories ic2, mtl_categories_b c2
where c2.category_id = ic2.category_id
and c2.structure_id = prh_structure_id
and ic2.category_set_id = prh_category_set_id
and ic2.inventory_item_id = ic.inventory_item_id
and ic2.organization_id = ic.organization_id
and c2.segment8 = prc.segment1
);
select 'x'
from mtl_item_categories ic,
mtl_system_items_b msi,
mtl_categories_b c
where msi.organization_id = p_org_id
and msi.inventory_item_id = p_inventory_item_id
and msi.inventory_item_id = ic.inventory_item_id
and msi.organization_id = ic.organization_id
and ic.category_id = c.category_id
and c.structure_id = 101
and c.segment1 in ('SW LIC', 'SW FIN')
and msi.enabled_flag = 'Y'
and msi.attribute10||''='IBOM';
select structure_id, category_set_id
into prh_structure_id, prh_category_set_id
from mtl_category_sets
where category_set_name ='Product Reporting Hierarchy' ;
select structure_id
into prc_structure_id
from mtl_category_sets
where category_set_id = prc_category_set_id;
select structure_id,category_set_id
into prc_structure_id,prc_category_set_id
from mtl_category_sets
where category_set_name = 'Product Classification';
delete from mtl_item_categories
where category_id in
(
select c.category_id
from mtl_categories_b c
where c.structure_id = prh_structure_id
and c.enabled_flag = 'N'
);
if nvl(l_dummy_for_x,'y')='x' then -- Insert only when this item satisfies the cursor.
l_dummy_for_x := null;