The following lines contain the word 'select', 'insert', 'update' or 'delete':
select CATEGORY_SET_NAME, DESCRIPTION
into :deflt_cat_set.category_set_name, :deflt_cat_set.category_set_description
from MTL_CATEGORY_SETS_VL
where CATEGORY_SET_ID = :deflt_cat_set.category_set_id;
Select 'X'
Into buffer
FROM dual
WHERE EXISTS (
SELECT 'X'
From MTL_SYSTEM_ITEMS_B Item
Where Item.INVENTORY_ITEM_FLAG = 'Y'
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat
Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
And Cat.CATEGORY_SET_ID = P_Category_Set_Id
)
);
Select STRUCTURE_ID
Into Old_Structure_id
From MTL_CATEGORY_SETS_B
WHERE CATEGORY_SET_ID = (select category_set_id
From MTL_DEFAULT_CATEGORY_SETS
Where FUNCTIONAL_AREA_ID = 2);
Select STRUCTURE_ID
Into New_Structure_id
From MTL_CATEGORY_SETS_B
WHERE CATEGORY_SET_ID = P_Category_Set_Id;
Select count(*)
Into Po_Count
From Po_Line_Types_b
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into Po_Count
From PO_REQEXPRESS_LINES_ALL
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into Po_Count
From PO_AGENTS
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into Po_Count
From PO_APPROVED_SUPPLIER_LIST
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into Po_Count
From PO_ASL_ATTRIBUTES
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into Po_Count
From PO_REQUISITION_LINES_ALL
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into Po_Count
From PO_LINES_ALL
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into Po_Count
From RCV_SHIPMENT_LINES
where category_id is NOT NULL
and rownum < 2;
Select DISTINCT 'X'
Into buffer
From MTL_SYSTEM_ITEMS_B Item
Where ( Item.PURCHASING_ITEM_FLAG = 'Y' OR
Item.INTERNAL_ORDER_FLAG = 'Y' )
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat
Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
And Cat.CATEGORY_SET_ID = P_Category_Set_Id
);
Select 'X'
Into buffer
FROM dual
WHERE EXISTS (
SELECT 'X'
From MTL_SYSTEM_ITEMS_B Item
Where Item.MRP_PLANNING_CODE <> 6
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat
Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
And Cat.CATEGORY_SET_ID = P_Category_Set_Id
)
);
Select STRUCTURE_ID
Into Old_Structure_id
From MTL_CATEGORY_SETS_B
WHERE CATEGORY_SET_ID = (select category_set_id
From MTL_DEFAULT_CATEGORY_SETS
Where FUNCTIONAL_AREA_ID = 5);
Select STRUCTURE_ID
Into New_Structure_id
From MTL_CATEGORY_SETS_B
WHERE CATEGORY_SET_ID = P_Category_Set_Id;
/* Select count(*)
Into co_Count
From Po_Line_Types_b
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into co_Count
From CST_AP_VARIANCE_BATCHES
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into co_Count
From CST_COST_TYPE_HISTORY
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into co_Count
From CST_COST_UPDATES
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into co_Count
From CST_ITEM_OVERHEAD_DEFAULTS
where category_id is NOT NULL
and rownum < 2;
Select count(*)
Into co_Count
From CST_ITEM_OVERHEAD_DEFAULTS_EFC
where category_id is NOT NULL
and rownum < 2;
l_dyn_sql := ' Select count(*) '||
' From CST_MATERIAL_OVHD_RULES '||
' where category_id is NOT NULL '||
' and rownum < 2';
Select count(*)
Into co_Count
From CST_SC_ROLLUP_HISTORY
where category_id is NOT NULL
and rownum < 2;
Select DISTINCT 'X'
Into buffer
From MTL_SYSTEM_ITEMS_B Item
Where Item.COSTING_ENABLED_FLAG = 'Y'
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat
Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
And Cat.CATEGORY_SET_ID = P_Category_Set_Id
);
Select 'X'
Into buffer
FROM dual
WHERE EXISTS (
SELECT 'X'
From MTL_SYSTEM_ITEMS_B Item
Where Item.ENG_ITEM_FLAG = 'Y'
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat
Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
And Cat.CATEGORY_SET_ID = P_Category_Set_Id
)
);
Select 'X'
Into buffer
FROM dual
WHERE EXISTS (
SELECT 'X'
From MTL_SYSTEM_ITEMS_B Item
Where Item.CUSTOMER_ORDER_FLAG = 'Y'
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat
Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
And Cat.CATEGORY_SET_ID = P_Category_Set_Id
)
);
SELECT DECODE( COUNT(*), 0, 0, -1 )
INTO l_count
FROM MTL_SYSTEM_ITEMS_B Item
WHERE
Item.EAM_ITEM_TYPE IS NOT NULL
AND NOT EXISTS
( SELECT 'X'
FROM MTL_ITEM_CATEGORIES Cat
WHERE
Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
AND Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
AND Cat.CATEGORY_SET_ID = P_Category_Set_Id
);
SELECT DECODE( COUNT(*), 0, 0, -1 )
INTO l_count
FROM MTL_SYSTEM_ITEMS_B Item
WHERE
Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY')
AND NOT EXISTS
( SELECT 'X'
FROM MTL_ITEM_CATEGORIES Cat
WHERE
Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
AND Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
AND Cat.CATEGORY_SET_ID = P_Category_Set_Id
);
SELECT DECODE( COUNT(*), 0, 0, -1 )
INTO l_count
FROM MTL_SYSTEM_ITEMS_B Item
WHERE
Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION', 'USAGE')
AND NOT EXISTS
( SELECT 'X'
FROM MTL_ITEM_CATEGORIES Cat
WHERE
Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
AND Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
AND Cat.CATEGORY_SET_ID = P_Category_Set_Id
);
Select 'X'
Into buffer
FROM dual
WHERE EXISTS (
SELECT 'X'
From MTL_SYSTEM_ITEMS_B Item
Where ( Item.CUSTOMER_ORDER_FLAG = 'Y' OR
Item.INTERNAL_ORDER_FLAG = 'Y' )
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat
Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
And Cat.CATEGORY_SET_ID = P_Category_Set_Id
)
);
Select 'X'
Into buffer
From MTL_ITEM_CATEGORIES Cat,
MTL_DEFAULT_CATEGORY_SETS DefCat
Where DefCat.FUNCTIONAL_AREA_ID = 12
And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat1
Where Cat1.INVENTORY_ITEM_ID = Cat.INVENTORY_ITEM_ID
And Cat1.ORGANIZATION_ID = Cat.ORGANIZATION_ID
And Cat1.CATEGORY_SET_ID = P_Category_Set_Id
)
And rownum=1;
Select 'X'
Into buffer
From MTL_ITEM_CATEGORIES Cat,
MTL_DEFAULT_CATEGORY_SETS DefCat
Where DefCat.FUNCTIONAL_AREA_ID = 21
And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
And NOT EXISTS
( Select 'X'
From MTL_ITEM_CATEGORIES Cat1
Where Cat1.INVENTORY_ITEM_ID = Cat.INVENTORY_ITEM_ID
And Cat1.ORGANIZATION_ID = Cat.ORGANIZATION_ID
And Cat1.CATEGORY_SET_ID = P_Category_Set_Id
)
And rownum=1;
SELECT structure_id
INTO old_structure_id
FROM mtl_category_sets_b
WHERE category_set_id = (SELECT category_set_id
FROM mtl_default_category_sets
WHERE functional_area_id = 19);
SELECT structure_id
INTO new_structure_id
FROM mtl_category_sets_b
WHERE category_set_id = P_Category_Set_Id;
SELECT COUNT (*)
INTO opm_count
FROM cm_cmpt_mtl
WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;
SELECT COUNT (*)
INTO opm_count
FROM cm_whse_eff
WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;
SELECT COUNT (*)
INTO opm_count
FROM cm_whse_src
WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;
SELECT COUNT (*)
INTO opm_count
FROM gmf_burden_percentages
WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;
SELECT COUNT (*)
INTO opm_count
FROM gmf_lot_costed_items
WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;
SELECT 'X'
INTO buffer
FROM DUAL
WHERE EXISTS
(SELECT 'X'
FROM mtl_system_items_b item
WHERE item.process_costing_enabled_flag = 'Y'
AND item.organization_id IN (SELECT ood.organization_id
FROM org_organization_definitions ood
WHERE ood.inventory_enabled_flag = 'Y')
AND NOT EXISTS
(SELECT 'X'
FROM mtl_item_categories cat
WHERE cat.inventory_item_id = item.inventory_item_id
AND cat.organization_id = item.organization_id
AND cat.category_set_id = P_Category_Set_Id));