Receivables - EBS (MOSC)

MOSC Banner

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

;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center