APPS.QP_MASS_MAINTAIN_UTIL dependencies on MTL_CATEGORIES_VL

Line 74: From Mtl_categories_vl

70: ELSIF p_product_attr = 'PRICING_ATTRIBUTE2' THEN
71: l_category_id := p_product_attr_val;
72: Select Description
73: Into l_product_desc
74: From Mtl_categories_vl
75: Where category_id = l_category_id;
76: ELSE
77: QP_UTIL.Get_Attribute_Code('QP_ATTR_DEFNS_PRICING',
78: p_product_attr_context,

Line 159: v_select_clause := v_select_clause || 'from mtl_categories_b_kfv cat, mtl_categories_vl cat_vl ';

155: *
156: elsif p_segment_code = 'ITEM_CATEGORY' then
157: l_appl_id := FND_GLOBAL.RESP_APPL_ID;
158: v_select_clause := 'select cat.CATEGORY_ID attribute_id, cat.CONCATENATED_SEGMENTS attribute_name, nvl(cat_vl.DESCRIPTION, cat.CONCATENATED_SEGMENTS) attribute_meaning ';
159: v_select_clause := v_select_clause || 'from mtl_categories_b_kfv cat, mtl_categories_vl cat_vl ';
160: v_select_clause := v_select_clause || 'where cat.category_id = cat_vl.category_id and cat.STRUCTURE_ID in ';
161: v_select_clause := v_select_clause || '(select structure_id from mtl_category_sets where category_set_id = ( select category_set_id from mtl_default_category_sets where functional_area_id = decode(' || l_appl_id || ',201,2,7)) and rownum < 2) ';
162: v_select_clause := v_select_clause || 'order by attribute_name';
163: x_select_stmt := 'Select * from (' || v_select_clause || ') AVVO';