Credit Memo TDS invoice Query in R12.1.3

Hi All,

GST India patches has been applied in our instance on AUg-17 .

The below query is not displaying Credit memo TDS invoices so that the TDS Amount will match.

SELECT DISTINCT HRO.name                    OPERATING_UNIT,

                SPV.segment1                VENDOR_CODE,

                SPV.vendor_name,

                SPVS.vendor_site_code,

                API.invoice_num             INVOICE_NUM,

                API.invoice_date,

                API.invoice_amount          INVOICE_HEADER_AMOUNT,

                JIATI.invoice_amount        INVOICE_LINE_AMOUNT,

                JIATI.tds_invoice_num       TDS_INVOICE_NUM,

                APITDS.invoice_date         TDS_INVOICE_DATE,

                JIATI.tds_amount            TDS_INVOICE_AMOUNT,

                API.gl_date                 TDS_GL_DATE,

                APITDS.amount_paid          TDS_AMOUNT_PAID,

                JAP.pan_no