Solved

presentation object with lu name

Forum|Forum|3 years ago
February 21, 2022
4 replies
321 views

+10

m.arif
Sidekick (Customer)

i want to list out the logical unit name along with presentation object id and description. is there a way to get the information about module , label as per navigator and lu name along with presentation object.

Best answer by Thushitha Chandrasiri

Hi @m.arif , I thought you would need the presentation objects only for form, dialog and tbw type of presentation objects.

If all po’s are needed you’ll exclude that where clause.

Thanks,

This topic has been closed for replies.

+21

Thushitha Chandrasiri
Superhero (Partner)
Forum|Forum|3 years ago
February 21, 2022

Hi @m.arif ,

I think you can get those details from pres_object_dic_security view.

You may use the below sql query.

select po_id, pres_object_api.Get_description(po_id) po_description, lu, module, module_name
from pres_object_dic_security
where pres_object_sec_sub_type in ('Base View','View')

Thanks,

Thushitha Chandrasiri - Follow my LinkedIn profile and contact me via - https://www.linkedin.com/in/thushitha-a-chandrasiri-32a2b2134/

M

Like

M

+10

m.arif
Author
Sidekick (Customer)
Forum|Forum|3 years ago
February 21, 2022

Thanks @ThushAsanka , what do you mean by the ‘Base View’,’View’, . there is one more table “FND_Navigator_all” , does this hold all the information with regards to presentation objects to permission sets.