Top Ten List on the Oracle EBS Main Interface

The data in the Top Ten List is stored in the table fnd_user_shorttop_objects. The data is read from the table during login and displayed. When the user exits, the following APIs are used: FND_SIGNON.UPDATE_NAVIGATOR updates the new TOP Ten List to the FND_USER_DESKTOP_OBJECTS table.

1. SQL ViewTopTen List
2. SelectFunction_name, object_name
3. FromFnd_user_shorttop_objects
4. WhereUser_id = & user_id
5. AndResponsibility_id = & responsibility_id
6. AndApplication_id = & application_id;
8. -- Appendix: Method for searching user_id, responsibility_id, and application_id
9. SELECTUser_idFROMFnd_userWHEREUser_name ='Mfg';
11. SelectFr. application_id, fr. responsibility_id, fr. responsibility_key, frt. responsibility_name
12. FromFnd_responsibility fr, fnd_responsibility_tl frt
13. WhereFr. responsibility_id = frt. responsibility_id
14. ANDFrt. responsibility_nameLIKE 'Manufacturing % Distribution % manager';