APPS.GMF_CBOM_REP_PKG dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 347: FROM mtl_default_category_sets mdc,

343:
344: BEGIN
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

Line 386: l_cat_where := l_cat_where || ' FROM mtl_default_category_sets mdc, mtl_category_sets mcs, mtl_item_categories mic, ' ;

382: BEGIN
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 ' ;