           tree.name_path,
           tree.path_len,
           tree.type,
-          tree.usage,
+          case
+             when tree.usage = 'SQL_ID' then  -- make SQL_ID pseudo-usage appear as SQL_STMT
+                'SQL_STMT'
+             else
+                 tree.usage
+          end                             as usage,
           refs.owner                      as ref_owner,           -- decl_owner
           refs.object_type                as ref_object_type,     -- decl_object_type
           refs.object_name                as ref_object_name,     -- decl_object_name

          tree.procedure_scope,
          lpad(' ', 2 * (tree.path_len - 1))
                || case
                      when tree.usage = 'SQL_STMT' then
                         tree.type || ' statement (sql_id: ' || tree.name || ')'
                      else
                         tree.name || ' (' || lower(tree.type) || ' ' || lower(tree.usage) || ')'
                   end                    as name_usage,

                type,
                object_name,
                object_type,
                nvl2(sql_id, 'SQL_ID', 'SQL_STMT') as usage, -- new, artificial usage
                usage_id,
                line,
                col,
