Oracle EBS主界面的Top Ten List
http://blog.csdn.net/pan_tian/article/details/7749128
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';
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7749128