You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trying to Find Table With List of JOB_TITLE_CODEs Appearing in Manage Contacts/HZ_ORG_CONTACTS

Accepted answer
22
Views
3
Comments
in Sales 3 comments

Summary:

I'm building a BI Publisher report that is pulling in the Customer Account Contacts, and am trying to find the table that has the list of Job Title Codes that appear in HZ_ORG_CONTACTS (in UI, this is Manage Customers -> Manage Contacts -> Responsibilities section -Job Title Codes dropdown) (see attached screen shot of UI).

These are maintained in the UI in Setup & Maintenance -> Manage Contact Lookups -> RESPONSIBILITY (see attached screen shot of UI). I'm interested in the Lookup Code and Meaning fields.

Tables & Views documentation for HZ_ORG_CONTACTS does not appear to be showing any FK relationship for the JOB_TITLE_CODE field. Any one have any idea where these are stored?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!