{Base Table} -> {Views} Linkages

[Salil_V]

Hi All,

We are trying to find out a way to identify {base table} -> {views} linkages.

I know we have some available in SYS.VIEWS but this does not contain everything. Does anybody knows where/how we can get this entire list.

Regards,

Salil

[Salil_V]

I used "SYS"."OBJECT_DEPENDENCIES" and passed the table to get list of Views using this table directly/indirectly. But i need a way to map the view/field to table/field mainly for Calc Views and Hierarchy Views.

I used "SYS"."CS_VIEW_COLUMNS" but it does not cover all the views. So may be i might need to query multiple views to get me the complete data set.

Any pointers will be helpful.