SQL Query to Extract the Customer contact details in Oracle Cloud
In this post , I will share the SQL query to extract the Customer contact details in Oracle cloud. This query will help you to share customer contact and communications details in Oracle Cloud. Please find below the Detail SQL Query for Customer Contact detail in Oracle cloud.
Important Tables to Extract the Customer contact details in Oracle Cloud
hz_cust_accounts
hz_contact_points
hz_relationships
hz_cust_account_roles
hz_party_sites
hz_cust_acct_sites_all
Detail SQL Query to Extract the Customer contact details in Oracle Cloud
select hp.party_name,
hca.account_number,hps.party_site_number OUTPUT_NAME,
ROLE_TYPE,hcp.EMAIL_ADDRESS
,hcp.CONTACT_POINT_TYPE
,hr.RELATIONSHIP_CODE
from hz_cust_accounts hca, hz_contact_points hcp, hz_relationships hr, hz_parties hp,hz_cust_account_roles hcar,hz_cust_acct_sites_all hcsa,hz_party_sites hps
where hcp.relationship_id = hr.relationship_id and hcp.CONTACT_POINT_TYPE = 'EMAIL' and hr.RELATIONSHIP_CODE = 'CONTACT_OF' and hr.object_id = hp.party_id
and nvl(hcp.end_date,sysdate+5) >sysdate
and NVL(HCAR.STATUS,'A')='A'
and hcar.relationship_id = hcp.relationship_id and hp.party_id = hca.party_id
and hcar.CUST_ACCOUNT_ID=hca.CUST_ACCOUNT_ID
and hca.CUST_ACCOUNT_ID=hcsa.CUST_ACCOUNT_ID
and hcar.CUST_ACCT_SITE_ID=hcsa.CUST_ACCT_SITE_ID
and hcsa.party_site_id=hps.party_site_id
SQL Query to Extract the Customer contact details in Oracle Cloud
1 comments:
I'M NOW FULFILL FINANCIALLY BECAUSE OF THE LOAN I GOT FROM LFDS .I would like to bring this to the notice of the public about how i came in contact with LFDS after i lost my job and being denied loan by my bank and other financial institution due to my credit score. I could not pay my children's fees. I was behind on bills, about to be thrown out of the house due to my inability to pay my rent, It was during this period my kids were taken from me by foster care. Then i set out to seek for funds online where i lost $3,670 that i borrowed from friends which i was rip off by two online loan companies. Until i read about:Le_Meridian Funding Service (lfdsloans@outlook.com / lfdsloans@lemeridianfds.com) somewhere on the internet, Still wasn't convince because of what i have been through until a relative of mine who is a clergy also told me about the ongoing loan scheme of LFDS at a very low interest rate of 1.9%% and lovely repayment terms without penalty for default of payment. I have no choice than to also contact them which i did through text +1-989-394-3740 and Mr Benjamin responded back to me That day was the I'M best and greatest day of my life which can never be forgotten when i receive a credit alert of $400,000.00 Usd loan amount i applied for. I utilized the loan effectively to pay up my debts and to start up a business and today i and my kids are so happy and fulfill. You can as well contact them through email: (lfdsloans@outlook.com / lfdsloans@lemeridianfds.com) WhatsApptext helpline: +1-989-394-3740 Why am i doing this? I am doing this to save as many that are in need of a loan not to be victim of scams on the internet. Thanks and God bless you all, I'm Oleksander Artem from Horizon Park BC , Ukrain.
Post a Comment