Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to retrive contact address and contact purpose of customer in Oracle AR (release 12)
Query to retrive contact address and contact purpose of customer in Oracle AR [message #637809] Mon, 25 May 2015 12:04 Go to next message
asadkhan_2
Messages: 36
Registered: January 2008
Member
Hi Expert, Please tell me that how I find out recently updated Contacts details(Multiple contacts) of customer at the Communication tab defined at the Site level in oracle AR

Thanks a lot
Re: Query to retrive contact address and contact purpose of customer in Oracle AR [message #637810 is a reply to message #637809] Mon, 25 May 2015 16:30 Go to previous messageGo to next message
John Watson
Messages: 8351
Registered: January 2010
Location: Global Village
Senior Member
You will need to look at the hz_parties, hz_cust_accounts, and hz_cust_contact_points tables. Probaby a few others, too.
Re: Query to retrive contact address and contact purpose of customer in Oracle AR [message #637812 is a reply to message #637810] Mon, 25 May 2015 23:33 Go to previous messageGo to next message
asadkhan_2
Messages: 36
Registered: January 2008
Member
any other help please the exact query
Re: Query to retrive contact address and contact purpose of customer in Oracle AR [message #637813 is a reply to message #637812] Tue, 26 May 2015 00:57 Go to previous messageGo to next message
John Watson
Messages: 8351
Registered: January 2010
Location: Global Village
Senior Member
asadkhan_2 wrote on Tue, 26 May 2015 05:33
any other help please the exact query
US$250 per hour, two hour minumum paid in advance, please.
Re: Query to retrive contact address and contact purpose of customer in Oracle AR [message #637814 is a reply to message #637813] Tue, 26 May 2015 01:04 Go to previous message
asadkhan_2
Messages: 36
Registered: January 2008
Member
Hi John

I dont need urz hours or anyone i have posted this query just for help and i think this group is not paid anyhow thanks for your offer i dont need


Thanks
Previous Topic: Control on Receipt Reversal Date
Next Topic: Need Oracle EBS installation in desktop
Goto Forum:
  


Current Time: Wed Sep 30 21:40:20 CDT 2020