APPS.GMF_CBOM_REP_PKG dependencies on MTL_CATEGORIES_KFV

Line 342: l_category mtl_categories_kfv.CONCATENATED_SEGMENTS%TYPE := '';

338: REM+=========================================================================+
339: */
340: FUNCTION get_category_name(v_cat_id IN NUMBER) RETURN VARCHAR2 IS
341:
342: l_category mtl_categories_kfv.CONCATENATED_SEGMENTS%TYPE := '';
343:
344: BEGIN
345:
346: SELECT mc.concatenated_segments INTO l_category

Line 349: mtl_categories_kfv mc

345:
346: SELECT mc.concatenated_segments INTO l_category
347: FROM mtl_default_category_sets mdc,
348: mtl_category_sets mcs,
349: mtl_categories_kfv mc
350: WHERE mdc.functional_area_id = 19
351: AND mdc.category_set_id = mcs.category_set_id
352: AND mcs.structure_id = mc.structure_id
353: AND mc.category_id = v_cat_id ;

Line 387: l_cat_where := l_cat_where || ' mtl_categories_kfv mc WHERE mdc.functional_area_id = 19 ' ;

383: -- Build the order by clause
384: IF p_from_cat IS NOT NULL OR p_to_cat IS NOT NULL THEN
385: l_cat_where := ' AND EXISTS (SELECT mc.concatenated_segments ' ;
386: l_cat_where := l_cat_where || ' FROM mtl_default_category_sets mdc, mtl_category_sets mcs, mtl_item_categories mic, ' ;
387: l_cat_where := l_cat_where || ' mtl_categories_kfv mc WHERE mdc.functional_area_id = 19 ' ;
388: l_cat_where := l_cat_where || ' AND mdc.category_set_id = mcs.category_set_id AND mcs.category_set_id = mic.category_set_id ' ;
389: l_cat_where := l_cat_where || ' AND mcs.structure_id = mc.structure_id AND mic.inventory_item_id = ccd.inventory_item_id ' ;
390: l_cat_where := l_cat_where || ' AND mic.organization_id = ccd.organization_id AND mic.category_id = mc.category_id ' ;
391: l_cat_where := l_cat_where || ' AND mc.concatenated_segments >= NVL(:P_FROM_COST_CATEGORY,mc.concatenated_segments) ' ;