Top Ten List的数据保存在表FND_USER_DESKTOP_OBJECTS中,登陆的时候从这个表读取,然后展示;在用户退出的时候,通过API:FND_SIGNON.UPDATE_NAVIGATOR把新的TOP Ten List更新到FND_USER_DESKTOP_OBJECTS表中。
SQL查看Top Ten List
Select function_name, object_name
from fnd_user_desktop_objects
where user_id =&user_id
and responsibility_id = &responsibility_id
and application_id = &application_id;
--附:查找user_id,responsibility_id,application_id的方法
SELECT user_id FROM fnd_user WHERE user_name = 'MFG';
select fr.application_id, fr.responsibility_id,fr.responsibility_key,frt.responsibility_name
from fnd_responsibility fr,fnd_responsibility_tl frt
where fr.responsibility_id = frt.responsibility_id
AND frt.responsibility_name LIKE 'Manufacturing%Distribution%Manager';
![](https://img-my.csdn.net/uploads/201207/15/1342348439_1173.jpg)
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7749128
======EOF======