DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on MTL_CATEGORY_SETS

Line 303: ' mtl_category_sets mcs '||

299: x_select := x_select ||
300: ' mtl_system_items_kfv msi, '||
301: ' mtl_item_categories mic, '||
302: ' ps_schd_dtl psd, '||
303: ' mtl_category_sets mcs '||
304: ' WHERE '||
305: ' mcs.category_set_id = to_char(:category_set_id) '||
306: ' AND mcs.structure_id = to_char(:structure_id) '||
307: ' AND mic.category_set_id = mcs.category_set_id '||

Line 1895: FROM mtl_category_sets

1891: v_category_set_name VARCHAR2(30);
1892: BEGIN
1893:
1894: SELECT category_set_name INTO v_category_set_name
1895: FROM mtl_category_sets
1896: WHERE category_set_id = p_category_set_id;
1897:
1898: RETURN v_category_set_name;
1899: