Query to get Supplier/Vendor data along with GST Number

SELECT ASUP.SEGMENT1 SUPPLIER_CODE,
VENDOR_SITE_CODE SUPPLIER_SITE,
ASSA.ADDRESS_LINE1,
ASSA.ADDRESS_LINE2,
ASSA.ADDRESS_LINE3,
ASSA.CITY,
STATE STATE_NAME,
(SELECT JPRL.REGISTRATION_NUMBER
FROM JAI_PARTY_REGS JPR, JAI_PARTY_REG_LINES JPRL
WHERE JPRL.PARTY_REG_ID = JPR.PARTY_REG_ID
AND JPR.PARTY_SITE_ID = ASSA.VENDOR_SITE_ID
AND JPR.PARTY_ID = ASUP.VENDOR_ID
AND NVL (JPRL.EFFECTIVE_FROM, SYSDATE) <= SYSDATE—TO TAKE ACTIVE REG NUMBERS
AND NVL (JPRL.EFFECTIVE_TO, SYSDATE) >= SYSDATE—TO TAKE ACTIVE REG NUMBERS
AND REGISTRATION_TYPE_CODE = ‘GSTIN’)
SUPPLIER_GSTIN,
DECODE (
(SELECT JPRL.REGISTRATION_NUMBER
FROM JAI_PARTY_REGS JPR, JAI_PARTY_REG_LINES JPRL
WHERE JPRL.PARTY_REG_ID = JPR.PARTY_REG_ID
AND JPR.PARTY_SITE_ID = ASSA.VENDOR_SITE_ID
AND JPR.PARTY_ID = ASUP.VENDOR_ID
AND NVL (JPRL.EFFECTIVE_FROM, SYSDATE) <= SYSDATE
AND NVL (JPRL.EFFECTIVE_TO, SYSDATE) >= SYSDATE
AND REGISTRATION_TYPE_CODE = ‘GSTIN’),
NULL, ‘UNREGISTERED’,
‘REGISTERED’)
REGISTRATION_TYPE
FROM AP_SUPPLIERS ASUP, AP_SUPPLIER_SITES_ALL ASSA
WHERE ASUP.VENDOR_ID = ASSA.VENDOR_ID