Query to Get Customer GST number with customer details

SELECT CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER,
PARTY_SITE.PARTY_SITE_NUMBER,
PARTY.PARTY_NAME CUST_NAME,
LOC.ADDRESS1
|| ‘ ‘
|| LOC.ADDRESS2
|| ‘ ‘
|| LOC.ADDRESS3
|| ‘ ‘
|| LOC.POSTAL_CODE
|| ‘ ‘
|| LOC.CITY
|| ‘ ‘
|| NVL (LOC.STATE, LOC.PROVINCE)
ADDRESS,
(SELECT MIN (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(+) = ACCT.CUST_ACCT_SITE_ID
AND JPR.PARTY_ID = CUST.CUST_ACCOUNT_ID
AND NVL (JPRL.EFFECTIVE_FROM, SYSDATE) = SYSDATE
AND REGISTRATION_TYPE_CODE = ‘GSTIN’
AND JPR.PARTY_TYPE_CODE IN (‘THIRD_PARTY’, ‘THIRD_PARTY_SITE’)) CUST_GST_NO
FROM HZ_CUST_ACCOUNTS_ALL CUST,
HZ_CUST_ACCT_SITES_ALL ACCT,
HZ_CUST_SITE_USES_ALL SHIP,
HZ_PARTY_SITES PARTY_SITE,
HZ_LOCATIONS LOC,
HZ_PARTIES PARTY
WHERE CUST.CUST_ACCOUNT_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.CUST_ACCT_SITE_ID = SHIP.CUST_ACCT_SITE_ID
AND ACCT.ORG_ID = SHIP.ORG_ID
AND SHIP.SITE_USE_CODE = ‘BILL_TO’
AND CUST.STATUS = ‘A’
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND ACCT.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND SHIP.ORG_ID = :P_ORG_ID  —-enter OPERATING UNIT