Query to find Third Party Registration

Query to find Third Party Registration

SELECT DISTINCT TRIM (TO_CHAR (b.registration_number)) gst_num
INTO lv_gst_num
FROM jai_party_regs a, jai_party_reg_lines b
WHERE 1 = 1
AND a.party_reg_id = b.party_reg_id
AND a.party_type_code = ‘THIRD_PARTY_SITE’
AND b.regime_id = 10000
AND b.registration_type_code = ‘GST’
AND a.party_id = 20344
AND a.party_site_id = 65432;