CREATE OR REPLACE VIEW category_dependency_v
  AS
          SELECT
          source_obj.object_id AS source_objID,
          target_obj.object_id AS target_objID
          FROM
          all_dependencies dep, 
          user_objects source_obj,
          user_objects target_obj
          WHERE
          dep.name = source_obj.object_name AND
          dep.referenced_name = target_obj.object_name;