add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, August 11

Query to get item status attribute controls :

select

ia.attribute_group_id group_id,

ia.user_attribute_name_gui,

lk.meaning controlled_at,

ia.attribute_name,

-- ia.user_attribute_name,

ia.status_control_code,

ia.validation_code

from fnd_lookup_values lk,

mtl_item_attributes ia

where ia.control_level=lk.lookup_code

and lk.lookup_type='ITEM_CONTROL_LEVEL_GUI'

order by ia.attribute_group_id,1

/

No comments: