Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.
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.
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
/
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.
Get Flower Effect
No comments:
Post a Comment