Results for “chv_schedule_headers_v”

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

Overview

CHV_SCHEDULE_HEADERS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, defined within the Supply Chain Management family under the CHV (Supplier Scheduling) product module. Its primary role is to present a denormalized, reporting-friendly representation of supplier schedule headers by joining the base scheduling tables to vendor, organization, bucket pattern, lookup, and employee information. This design allows concurrent programs, forms, and reporting tools to retrieve schedule header data without reproducing numerous joins at the call site.

The view is marked as VALID and Retrofitted in the ETRM documentation, confirming that it has been tested and verified against the release level, and that it was carried forward as part of standard maintenance. The view exposes the SCHEDULE_HORIZON_END column directly, making it the appropriate access path for users searching on the schedule horizon boundary. Because it is a view rather than a base table, all data is read-only with respect to direct DML, and the underlying CHV_SCHEDULE_HEADERS table remains the transactional source of truth.

Underlying Base Objects

The documented referenced objects are: CHV_BUCKET_PATTERNS (synonym), CHV_SCHEDULE_HEADERS (synonym), FND_GLOBAL (package), FND_PROFILE (package), HR_EMPLOYEES (view), HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package), MTL_PARAMETERS (synonym), PO_LOOKUP_CODES (view), PO_VENDORS (view), and PO_VENDOR_SITES (view).

• CHV_SCHEDULE_HEADERS — the primary driving table supplying schedule identifiers, horizon dates, status, revision, and descriptive flexfield attributes.
• PO_VENDORS and PO_VENDOR_SITES — supply vendor name, hold flag, and vendor site code.
• MTL_PARAMETERS — joined with an outer join using ORGANIZATION_ID to provide the organization code.
• PO_LOOKUP_CODES — three outer-joined instances supply the display values for schedule type, subtype, and status.
• CHV_BUCKET_PATTERNS — provides the bucket pattern name and description.
• HR_EMPLOYEES and HR security packages — supply the schedule owner's full name, applying HR security and name formatting logic.

Key Columns

• SCHEDULE_ID, SCHEDULE_NUM, SCHEDULE_REVISION — identity and versioning of the schedule.
• SCHEDULE_TYPE, SCHEDULE_SUBTYPE, SCHEDULE_STATUS — decoded display values for classification and lifecycle state.
• SCHEDULE_HORIZON_START and SCHEDULE_HORIZON_END — the effective date boundaries of the scheduling horizon; SCHEDULE_HORIZON_END is the searched column.
• VENDOR_NAME, VENDOR_SITE_CODE, HOLD_FLAG — supplier identity and hold status.
• BUCKET_PATTERN_ID, BUCKET_PATTERN_NAME, DESCRIPTION — the bucket distribution used for the schedule.
• ORGANIZATION_ID, ORGANIZATION_CODE — the owning inventory organization.
• CONFIRM_DATE, PRINT_COUNT, LAST_PRINT_DATE, EDI_COUNT, LAST_EDI_DATE — release and transmission tracking.
• MPS/MRP/DRP_COMPILE_DESIGNATOR — planning compilation linkage.
• ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield segments.

Common Use Cases and Queries

A frequent requirement is to locate schedules whose horizon is approaching expiration. The following query returns active schedules ending within a given window:

• SELECT schedule_num, vendor_name, schedule_horizon_end FROM chv_schedule_headers_v WHERE schedule_status = 'ACTIVE' AND schedule_horizon_end BETWEEN SYSDATE AND SYSDATE + 30;
• SELECT vendor_name, vendor_site_code, schedule_num, schedule_horizon_start, schedule_horizon_end FROM chv_schedule_headers_v WHERE organization_code = :org AND schedule_type = 'SHIP_SCHEDULE';
• SELECT bucket_pattern_name, COUNT(*) FROM chv_schedule_headers_v GROUP BY bucket_pattern_name;

Because the view applies HR security and name-formatting logic, results are subject to the responsibility's security profile. Reports joining this view should therefore filter on ORGANIZATION_ID or VENDOR_ID rather than relying on implicit row filtering.