add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, August 11

Query to find Item template attribute values :

select

it.template_name,

ita.attribute_name,

ita.attribute_value

from mtl_item_templates it,

mtl_item_templ_attributes ita

where it.template_name like 'ATO Model%'

and it.template_id=ita.template_id

and ita.attribute_value is not null

order by 1,2

No comments: