The 'Referred By' report shows all objects, which the selected object uses directly or indirectly through multi-level dependencies tree.
For example, if the selected object is a stored procedure, on the first level of the tree will be objects, which this stored procedure uses directly, such as nested procedure's calls, tables and views. On all other tree levels show objects, which this stored procedure uses indirectly, for example, tables, which are used by a nested procedure, or triggers, which might be invoked by table update queries used in this stored procedure.
For a table, the first level of the report tree will show triggers, which can be invoked by operations on this table, such as INSERT/UPDATE/DELETE. If the trigger calls a stored procedure, the second level will display these stored procedure and so on.
The typical usage of this report:
The top panel of the report results, shows multi-level tree of the object dependencies.
The bottom panel shows the object, selected in the top panel, within a parent object syntax. For example, if you select a table, which is used directly by a stored procedure, the bottom panel will show the procedure's syntax and highlights all places where this table is used. To navigate between the multiple references in the same object syntax, use 'Prev' and 'Next' buttons on the bottom panel.
To run the 'Referring To' report:
Select an object, for which you want this report, and choose Dependencies -> Referring To from the popup menu.