Query to get costing and Element link

Summary

SQL Query to get costing segment columns and element link name column

Content

Hi All,

 

I want to pull the costing segments along with credit, debit amounts and element link name column. I have developed a query as shown below but gives me duplicates and not the correct credit, debit amounts. Can someone please check this query and correct if I have to add any table or join in it.

 

SELECT DISTINCT

A.ELE_NAME,

A.ELE_CLASS,

A.ELE_ELIG_NAME,

A.COST_Charging_Dept,

A.COST_Charge_To_Dept,

A.OFFSET_Charging_Dept,

A.OFFSET_Charge_To_Dept,