Results for “job_title”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIL_DIMV_JOB_TITLE is a dimensional view belonging to the Sales Intelligence (BIL) product family within Oracle E-Business Suite. It is a dimension view used in the BIL star schema, where the "DIMV" prefix indicates a dimension view that conforms to ETRM's dimensional modeling standards. The object supplies the job title dimension used by Sales Intelligence analytics, presenting a consolidated, de-duplicated list of sales representative job titles annotated with surrogate key values. The view is documented in ETRM 12.2.2 and is classified as obsolete; the accompanying implementation note states that the object is "not implemented in this database," indicating it is a legacy artifact retained for documentation purposes only.
Its principal role is to expose a JOB_PK surrogate key paired with a descriptive JOB_TITLE, allowing reporting layers, Discoverer workbooks, and downstream BI tooling to group, filter, and drill sales performance facts by job title without querying transactional assignment tables directly.
Underlying Base Objects
The view is defined as a UNION ALL over two sources.
- PER_ALL_ASSIGNMENTS_F (PAAF) — the primary source. The view selects DISTINCT JOB_ID, TITLE, TO_CHAR(JOB_ID) as ID, and TITLE as VALUE, restricted to rows where TITLE is not null and PRIMARY_FLAG = 'Y'. This ensures only the primary assignment for each employee contributes a job title.
- FND_LOOKUPS (FL) — the secondary source, contributing a single sentinel row. It selects TO_NUMBER(LOOKUP_CODE) as JOB_PK, SUBSTR(MEANING,1,30) as JOB_TITLE, LOOKUP_CODE as ID, and MEANING as VALUE, filtered by LOOKUP_TYPE = 'BIL_VALUE_TYPE' and LOOKUP_CODE = '-999'. This provides the standard "unknown/unassigned" dimension member required by the Sales Intelligence star schema.
The view text terminates with a WITH READ ONLY clause, preventing DML against the view. ETRM documents no additional referenced base objects.
Key Columns
- JOB_PK — the surrogate key. Derived from PAAF.JOB_ID on the PER_ALL_ASSIGNMENTS_F branch and cast from the lookup code on the FND_LOOKUPS branch. It is the column referenced by the user search term "job_pk" and is the join key to Sales Intelligence fact tables.
- JOB_TITLE — the descriptive label. Sourced from PAAF.TITLE; on the FND_LOOKUPS branch it is truncated to 30 characters via SUBSTR, producing the "unknown" member label.
- ID — the string representation of the key (TO_CHAR of the job ID, or the raw lookup code). Used where a character-form identifier is required, such as in LOV or flexfield-style displays.
- VALUE — the display value, aligned with ID and sourced from TITLE or MEANING respectively. This pairing supports standard BIL dimension interface conventions where ID and VALUE are exposed together.
Common Use Cases and Queries
Typical use is joining JOB_PK to a Sales Intelligence fact table to slice revenue or opportunity metrics by job title, or using the view as a Discoverer/BI dimension list of values. Because the object is obsolete and unimplemented, most queries are of an investigative nature — confirming historical metadata or reconciling a legacy ETRM report definition against the current data model.
- Enumerate the available job title dimension members:
SELECT job_pk, job_title FROM bil_dimv_job_title ORDER BY job_title; - Confirm the sentinel member exists:
SELECT job_pk, job_title FROM bil_dimv_job_title WHERE job_pk = -999; - Join to a fact table for title-level analysis:
SELECT d.job_title, SUM(f.amount) FROM bil_fact f, bil_dimv_job_title d WHERE f.job_pk = d.job_pk GROUP BY d.job_title; - Verify overlap between assignment titles and primary-flag filtering by comparing against PER_ALL_ASSIGNMENTS_F directly.
Because the view is documented as not implemented, these statements should be validated against the target instance before use.
-
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: 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: 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 →
-
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 →
-
APPS.PA_CUSTOMER_CONTACT_NAMES_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_CUST_ACCT_SITES·↳ HZ_ORG_CONTACTS·Explore PA 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 →
-
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: 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 →
-
APPS.PA_CUSTOMER_CONTACT_NAMES_V·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_CUST_ACCT_SITES·↳ HZ_ORG_CONTACTS·Explore PA module →
-
View: ASF_EMPLOYEE_LOV_V 12.2.2
Employee LOV view
APPS.ASF_EMPLOYEE_LOV_V·↳ JTF_RS_RESOURCE_EXTNS·Explore ASF 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: XLE_LEGAL_CONTACTS_V 12.1.1
APPS.XLE_LEGAL_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·Explore XLE 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: 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 →
-
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: 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: 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 →
-
Contains the tranlated versions of the default postings.
-
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 →
-
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 →
-
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 →
-
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 →
-
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 →
-
APPS.AST_RELATIONSHIP_DETAILS_V·↳ AR_LOOKUPS·↳ FND_TERRITORIES_TL·↳ HZ_CONTACT_POINTS·Explore AST 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: 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: 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.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: ASF_EMPLOYEE_LOV_V 12.1.1
Employee LOV view
APPS.ASF_EMPLOYEE_LOV_V·↳ JTF_RS_RESOURCE_EXTNS·Explore ASF 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 →
-
APPS.OKL_AM_PARTY_CONTACTS_UV·↳ HZ_CONTACT_POINTS·↳ HZ_ORG_CONTACTS·↳ HZ_ORG_CONTACT_ROLES·Explore OKL 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 →
-
View: PAY_IE_PEOPLE_V 12.2.2
Used by IE SOE Form
APPS.PAY_IE_PEOPLE_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PAY 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: CAC_CAL_RESOURCES 12.1.1
APPS.CAC_CAL_RESOURCES·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore FND 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 →
-
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 →
-
View: JTF_RS_EMPLOYEES_VL 12.1.1
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: AMS_LT_ORG_CONTACT_V 12.2.2
Data Source view to get information about b2b contacts
APPS.AMS_LT_ORG_CONTACT_V·↳ HZ_ORG_CONTACTS·Explore AMS 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 →
-
View: AMS_LT_ORG_CONTACT_V 12.1.1
Data Source view to get information about b2b contacts
APPS.AMS_LT_ORG_CONTACT_V·↳ HZ_ORG_CONTACTS·Explore AMS 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 →
-
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 →
-
Stores the translation content of the advert.
-
Stores the translation content of the advert.
-
Used to support user interface.
APPS.HR_CURRENT_PEOPLE_LOV_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →