List of all backend tables which stores Custom Objects Details

Summary:

List of all backend tables which stores Custom Objects Details

Content (required):

Whenever custom object is created, Oracle assigns the backend table automatically. we would like to get the list of all possible tables that custom object would get assigned when it gets created.

We use below query to identify created custom object table names:

select TABLE_NAME from fusion.adf_extensible_table where TABLE_ID IN (select TABLE_ID from fusion.adf_extensible_table_usage where ENTITYDEF_FULLNAME like '%customobjAPIName%')

We would like to get the complete list of all possible custom object table names which can be occupied in future as well.