Query to get attribute values of Inventory Item Template

Query to get attribute values of Inventory Item Template
Oracle apps Inventory item template extract
MTL_ITEM_TEMPLATES_ALL_V
SELECT template_name,
         USER_ATTRIBUTE_NAME,
         CONTROL_LEVEL_DSP,
         ATTRIBUTE_VALUE,
         ENABLED_FLAG
    FROM MTL_ITEM_TEMPL_ATTRIBUTES_V mita, MTL_ITEM_TEMPLATES_ALL_V mit
   WHERE     mita.template_id = mit.template_id
         AND template_name IN ('ITEM_TEMPLATE1', 'ITEM_TEMPLATE2') -- Item Template Names
         AND attribute_name IN
                (SELECT DISTINCT maad.attribute_name
                   FROM mtl_attr_appl_dependencies maad,
                        fnd_product_installations fpi
                  WHERE    INV_Item_Util.Appl_Inst_Status (maad.application_id) =
                              'I'
                        OR (fpi.application_id = 431 AND fpi.status = 'I'))
         AND NVL (attribute_group_id, -1) =
                DECODE (999, 999, NVL (attribute_group_id, -1), 999)
         AND control_level IN (1, 2)
         AND user_attribute_name IS NOT NULL
         AND attribute_name <> 'MTL_SYSTEM_ITEMS.DESC_FLEX'
         AND attribute_name <>
                DECODE (INV_Item_Util.PJM_Unit_Eff_Enabled (),
                        'Y', 'Dummy',
                        'MTL_SYSTEM_ITEMS.EFFECTIVITY_CONTROL')
         AND attribute_name <> 'MTL_SYSTEM_ITEMS.LONG_DESCRIPTION'
ORDER BY 1, 2;

For more reusable queries, click https://tech7.in/category/technologyblog/oracle/

Related posts: Upload your own post and refer it anywhere anytime:

Leave a Reply