Skip to main content

Hi All,

I would like to get SELECT query to find ENTITIES from the cloud database. It should be a base view from the Aurena cloud. Since i want it to create List of Values(LOV), there view alone can be used.

I have tried with DICTIONARY_SYS_VIEW .But it did not work.

Is there any way to find a solution ?

Thanks in advance.

 

 

 

 

Hi @shva,

By executing the following SQL query in the database, you can view all the active logical units of components.

SELECT * FROM dictionary_sys_lu_active;

To view the components, you can use the following SQL query.

SELECT * FROM module_tab;

For an example, if you need to get all the active logical units of the module - FNDBAS, you can use a SQL query like below.

SELECT * FROM dictionary_sys_lu_active WHERE MODULE = 'FNDBAS';

 

Thank you so much for your quick response. It works.

Hi @ashen_malaka_ranasinghe,

I can not find this view name “dictionary_sys_lu_active” from  the View List name  while we are creating the  custom field when Data type is Reference and Reference format is Restricted.

Kindly find the attachments to get more in details.

 

Thanks. 

Hi @ashen_malaka_ranasinghe,

I can not find this view name “dictionary_sys_lu_active” from  the View List name  while we are creating the  custom field when Data type is Reference and Reference format is Restricted.

Kindly find the attachments to get more in details.

 

Thanks. 

Seems like this view is not exposed to the client.

Reply


Terms & ConditionsCookie settings