[Home] [Help]
86: WHERE template_id = cp_template_id
87: AND enabled_flag = 'Y'
88: AND attribute_name IN
89: (SELECT a.attribute_name
90: FROM mtl_item_attributes a
91: WHERE NVL(a.status_control_code, 3) <> 1
92: AND a.control_level IN (1, 2)
93: AND a.attribute_group_id_gui IS NOT NULL);
94: