Results for “job_title”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JTF_ORG_CONTACTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the JTF – CRM Foundation product family. Its documented purpose is to retrieve all contacts associated with a party, exposing a focused projection of the organization contact data held in the Trading Community Architecture (TCA) model. The view is registered as VALID in both Oracle EBS 12.1.1 and 12.2.2, and is available for query and integration use wherever the CRM Foundation objects are deployed.
Functionally, the view does not simply mirror its base table. It applies a row-level filter so that only organization contacts carrying meaningful assignment data are returned. This makes it a convenient access point for downstream reports, CRM extensions, and interfaces that need a clean list of party contacts with populated organizational attributes. Because it resides in the APPS schema and is defined over TCA synonym objects, it participates in the standard EBS security and synonym conventions that govern cross-schema access.
Underlying Base Objects
The view is defined exclusively over a single referenced object: the HZ_ORG_CONTACTS table, accessed through its APPS synonym. HZ_ORG_CONTACTS stores the relationship between a party (typically an organization) and its associated contacts, including the contact's role, title, department, and ranking. In the EBS data model, HZ_ORG_CONTACTS is the organization-contact intersection within the TCA registry, connecting parties to contacts created and maintained through the standard customer and contact maintenance forms.
JTF_ORG_CONTACTS_V sits as a thin abstraction layer above this table. The documented view text selects four columns from the source, applying a predicate that restricts output to rows where at least one of DEPARTMENT_CODE, RANK, or JOB_TITLE_CODE is not null. The predicate references JOB_TITLE_CODE from the base table even though that column is not projected in the view's select list, so it functions purely as a filter criterion.
Key Columns
The view exposes the following documented columns:
- RANK — The ranking or precedence value associated with the organization contact, used to order or prioritize contacts relative to one another.
- JOB_TITLE — The descriptive job title text for the contact within the organization.
- DEPARTMENT — The descriptive name of the department to which the contact belongs.
- DEPARTMENT_CODE — The coded identifier for the contact's department, which is the value most commonly searched by users querying this view.
The filter criteria (DEPARTMENT_CODE, RANK, JOB_TITLE_CODE) determine membership in the result set: any contact row with all three of these values null is excluded. Consequently, the view is best understood as a filtered contact attribute view rather than a complete contact listing.
Common Use Cases and Queries
Typical usage centers on reporting and integration where department, title, and rank attributes are the required output. A common scenario is locating contacts by their department code, which directly reflects the search term associated with this object:
SELECT rank, job_title, department, department_code FROM jtf_org_contacts_v WHERE department_code = :p_dept_code;SELECT department_code, COUNT(*) FROM jtf_org_contacts_v GROUP BY department_code ORDER BY department_code;SELECT job_title, department FROM jtf_org_contacts_v WHERE rank IS NOT NULL ORDER BY rank;
These queries support organizational directories, contact prioritization reports, and integrations that populate external systems with departmental contact assignments. Users should note that because the view filters on the base predicate, contacts with only a name and no department, rank, or job title code will not appear; complete contact listings must be obtained from HZ_ORG_CONTACTS or the broader TCA contact views.
-
View: JTF_ORG_CONTACTS_V 12.2.2
JTF_ORG_CONTACTS_V retrieves all Contacts for a party.
APPS.JTF_ORG_CONTACTS_V·↳ HZ_ORG_CONTACTS·Explore JTF module →
-
View: BIL_DIMV_JOB_TITLE 12.1.1
Sales representatives job tiles view
APPS.BIL_DIMV_JOB_TITLE·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ PER_JOBS·Explore BIL module →
-
View: AR_CONTACTS_ACTIVE_V 12.2.2
APPS.AR_CONTACTS_ACTIVE_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AR module →
-
View: JTF_ORG_CONTACTS_V 12.1.1
JTF_ORG_CONTACTS_V retrieves all Contacts for a party.
APPS.JTF_ORG_CONTACTS_V·↳ HZ_ORG_CONTACTS·Explore JTF module →
-
APPS.PA_CUSTOMER_CONTACT_NAMES_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_CUST_ACCT_SITES·↳ HZ_ORG_CONTACTS·Explore PA module →
-
View: AR_CONTACTS_ACTIVE_V 12.1.1
APPS.AR_CONTACTS_ACTIVE_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore AR module →
-
View: OE_CONTACTS_V 12.1.1
This is view is based on ra_contacts
APPS.OE_CONTACTS_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OE_CONTACTS_V 12.2.2
This is view is based on ra_contacts
APPS.OE_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore ONT module →
-
APPS.PA_CUSTOMER_CONTACT_NAMES_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_CUST_ACCT_SITES·↳ HZ_ORG_CONTACTS·Explore PA module →
-
View: WSH_CONTACT_PHONE 12.1.1
APPS.WSH_CONTACT_PHONE·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore WSH module →
-
View: AS_PERSONS_ACTIVE_V 12.2.2
Active sales representatives view
APPS.AS_PERSONS_ACTIVE_V·↳ HR_API·↳ HR_LOOKUPS·↳ PER_ALL_ASSIGNMENTS_F·Explore AS module →
-
View: WSH_CONTACT_PHONE 12.2.2
APPS.WSH_CONTACT_PHONE·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore WSH module →
-
View: XLE_LEGAL_CONTACTS_V 12.2.2
APPS.XLE_LEGAL_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore XLE module →
-
View: ASF_EMPLOYEE_LOV_V 12.1.1
Employee LOV view
APPS.ASF_EMPLOYEE_LOV_V·↳ JTF_RS_RESOURCE_EXTNS·Explore ASF module →
-
View: ASF_EMPLOYEE_LOV_V 12.2.2
Employee LOV view
APPS.ASF_EMPLOYEE_LOV_V·↳ JTF_RS_RESOURCE_EXTNS·Explore ASF module →
-
This view is used to print the Customer Contact information.
APPS.OE_PRINT_CUST_CONTACT_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore ONT module →
-
View: IBE_OE_CONTACTS_V 12.2.2
This view is used to retrieve the Order's Billling or Shipping Contact name
APPS.IBE_OE_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore IBE module →
-
View: XLE_LEGAL_CONTACTS_V 12.1.1
APPS.XLE_LEGAL_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore XLE module →
-
View: AS_PERSONS_ACTIVE_V 12.1.1
Active sales representatives view
APPS.AS_PERSONS_ACTIVE_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore AS module →
-
View: AST_RES_TEAM_MEMBERS_V 12.1.1
APPS.AST_RES_TEAM_MEMBERS_V·↳ JTF_OBJECTS_TL·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_ROLES_B·Explore AST module →
-
Contains the tranlated versions of the default postings.
-
Added union clause to the view for ASN owner mapping enhancement.
APPS.PA_PROJ_REQUEST_DIRECTORY_V·↳ AS_ACCESSES_ALL·↳ AS_LOOKUPS·↳ FND_ACCESS_CONTROL_UTIL·Explore PA module →
-
Contains the tranlated versions of the default postings.
-
Added union clause to the view for ASN owner mapping enhancement.
APPS.PA_PROJ_REQUEST_DIRECTORY_V·↳ AS_ACCESSES_ALL·↳ AS_LOOKUPS·↳ FND_ACCESS_CONTROL_UTIL·Explore PA module →
-
This view is used to print the Customer Contact information.
APPS.OE_PRINT_CUST_CONTACT_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore ONT module →
-
View: AST_RES_TEAM_MEMBERS_V 12.2.2
APPS.AST_RES_TEAM_MEMBERS_V·↳ JTF_OBJECTS_TL·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_ROLES_B·Explore AST module →
-
View: IBE_OE_CONTACTS_V 12.1.1
This view is used to retrieve the Order's Billling or Shipping Contact name
APPS.IBE_OE_CONTACTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·Explore IBE module →
-
APPS.AST_RELATIONSHIP_DETAILS_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_TL·↳ HZ_CONTACT_POINTS·Explore AST module →
-
PON_EMPLOYEES_CURRENT_V is a view that provides details of current employee. Each row includes specific information about the current employees such full name, first name, middle names, employee number, person id, effective period, etc.
APPS.PON_EMPLOYEES_CURRENT_V·↳ HR_SECURITY·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ALL_PEOPLE_F·Explore PON module →
-
Contains job history information for contacts
-
View: PER_PEOPLE_V4 12.1.1
Used to support user interface
APPS.PER_PEOPLE_V4·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_PEOPLE_V4 12.2.2
Used to support user interface
APPS.PER_PEOPLE_V4·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PAY_GB_PEOPLE_SOE_V 12.1.1
APPS.PAY_GB_PEOPLE_SOE_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PAY module →
-
View: PAY_GB_PEOPLE_SOE_V 12.2.2
Used to support People section on the PUI SOE
APPS.PAY_GB_PEOPLE_SOE_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PAY module →
-
View: PA_PROJECT_CONTACTS_V 12.1.1
10SC only
APPS.PA_PROJECT_CONTACTS_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore PA module →
-
View: ASO_I_ORG_CONTACTS_V 12.1.1
It gives the information about Party Name,Party Type etc.
APPS.ASO_I_ORG_CONTACTS_V·↳ AR_LOOKUPS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore ASO module →
-
View: ASO_I_ORG_CONTACTS_V 12.2.2
It gives the information about Party Name,Party Type etc.
APPS.ASO_I_ORG_CONTACTS_V·↳ AR_LOOKUPS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore ASO module →
-
View: OKX_CUST_CONTACTS_V 12.1.1
Customer contacts
APPS.OKX_CUST_CONTACTS_V·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_CUST_ACCT_SITES·Explore OKX module →
-
APPS.OKL_AM_PARTY_CONTACTS_UV·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore OKL module →
-
Contains job history information for contacts
-
APPS.WSH_CARRIER_SITE_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore WSH module →
-
APPS.WSH_CARRIER_SITE_CONTACTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore WSH module →
-
APPS.OKL_AM_PARTY_CONTACTS_UV·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore OKL module →
-
View: PA_PROJECT_CONTACTS_V 12.2.2
10SC only
APPS.PA_PROJECT_CONTACTS_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·Explore PA module →
-
View: JTF_RS_EMPLOYEES_VL 12.2.2
This view has the list of all Employees that can be importedor is already present in Resource Manager
APPS.JTF_RS_EMPLOYEES_VL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore JTF module →
-
View: CAC_CAL_RESOURCES 12.1.1
APPS.CAC_CAL_RESOURCES·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore FND module →
-
Stores the contact information for a lead in partner's OSO database.
-
Stores the contact information for a lead in partner's OSO database.
-
APPS.AST_RELATIONSHIP_DETAILS_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_TL·↳ HZ_CONTACT_POINTS·Explore AST module →
-
PON_EMPLOYEES_CURRENT_V is a view that provides details of current employee. Each row includes specific information about the current employees such full name, first name, middle names, employee number, person id, effective period, etc.
APPS.PON_EMPLOYEES_CURRENT_V·↳ HR_SECURITY·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ALL_PEOPLE_F·Explore PON module →