How to extract vendor list with their code and opening balance in oracle apps R12 EBS

---- OPENING BALACNE AP WITH SUPPLIER NAME -- 

SELECT APS.VENDOR_ID,

       APS.SEGMENT1 VENDOR_CODE,

       APS.VENDOR_NAME,

       (SELECT APSS.VENDOR_SITE_CODE

          FROM APPS.AP_SUPPLIER_SITES_ALL APSS

         WHERE APSS.VENDOR_ID = API.VENDOR_ID

           AND APSS.VENDOR_SITE_ID = API.VENDOR_SITE_ID

           AND APSS.ORG_ID = API.ORG_ID

       ) VENDOR_SITE_CODE,

       API.INVOICE_ID,

       API.INVOICE_NUM, API.INVOICE_DATE,

       API.INVOICE_AMOUNT,

       API.INVOICE_TYPE_LOOKUP_CODE       

  FROM APPS.AP_INVOICES_ALL API,

       APPS.AP_INVOICE_LINES_ALL APIL,

       APPS.AP_SUPPLIERS APS       

 WHERE 1=1

   AND API.INVOICE_ID = APIL.INVOICE_ID

   AND API.ORG_ID = APIL.ORG_ID

   AND API.INVOICE_DATE BETWEEN '01-APR-2022' AND  '30-SEP-2022'

   AND API.ORG_ID = 1867

   AND API.CREATED_BY = 15032

   AND API.VENDOR_ID = APS.VENDOR_ID

   --AND API.INVOICE_AMOUNT >0

   AND APIL.CANCELLED_FLAG = 'N'

   --AND APS.VENDOR_NAME = 'R.S Engineering'