Query to display the tax amount reflected accounts.

Hi,

I have a requirement to display the tax amounts (CGST,SGST,IGST) reflected accounts.

I have the details of receipt and PO. I tried the below query but it is giving some duplicate data.

select

rsh.receipt_num,rsh.shipment_header_id,

rcv.transaction_id,rcv.shipment_line_id,rcv.po_header_id,rcv.po_line_id,

jtl.det_factor_id,jtl.tax_line_id,jtl.party_id,jtl.party_site_id,jtl.ROUNDED_TAX_AMT_FUN_CURR,

gjl.je_line_num,gjl.code_combination_id,gjl.description,

gjl.segment1,gjl.segment2,gjl.segment3,gjl.segment4,gjl.segment5,gjl.segment6,gjl.segment7,