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,

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.  

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,

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