Results for “chv_schedulers_val_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The CHV_SCHEDULERS_VAL_V view is an APPS-owned database object within the Oracle E-Business Suite CHV — Supplier Scheduling product family. Its documented status is VALID, and the ETRM metadata describes it as "Retrofitted," indicating that the view was introduced or re-created during an upgrade or patch cycle to align with the current data model rather than being part of the original design. Functionally, the view presents a distinct list of valid schedulers — the employees authorised to act as schedulers on supplier scheduling and Approved Supplier List (ASL) attribute records — together with their full name, employee number, and HR location identifier. This makes the view a validation and lookup source: it enumerates the people who may legitimately be assigned as a scheduler, so that forms, list-of-values (LOVs), and validation routines can restrict scheduler selection to active, authorised employees.

Because it joins the ASL attributes validation layer to the current HR employee view, CHV_SCHEDULERS_VAL_V bridges the procurement and human-resources data models. It is typically consumed in reporting, LOV definitions, and integration extracts where a validated scheduler reference is required.

Underlying Base Objects

The documented base objects referenced by this view are:

• PO_ASL_ATTRIBUTES_VAL_V (VIEW) — the validation view over ASL scheduling attributes; it supplies the SCHEDULER_ID.
• HR_EMPLOYEES_CURRENT_V (VIEW) — the current-employee view; it supplies FULL_NAME, EMPLOYEE_NUM, and LOCATION_ID.
• FND_PROFILE (PACKAGE), HR_GENERAL (PACKAGE), HR_PERSON_NAME (PACKAGE), and HR_SECURITY (PACKAGE) — supporting HR and profile utilities underlying the employee and security views.

The view text is a SELECT DISTINCT that joins ASL scheduling attributes to current employees on SCHEDULER_ID = EMPLOYEE_ID, with the predicate SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1). This predicate filters out schedulers whose ASL attribute record has become inactive, while retaining rows where INACTIVE_DATE is null. The DISTINCT clause eliminates duplicates arising when an employee is associated with multiple ASL attribute rows.

Key Columns

• FULL_NAME — the employee's full name, sourced from HR_EMPLOYEES_CURRENT_V. Used for display in LOVs and reports.
• EMPLOYEE_NUM — the employee number, providing a stable, human-readable identifier for the scheduler.
• LOCATION_ID — the employee's HR location identifier, enabling filtering or grouping of schedulers by location or organisation.
• SCHEDULER_ID — the employee identifier carried from PO_ASL_ATTRIBUTES_VAL_V; this is the key value persisted against ASL scheduling records and used in joins and validation.

Common Use Cases and Queries

The view is most commonly used to populate or validate scheduler selections and to report on scheduler assignments.

• LOV for scheduler fields on ASL and supplier scheduling forms.
• Validation queries to confirm that a proposed scheduler ID is active and authorised.
• Reporting on schedulers by location or employee number.

Sample query listing all valid schedulers:

SELECT scheduler_id, full_name, employee_num, location_id
FROM apps.chv_schedulers_val_v
ORDER BY full_name;

Sample query locating a specific scheduler:

SELECT full_name, employee_num, location_id
FROM apps.chv_schedulers_val_v
WHERE scheduler_id = :p_scheduler_id;

As the user searched for po_asl_attributes_val_v, it is worth noting that the underlying ASL validation view is the immediate parent of this object; querying CHV_SCHEDULERS_VAL_V yields the employee-enriched scheduler list derived from it.