Need a sql to fetch costing of department for employee

Summary:

Need a sql to fetch costing of department for employee

Person is in department A, need below details as query result:

Person Number, Department Name, Cost segment details for Deparment costing

It will be great if same can be achieved via OTBI - please guide.

Regards,

Abhishek