tag:blogger.com,1999:blog-6449613002399272593.post7313332701075983511..comments2024-03-27T10:31:22.585+05:30Comments on oracle concepts for you: Query to find Customer contacts and their roles :Elangovan Ragavan இளங்கோவன் ராகவன்http://www.blogger.com/profile/16345677566529625087noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6449613002399272593.post-60921769099996887412020-11-27T19:20:03.458+05:302020-11-27T19:20:03.458+05:30Thanks for sharing this great information I am imp...Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one <a href="https://atraininghub.com/oracle-adf-training/" rel="nofollow">Oracle ADF </a>. <br />Actually, I was looking for the same information on internet for <br /><a href="https://atraininghub.com/oracle-adf-interview-questions-and-answerstips/" rel="nofollow">Oracle ADF Interview Questions and Answers/Tips</a> and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.<br /><br /><br /><br />Arizona Blazehttps://www.blogger.com/profile/00984514475547703142noreply@blogger.comtag:blogger.com,1999:blog-6449613002399272593.post-89462188430687196922020-03-19T06:30:47.164+05:302020-03-19T06:30:47.164+05:30I want to share a testimony on how Le_Meridian fun...I want to share a testimony on how Le_Meridian funding service helped me with loan of 2,000,000.00 USD to finance my marijuana farm project , I'm very grateful and i promised to share this legit funding company to anyone looking for way to expand his or her business project.the company is funding company. Anyone seeking for finance support should contact them on lfdsloans@outlook.com Or lfdsloans@lemeridianfds.com Mr Benjamin is also on whatsapp 1-989-394-3740 to make things easy for any applicant. Oleghttps://www.blogger.com/profile/14603615049606829323noreply@blogger.comtag:blogger.com,1999:blog-6449613002399272593.post-68511329872730120532019-01-07T19:32:54.462+05:302019-01-07T19:32:54.462+05:30-------------------CUSTOMER ACCOUNT CONTACT INFO
s...-------------------CUSTOMER ACCOUNT CONTACT INFO<br />select hp.party_name<br /> ,hp1.party_name Contact_name<br /> ,hoc.contact_number<br /> ,hcar.cust_acct_site_id<br /> ,hca.cust_account_id<br /> from apps.hz_parties hp<br /> ,apps.hz_cust_accounts hca<br /> ,apps.hz_org_contacts hoc<br /> ,apps.hz_cust_account_roles hcar<br /> ,apps.hz_parties hp1<br /> ,apps.hz_relationships hr<br />where 1 = 1<br />and hca.party_id = hp.party_id<br />AND hr.subject_id = hp1.party_id<br />AND hr.object_id = hp.party_id<br />AND hcar.party_id = hr.party_id<br />AND hoc.party_relationship_id = hr.relationship_id<br />AND hcar.cust_acct_site_id is null<br />AND hcar.STATUS like 'A';<br /><br />-------------------CUSTOMER ACCOUNT SITE CONTACT INFO<br />select hp.party_name<br /> ,hp1.party_name Contact_name<br /> ,hoc.contact_number<br /> ,hps.party_site_id<br /> ,hps.PARTY_SITE_NUMBER<br /> from apps.hz_parties hp<br /> ,apps.hz_party_sites hps<br /> ,apps.hz_cust_accounts hca<br /> ,apps.hz_cust_acct_sites_all hcas<br /> ,apps.hz_org_contacts hoc<br /> ,apps.hz_cust_account_roles hcar<br /> ,apps.hz_parties hp1<br /> ,apps.hz_relationships hr<br />where 1 = 1<br />and hp.party_id = hps.party_id<br />and hca.party_id = hp.party_id<br />and hca.cust_account_id = hcas.cust_account_id<br />and hcas.party_site_id = hps.party_site_id<br />and hcar.cust_acct_site_id(+) = hcas.cust_acct_site_id<br />AND hr.subject_id = hp1.party_id<br />AND hr.object_id = hp.party_id<br />AND hcar.party_id = hr.party_id<br />AND hoc.party_relationship_id = hr.relationship_id<br />AND hcar.STATUS like 'A'Shainee Mangalhttps://www.blogger.com/profile/01167703104326029357noreply@blogger.com