Results for “ship_bucket_pattern_id”

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

Overview

CHV_ORG_OPTIONS_V is an APPS-owned database view in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments, residing within the CHV (Supplier Scheduling) product family. The view has a documented status of VALID and is identified in the ETRM metadata with the description designation "- Retrofitted." It consolidates organization-level supplier scheduling configuration parameters, presenting a denormalized, reporting-friendly projection of the operational settings that govern planning and shipping schedules exchanged with suppliers.

Its role is primarily informational and integrative. Rather than requiring report authors, integrations, or concurrent programs to join the core configuration table CHV_ORG_OPTIONS against multiple lookup, planning, and organization entities manually, the view supplies resolved descriptive values alongside the raw configuration identifiers. This makes it well suited for operational reporting, supplier scheduling setup verification, and troubleshooting of schedule generation behavior across a multi-organization installation.

Underlying Base Objects

Per the documented view metadata, CHV_ORG_OPTIONS_V is defined over the following referenced base objects: CHV_BUCKET_PATTERNS, CHV_ORG_OPTIONS, FND_GLOBAL, HR_GENERAL, HR_ORGANIZATION_UNITS, HR_SECURITY, MRP_DESIGNATORS, MRP_PLANS, MTL_PARAMETERS, and PO_LOOKUP_CODES. The core driver table is CHV_ORG_OPTIONS (aliased COO), which holds one configuration row per organization. It is joined to MTL_PARAMETERS (MTP) to retrieve the organization code, and to HR_ORGANIZATION_UNITS (HOU) for the organization name.

Lookup resolution is performed against PO_LOOKUP_CODES for the plan and ship schedule subtypes, while CHV_BUCKET_PATTERNS is joined twice to resolve the bucket pattern names for the planning and shipping sides respectively. The MRP_PLANS and MRP_DESIGNATORS objects are referenced to resolve plan descriptions for the MRP, MPS, and DRP compile designators. The inclusion of HR_SECURITY, HR_GENERAL, and FND_GLOBAL is consistent with organization security and environment context handling commonly applied to CHV scheduling views.

Key Columns

• ORGANIZATION_ID / ORGANIZATION_CODE / NAME — the organization identifier and its resolved code and descriptive name.
• ENABLE_CUM_FLAG / RTV_UPDATE_CUM_FLAG — flags controlling cumulative quantity handling and return-to-vendor cumulative updates.
• PLAN_BUCKET_PATTERN_ID / BUCKET_PATTERN_NAME — the planning bucket pattern and its resolved name.
• SHIP_BUCKET_PATTERN_ID / BUCKET_PATTERN_NAME — the shipping bucket pattern and its resolved name.
• PLAN_SCHEDULE_TYPE / SHIP_SCHEDULE_TYPE — schedule subtype codes with corresponding DISPLAYED_FIELD values resolved from PO_LOOKUP_CODES.
• MRP_COMPILE_DESIGNATOR, MPS_SCHEDULE_DESIGNATOR, DRP_COMPILE_DESIGNATOR — plan identifiers, each accompanied by a resolved description.
• ATTRIBUTE1 through ATTRIBUTE15, ATTRIBUTE_CATEGORY — the standard descriptive flexfield columns.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include auditing supplier scheduling setup across organizations, validating bucket patterns and schedule subtypes before exchanging schedules, and feeding configuration data into custom reports. A representative query follows:

• SELECT organization_code, NAME, enable_cum_flag, plan_bucket_pattern_name, ship_bucket_pattern_name, plan_schedule_type, ship_schedule_type FROM apps.chv_org_options_v ORDER BY organization_code;
• Organizations with cumulative handling enabled: SELECT organization_code, NAME FROM apps.chv_org_options_v WHERE enable_cum_flag = 'Y';
• Schedule subtype distribution: SELECT plan_schedule_type, ship_schedule_type, COUNT(*) FROM apps.chv_org_options_v GROUP BY plan_schedule_type, ship_schedule_type;

Because the view resolves descriptive names, it simplifies verification of plan and ship bucket patterns and remains a convenient single source for supplier scheduling configuration reporting.