tag:blogger.com,1999:blog-5954268311855527678.post5703978311504727984..comments2024-03-18T05:45:05.913-07:00Comments on Oracle Apps Knowledge Sharing: Query To Fetch Customer Account/Site Contact Details in R12Unknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5954268311855527678.post-65063360629295290592019-01-07T06:04:13.021-08:002019-01-07T06:04:13.021-08:00-------------------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 /> ,Shainee Mangalhttps://www.blogger.com/profile/01167703104326029357noreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-49124979590175447952014-09-24T09:24:52.538-07:002014-09-24T09:24:52.538-07:00THANK YOU zcat08 for tying contacts and contact po...THANK YOU zcat08 for tying contacts and contact points together!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-10343546971632573522013-11-18T10:57:07.662-08:002013-11-18T10:57:07.662-08:00-- Site Contacts with contact points
SELECT p.part...-- Site Contacts with contact points<br />SELECT p.party_name,<br /> p.party_id,<br /> p.party_number,<br /> p.party_type,<br /> c.cust_account_id,<br /> c.account_number,<br /> pp.party_name contact_name,<br /> pp.PARTY_ID contact_party_id,<br /> pp.party_type,<br /> r.role_type,<br /> co.phone_country_code,<br /> co.phone_area_code,<br /> co.phone_number,<br /> co.phone_line_type,<zcat08https://www.blogger.com/profile/03260653477508234541noreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-25864736020056095332013-11-18T10:53:58.899-08:002013-11-18T10:53:58.899-08:00--Site contact point (this is different from site ...--Site contact point (this is different from site contact)<br />SELECT p.party_number,<br /> c.cust_account_id,<br /> c.account_number,<br /> cp.*<br />FROM ar.hz_cust_accounts c,<br /> AR.HZ_PARTIES p,<br /> ar.hz_party_sites s,<br /> ar.hz_contact_points cp<br />WHERE c.account_number = '&&Account_Number'<br />AND p.party_id = c.party_id<br />AND p.party_idzcat08https://www.blogger.com/profile/03260653477508234541noreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-37897888414572152482013-11-18T10:52:43.319-08:002013-11-18T10:52:43.319-08:00-- Retrieve Party Contact Points
SELECT cp.*
FROM ...-- Retrieve Party Contact Points<br />SELECT cp.*<br />FROM ar.hz_cust_accounts c,<br /> AR.HZ_PARTIES p,<br /> ar.hz_contact_points cp<br />WHERE<br /> c.account_number = '&&Account_Number'<br />AND p.party_id = c.party_id<br />AND cp.owner_table_name = 'HZ_PARTIES'<br />AND cp.owner_table_id = p.party_id;zcat08https://www.blogger.com/profile/03260653477508234541noreply@blogger.com