APPS.GMPPSRP dependencies on MTL_CATEGORIES_KFV

Line 238: x_select := x_select || ' mtl_categories_kfv mca, ';

234: IF G_forg IS NOT NULL OR G_torg IS NOT NULL THEN
235: x_select := x_select || ' mtl_parameters mpa, ';
236: END IF;
237: IF G_fcategory IS NOT NULL OR G_tcategory IS NOT NULL THEN
238: x_select := x_select || ' mtl_categories_kfv mca, ';
239: END IF;
240:
241: x_select := x_select ||
242: ' mtl_system_items_kfv msi, '||

Line 1003: FROM mtl_categories_kfv

999: v_category VARCHAR2(240);
1000: BEGIN
1001:
1002: SELECT concatenated_segments INTO v_category
1003: FROM mtl_categories_kfv
1004: WHERE category_id = p_category_id;
1005:
1006: RETURN v_category;
1007: