DBA Data[Home] [Help]

APPS.GMPPSRP dependencies on MTL_CATEGORY_SETS

Line 245: ' mtl_category_sets mcs '||

241: x_select := x_select ||
242: ' mtl_system_items_kfv msi, '||
243: ' mtl_item_categories mic, '||
244: ' ps_schd_dtl psd, '||
245: ' mtl_category_sets mcs '||
246: ' WHERE '||
247: ' mcs.category_set_id = to_char(:category_set_id) '||
248: ' AND mcs.structure_id = to_char(:structure_id) '||
249: ' AND mic.category_set_id = mcs.category_set_id '||

Line 749: FROM mtl_category_sets

745: v_category_set_name VARCHAR2(30);
746: BEGIN
747:
748: SELECT category_set_name INTO v_category_set_name
749: FROM mtl_category_sets
750: WHERE category_set_id = p_category_set_id;
751:
752: RETURN v_category_set_name;
753: