[Home] [Help]
926: SELECT dt.table_name, dt.column_name , dt.data_type
927: FROM dba_tab_columns dt
928: WHERE (dt.table_name , dt.owner)
929: IN ( SELECT s.table_name , s.table_owner
930: FROM user_synonyms s , user_objects o
931: WHERE 1 = 1
932: AND o.object_name = l_event_class_set(k).reporting_view_name
933: AND o.object_type = 'SYNONYM'
934: AND s.synonym_name = o.object_name ) ) utc,