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;
Related posts:
Upload your own post and refer it anywhere anytime:
Like this:
Like Loading...