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

Report message to a moderator

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: 8963
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.

Report message to a moderator

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

Report message to a moderator

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: 8963
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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 22 06:56:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.