APPS.ONT_ASSGN_ITEM_FROM_PRH_TO_PRC dependencies on MTL_CATEGORY_SETS

Line 143: from mtl_category_sets

139: -- Get the structure id associate with category set 'Product Reporting Heirarchy'
140: begin
141: select structure_id, category_set_id
142: into prh_structure_id, prh_category_set_id
143: from mtl_category_sets
144: where category_set_name ='Product Reporting Hierarchy' ;
145: exception
146: -- When category set not found
147: when no_data_found then

Line 155: from mtl_category_sets

151: -- Get the structure id associate with category set 'Product Classification'
152: begin
153: select structure_id
154: into prc_structure_id
155: from mtl_category_sets
156: where category_set_id = prc_category_set_id;
157: exception
158: -- When category set not found
159: when no_data_found then

Line 164: from mtl_category_sets

160: -- Try to find the category by the name
161: begin
162: select structure_id,category_set_id
163: into prc_structure_id,prc_category_set_id
164: from mtl_category_sets
165: where category_set_name = 'Product Classification';
166: exception -- Now raise the exception that category set not found
167: when no_data_found then
168: raise catset_not_found;