report program to list out characteristics having dependency type procedure

Hi folks,

My requirement is to generate a report, in which i have to list out characteristics having dependecy type procedure(7).

The tables are CABN(characteristic),CUOB(Assignment of Object to Dependency),CUKB(Administrative Information for Dependency Maintenance).By linking these tables we can get the result.

Pls provide the code to achieve the above task.It's urgent.We need to write a select query for that.

Regards,

Ramesh