TDS amount repeating for each distribution line R12

Hi,

I developed a TDS Report which will shows the TDS amount deducted for each invoice distribution line.

I am using JAI_AP_TDS_INVOICES table for calculating TDS amount Also I tried with JAI_AP_TDS_THHOLD_TRXS table .

When I started using this table I was getting repeated tds amount.

After analysing I have added some table and did joining. Now it is coming single time.

But in the scenario, where tds is deducted more then one time in distribution line, the tds amount which was coming single time, is now repeating times whenever tds deducted.

Ex: If the tds deducted one time, I am getting tds amount one time. Up to here it is fine.