🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

Thursday, August 11, 2011

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:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect