Customer Account Reference Information - Basic

SELECT b.party_name,
       b.party_type,
       a.cust_account_id,
       b.party_id,
       a.account_number,
       a.orig_system_reference,
       a.status,
       a.account_name
FROM HZ_CUST_ACCOUNTS a,
     HZ_PARTIES b
WHERE a.party_id (+) = b.party_id
  AND (
        b.party_id IN (300000005352190, 300000001469001, 300000005352164)
        OR upper(a.account_name) LIKE upper('%comp%')
        OR upper(b.party_name) LIKE upper('comp%')
      );