2546: WHERE mit.template_id = cp_template_id;
2547:
2548: CURSOR c_get_template_attributes (cp_template_id IN NUMBER) IS
2549: SELECT attribute_name, attribute_value
2550: FROM mtl_item_templ_attributes
2551: WHERE template_id = cp_template_id
2552: AND enabled_flag = 'Y'
2553: AND attribute_name IN
2554: ( SELECT a.attribute_name
2572: -- Attributes that can be applied only through the Org Specific templates.
2573:
2574: CURSOR c_get_org_template_attributes (cp_template_id IN NUMBER) IS
2575: SELECT attribute_name, attribute_value
2576: FROM mtl_item_templ_attributes
2577: WHERE template_id = cp_template_id
2578: AND enabled_flag = 'Y'
2579: AND attribute_name IN
2580: ( SELECT a.attribute_name