Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Contact rule in account receivables R12

oliver82Jun 10 2013 — edited Jun 16 2013

Hi.

If I use the Oracle receivable web-forms to create a new contact for an existing customer I can choose a "Contact Role" out of a dropdown list. Right now im trying to find this value in the Oracle database. I know that the created contact itself can be found in AR.HZ_PARTIES and that further information can be found in AR.HZ_ORG_CONTACTS and AR.HZ_CUST_ACCOUNT_ROLES but I cannot find any information about the "Contact Role" - something like role_id or somethin else.

Has anybody an idea?

Regards.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2013
Added on Jun 10 2013
3 comments
834 views