Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

how to update bulk of customer tier in customer master?

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