How to update bulk of customer tier in customer master form.
we need to update bulk of customer tier how to update?
please check below query
SELECT distinct
hcsu.ATTRIBUTE1 Customer_Tier
FROM hz_parties hp
, hz_party_sites hps
, hz_cust_accounts_all hca
, hz_cust_acct_sites_all hcas
, hz_cust_site_uses_all hcsu
WHERE 1 = 1
AND hp.party_id = hca.party_id
AND hca.cust_account_id = hcas.cust_account_id(+)
AND hps.party_site_id(+) = hcas.party_site_id
AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
and hca.cust_account_id = 4296
and hcsu.CUST_ACCT_SITE_ID = 2358
;