Tuesday, 10 July 2018

Oracle apps + Query to get Customer Contact details

select account_number "Account Number"
     , obj.party_name "Customer Name"
     , sub.party_name "Contact Name"
     , hcp.contact_point_type || ': ' ||
       DECODE(hcp.contact_point_type, 'EMAIL', hcp.email_address
                                    , 'PHONE', hcp.phone_area_code || ' ' || hcp.phone_number
                                    , 'WEB'  , hcp.url
                                    , 'Unknow contact Point Type ' || hcp.contact_point_type
             ) "How to Contact"
  from apps.hz_cust_accounts  hca
     , apps.hz_parties        obj
     , apps.hz_relationships  rel
     , apps.hz_contact_points hcp
     , apps.hz_parties        sub
 where hca.party_id           = rel.object_id
   and hca.party_id           = obj.party_id
   and rel.subject_id         = sub.party_id
   and rel.relationship_type  = 'CONTACT'
   and rel.directional_flag   = 'F'
   and rel.party_id           = hcp.owner_table_id
   and hcp.owner_table_name   = 'HZ_PARTIES'
   and hca.account_number=1258;

Thanks
Amar Alam

18 comments:

Unknown said...

How to start the software company ?

To start the in Software company is very simple and more profitable . To start the business first you need a Team which support for your everything.
In todays software development is nothing but a web application . To develop a web application you need start the Website designing Company is one of the more profitable business with less investment.

We are having the talented Team with 8 years Experience in web design business , which will guide to start the software company quickly with less effort.

There are many business includes in website development - Logo design, website design , webhosting , domain registration ,android app development .
Even If you do not how to develop website no worries . Chase4Net will be there always with you , we can help you on the business by developing a website a behalf of you.

We also have team who developed application such as Hotel booking website development |, bus ticket booking website development | , shopping website development | , hospital website development |,
bill software design | ,job website development |, tickect booking website development | ,matrimonial website development |,RealEstate website development.
You just become a website design company by website design reseller programme , We will take you to the next level.
Enter into partnership with us so that we can help you to setup your business including website design for your company, Email-Id creation, Web Hosting membership, Domain Reseller membership ,Payment Gateway Integration, SMS Integration.Chase4Net ensures
you to start the business from day one rather than making you run behind business plans.To be our franchise we charge as low as INR Rs 20000/- (or) $296 To pay the franchise membership fee.How to pay

Unknown said...

How to start the Online Business ?

To start the Business in online is very simple and more profitable . Today starting the Website designing Company is one of the more profitable business with less investment.

We are having the talented Team with 8 years Experience in web design business, which will guide to start the software company quickly with less effort.

Now a days all the business are moving towards online . Too start the company we need correct Business Model and that’s where you search ends at Chase4Net . We will help you to setup the Website design Company at less cost . The website design company can offer the following Logo design, website design , webhosting , domain registration ,android app development .

Even If you do not know how to develop website no worries . Chase4Net will be there always with you , we can help you on the business by developing a website a behalf of you.


We also have team who developed application such as Hotel booking website design |, bus ticket booking website design | , shopping cart website desing | ,hospital website design |,
bill software design |,job website design |,tickect booking website design | ,matrimonial website design |,RealEstate website design.

You just become a website design company reseller program, We will take you to the next level.

Enter into partnership with us so that we can help you to setup your business including website design for your company ,Email-Id creation, Web Hosting membership, Domain Reseller membership, Payment Gateway Integration, SMS Integration.Chase4Net ensures
you to start the business from day one rather than making you run behind business plans.To be our franchise we charge as low as INR Rs 20000/- (or) $296 To pay the franchise membership fee How to pay

Unknown said...

I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog. 
Devops training in Chennai
Devops training in Bangalore
Devops Online training
Devops training in Pune

simbu said...

Good Post, I am a big believer in posting comments on sites to let the blog writers know that they ve added something advantageous to the world wide web.

java training in annanagar | java training in chennai

java training in marathahalli | java training in btm layout

java training in rajaji nagar | java training in jayanagar

java training in chennai

genga g said...
This comment has been removed by the author.
prabha said...

Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information. 

angularjs-Training in velachery

angularjs-Training in annanagar

angularjs Training in chennai

angularjs Training in chennai

Unknown said...


When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.
Amazon Web Services Training in OMR , Chennai | Best AWS Training in OMR,Chennai
AWS Training in Chennai |Best Amazon Web Services Training in Chennai
AWS Training in Bangalore |Best AWS training in Bangalore
Amazon Web Services Training in Tambaram, Chennai|Best AWS Training in Tambaram, Chennai

prabha said...

Really nice experience you have. Thank you for sharing. It will surely be an experience to someone.angularjs online Training

angularjs Training in marathahalli

angularjs interview questions and answers

angularjs Training in bangalore

angularjs Training in bangalore

angularjs online Training

angularjs Training in marathahalli

Anjali Siva said...

Wonderful post. Thanks for taking time to share this information with us.
DevOps certification in Chennai
DevOps Training in Chennai
Best AWS Training in Chennai
AWS course in Chennai
Data Science Course in Chennai
Big Data Analytics Courses in Chennai
DevOps Training in OMR
DevOps Training in Porur
DevOps Training in Adyar

Raji said...

Thanks Admin for sharing such a useful post, I hope it’s useful to many individuals for developing their skill to get good career.
Devops Training in Chennai | Devops Training Institute in Chennai

Anand Shankar said...
This comment has been removed by the author.
Vennala said...
This comment has been removed by the author.
Aadhya said...
This comment has been removed by the author.
Aadhya said...
This comment has been removed by the author.
PROFESSIONAL PROGRAMMERS said...

Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome. I will instantly grab your rss feed to stay informed of any updates you make and as well take the advantage to share some latest information about

CREDIT CARD HACK SOFTWARE which many are not yet informed, of the recent technology.

Thank so much for the great job.

Realtime Experts said...

Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
Oracle apps Training in Bangalore

Cloud Box said...

I really appreciate this post and I like this very much. I am waiting for new post here and Please keep it up in future.

CloudBox99 offers you with the best Web hosting services in Hyderabad and facilitates enterprises to transform digitally. We keep you covered in terms of all your IT requirements with unmatched expertise and deep domain knowledge

Unknown said...

The point of good I really favor in your blog
wedding photography packages
leather jacket

Post a Comment