Customer Contracts - Fluid page / Contract Profit Margin

Hi,

For some reasons, Contract Profit Margin, a tile in the Customer Contracts Fluid page, is not producing for us the desired results for the profit margin which is calculated based on actual costs and revenues. Query that supports the data retrieval and corresponding pivot grid is: PC_CONTRACT_MARGIN. This query is using a view table (record) named PC_CA_MARGN_VW along with a couple more records.

Can you please provide the sql behind the view table PC_CA_MARGIN_VW so I can be able to conclude why our data do not match what is displayed/captured in the Contract Profit Margin tile?