CDR_DF_NAMING_V View

Query the CDR_DF_NAMING_v view for object types.

select distinct OBJECT_TYPE_RC, from cdr_df_naming_v;

Then query for the object type you need, for example:

select * from cdr_df_naming_v where object_type_rc like '%$objtypes$object_type%';