Item Template query in oracle apps

Item Template query in oracle apps

In this post , We will discuss about Item Template query in oracle apps. This Query will help to extract the detail Item template information with the Item Attribute Name with values in oracle apps.Item Template is the set of Item attributes with Values which helps to set these attributes values for an Inventory Item. Each Inventory Item like Purchasing Item , Inventory Item, Manufacturing Item , So all these types of items have different Item attributes values. So we do create different Item Template for each types of Items , Like Purchasing Template , Inventory Template and when we do create the New Item , Based on the Type of item , we do attach these item templates to set the item attribute values in oracle apps because its very time consuming thing to set the item attributes values for each item and its easy to just attach the item template with the item. Please find below the detail Item Template query in oracle apps.

Most Important Tables used by Item Template query in oracle apps

1.mtl_item_templates

2.mtl_item_templ_attributes

Detail Item Template query in oracle apps

select
it.template_name,

it.description  Template_description,

ita.attribute_name,

ita.attribute_value,

ita.REPORT_USER_VALUE

from apps.mtl_item_templates it,

apps.mtl_item_templ_attributes ita

where 1=1

AND it.template_name='Purchased Item - A1'

and it.template_id=ita.template_id

Output of the Item Template query in oracle apps