Report showing each costs along with capitalization status

Summary:

Hi Team

We are trying to build a expenditure detail report which will show the each expenditure details of a project similar to the manage project costs page. In addition to that, the report will also have two more columns (Capitalization status (if it is already capitalized or not), asset number) for each costs. Can you please help if anyone of you have built a similar report? if so, can you please share SQL query that will help us to get the last two columns particularly (Capitalization status, asset number) for each expenditure (i.e. cost). Thanks in Advance for your help