Work definition query with Resource and item quantity and price

Dear All,

We have requirement to build a report which contains below columns

1. Work definition name
2. FG item (Finished goods)
3. All RM item (Raw Material)
4. Resources
5. Item price (RM, Resource & FG)
6. Required quantity)
7. Organization

I'm struggling to create report but unable to get desired data.

Please help me if you have already build such SQL query or help me with reference.

Thanks,

Manish