Solved

presentation object with lu name

  • 21 February 2022
  • 4 replies
  • 243 views
M
Rank
Userlevel 5
Badge +10
  • m.arif
  • Sidekick (Customer)
  • 107 replies

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.

 

icon

Best answer by Thushitha Chandrasiri 21 February 2022, 19:21

View original
This topic has been closed for comments

4 replies

Thushitha Chandrasiri
Rank
Userlevel 7
Badge +20

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
Rank
Userlevel 5
Badge +10

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.  

Thushitha Chandrasiri
Rank
Userlevel 7
Badge +20

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,

Thushitha Chandrasiri - Follow my LinkedIn profile and contact me via - https://www.linkedin.com/in/thushitha-a-chandrasiri-32a2b2134/
M
Rank
Userlevel 5
Badge +10

@ThushAsanka  , is there a way to classify by type of object , form , overview , dialog as example in table level.

Terms & ConditionsCookie settings