Query to get attribute values of Inventory Item Template

1SELECT template_name,
2         USER_ATTRIBUTE_NAME,
3         CONTROL_LEVEL_DSP,
4         ATTRIBUTE_VALUE,
5         ENABLED_FLAG
6    FROM MTL_ITEM_TEMPL_ATTRIBUTES_V mita, MTL_ITEM_TEMPLATES_ALL_V mit
7   WHERE     mita.template_id = mit.template_id
8         AND template_name IN ('ITEM_TEMPLATE1', 'ITEM_TEMPLATE2') -- Item Template Names
9         AND attribute_name IN
10                (SELECT DISTINCT maad.attribute_name
11                   FROM mtl_attr_appl_dependencies maad,
12                        fnd_product_installations fpi
13                  WHERE    INV_Item_Util.Appl_Inst_Status (maad.application_id) =
14                              'I'
15                        OR (fpi.application_id = 431 AND fpi.status = 'I'))
16         AND NVL (attribute_group_id, -1) =
17                DECODE (999, 999, NVL (attribute_group_id, -1), 999)
18         AND control_level IN (1, 2)
19         AND user_attribute_name IS NOT NULL
20         AND attribute_name <> 'MTL_SYSTEM_ITEMS.DESC_FLEX'
21         AND attribute_name <>
22                DECODE (INV_Item_Util.PJM_Unit_Eff_Enabled (),
23                        'Y', 'Dummy',
24                        'MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL')
25         AND attribute_name <> 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION'
26ORDER BY 1, 2;