Search Results csp_planning_headers_v




Overview
Explore in AI Chat

Overview

CSP_PLANNING_HEADERS_V is an Oracle EBS APPS-owned view within the CSP (Spares Management) product module. It presents planning header information for spare parts min-max planning, joining usage header data with item, organization, and planning parameter attributes. The view exposes computed recommendation values such as recommended minimum and maximum quantities, safety factors, safety stock flags, and associated cost metrics, drawing these calculations from the CSP_PICK_UTILS package.

Its role is primarily reporting and inquiry: it consolidates the raw planning header records in CSP_USAGE_HEADERS with descriptive item and organization information (item number, description, organization name) and derives planning recommendations on the fly. Because several columns are function calls into CSP_PICK_UTILS, the view is suited to interactive reporting and analysis of min-max planning outcomes rather than to high-volume batch extraction.

Underlying Base Objects

The view is defined over the following documented base objects:

The base tables (CSP_USAGE_HEADERS, CSP_PLANNING_PARAMETERS, MTL_ITEM_SUB_INVENTORIES) are the durable data sources; the KFV view, organization definitions view, and lookup view are descriptive joins, while the packages supply derived recommendation logic.

Key Columns

  • USAGE_HEADER_ID — primary identifier of the planning header record.
  • INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION — item identity and descriptive attributes.
  • ORGANIZATION_ID, ORGANIZATION_NAME — owning inventory organization.
  • SECONDARY_INVENTORY — the subinventory to which the planning header applies.
  • PROCESS_STATUS, PROCESS_STATUS_MEANING — status code and its lookup meaning.
  • RAW_AWU, AWU — average weekly usage figures, rounded to four decimals.
  • MIN_QUANTITY, MAX_QUANTITY — current min-max values resolved via NODE_TYPE from subinventory or organization warehouse levels.
  • RECOMMENDED_MIN_QTY, RECOMMENDED_MAX_QTY — recommended min-max quantities returned by CSP_PICK_UTILS.
  • SAFETY_FACTOR, SAFETY_STOCK_FLAG, ASL_FLAG, EDQ_FACTOR, SERVICE_LEVEL — planning parameter values driving the calculation.
  • ACTUAL_COST, RECOMMENDED_COST, DELTA_COST, DELTA_MIN — cost and delta metrics comparing actual versus recommended values.

Common Use Cases and Queries

Typical use cases include reviewing recommended min-max settings against current values, auditing cost impact of recommended changes, and identifying planning headers by organization or subinventory.

  • Listing planning headers with recommendations for an organization.
  • Comparing current versus recommended min-max quantities.
  • Quantifying cost deltas (DELTA_COST) to prioritize planning adjustments.

Sample query:

  • SELECT USAGE_HEADER_ID, ITEM_NUMBER, ORGANIZATION_NAME, SECONDARY_INVENTORY, MIN_QUANTITY, MAX_QUANTITY, RECOMMENDED_MIN_QTY, RECOMMENDED_MAX_QTY, DELTA_MIN, DELTA_COST FROM APPS.CSP_PLANNING_HEADERS_V WHERE ORGANIZATION_ID = :p_org_id ORDER BY ITEM_NUMBER;

Note that the view invokes package functions per row, so queries should be filtered by organization and item to limit execution cost.