Search Results hr_employees_current_v




Overview
Explore in AI Chat

Overview

CHV_OWNERS_ALL_V is a reporting view owned by the APPS schema within the CHV — Supplier Scheduling product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented status is VALID, and the ETRM record describes it simply as "Retrofitted," indicating the object was recreated or re-registered during an upgrade or patch cycle to preserve compatibility with earlier releases. Functionally, the view resolves the identity of schedule owners referenced in supplier scheduling header records. It joins schedule header data against the current employee view to return the owner's full name, employee number, and location, while also returning placeholder rows for schedule owners that cannot be matched to a current employee. This design ensures that every distinct SCHEDULE_OWNER_ID present in CHV_SCHEDULE_HEADERS is represented in the result set, which is significant for reporting integrity where orphaned or historical owner references exist. Because it presents denormalized, human-readable owner attributes, the view is suited to BI Publisher reports, OAF pages, and custom SQL used in supplier scheduling and procurement workflows.

Underlying Base Objects

The ETRM metadata documents the following referenced objects: CHV_SCHEDULE_HEADERS (exposed as a SYNONYM), FND_PROFILE (PACKAGE), HR_EMPLOYEES_CURRENT_V (VIEW), HR_GENERAL (PACKAGE), HR_PERSON_NAME (PACKAGE), and HR_SECURITY (PACKAGE). The view text joins CHV_SCHEDULE_HEADERS CSH to HR_EMPLOYEES_CURRENT_V HRE on CSH.SCHEDULE_OWNER_ID = HRE.EMPLOYEE_ID. The HR packages supply supporting logic used by the HR_EMPLOYEES_CURRENT_V definition — notably HR_SECURITY for security profile filtering, HR_PERSON_NAME and HR_GENERAL for name and person attribute derivation, and FND_PROFILE for session-level profile option resolution. A second UNION ALL branch selects NULL values for FULL_NAME, EMPLOYEE_NUM, and LOCATION_ID for any SCHEDULE_OWNER_ID with no matching employee in HR_EMPLOYEES_CURRENT_V.

Key Columns

  • FULL_NAME — The formatted full name of the employee identified as the schedule owner, sourced from HR_EMPLOYEES_CURRENT_V. Populated only in the matched branch; NULL for unmatched owners.
  • EMPLOYEE_NUM — The employee number of the schedule owner, used for cross-referencing against HR records and for display in scheduling reports.
  • LOCATION_ID — The location identifier associated with the employee record, enabling geographic or organizational grouping of schedule owners.
  • SCHEDULE_OWNER_ID — The identifier from CHV_SCHEDULE_HEADERS that links the schedule header to its owner. This column is always populated and acts as the join key and the driver of the UNION.

The presence of NULL rows for unmatched owners means consumers must anticipate NULLs in the descriptive columns and should not assume every row identifies a valid, current employee.

Common Use Cases and Queries

Typical uses include listing distinct schedule owners, generating owner-name lookups for scheduling reports, and auditing orphaned owner references. The following query returns all owners with their descriptive attributes:

SELECT FULL_NAME, EMPLOYEE_NUM, LOCATION_ID, SCHEDULE_OWNER_ID
FROM   APPS.CHV_OWNERS_ALL_V
ORDER BY FULL_NAME NULLS LAST;

To locate schedule owner IDs that no longer resolve to a current employee — a common data-cleanup scenario — filter on the NULL descriptive columns:

SELECT SCHEDULE_OWNER_ID
FROM   APPS.CHV_OWNERS_ALL_V
WHERE  FULL_NAME IS NULL
AND    EMPLOYEE_NUM IS NULL
AND    LOCATION_ID IS NULL;

Because HR_EMPLOYEES_CURRENT_V applies HR security, results may be filtered by the caller's security profile; queries executed under a restricted profile can return fewer matched rows and correspondingly more NULL-owner entries. Report developers should therefore validate output under the intended runtime responsibility.