Search Results delta_min_perc

Overview

APPS.CSP_PLANNING_HEADERS_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, registered under FND Design Data as CSP.CSP_PLANNING_HEADERS_V. Its status is VALID. Oracle classifies this object as a "supplementary view used to simplify forms coding," and the documented metadata carries an explicit warning: Oracle does not recommend querying or altering data through this view, because its definition may change dramatically in subsequent minor or major releases. The view therefore exists primarily to support the Service/Spares Planning (CSP) forms layer rather than as a public integration interface.

Functionally, the view presents planning header information for a given usage header, combining usage-header context with planning parameters, item and organization attributes, and a substantial set of planning calculation outputs. The column set spans input parameters such as safety factor, service level, EDD (EDQ) factor, and ASL flag, alongside calculated results including raw and adjusted AWU, recommended minimum and maximum quantities, and cost deltas. This makes the view a convenient read surface for the planning recommendation engine's output, even though it is not sanctioned for direct production queries.

Underlying Base Objects

The documented referenced base objects for CSP_PLANNING_HEADERS_V are:

• CSP_PICK_UTILS (PACKAGE)
• CSP_PLANNING_PARAMETERS (SYNONYM)
• CSP_USAGE_HEADERS (SYNONYM)
• FND_GLOBAL (PACKAGE)
• FND_LOOKUPS (VIEW)
• HR_GENERAL (PACKAGE)
• HR_SECURITY (PACKAGE)
• MTL_ITEM_SUB_INVENTORIES (SYNONYM)
• MTL_SYSTEM_ITEMS_B_KFV (VIEW)
• ORG_ORGANIZATION_DEFINITIONS (VIEW)

The core planning data is drawn from CSP_USAGE_HEADERS and CSP_PLANNING_PARAMETERS, with CSP_PICK_UTILS supplying the calculation logic that produces the recommended quantities and deltas. FND_GLOBAL and HR_SECURITY provide the session and security context (organization and user access) that constrain which rows are visible, while HR_GENERAL supplies organizational/HR attributes used to resolve the organization. FND_LOOKUPS resolves the PROCESS_STATUS_MEANING value from the lookup code stored in PROCESS_STATUS. Reference and descriptive attributes are joined from MTL_SYSTEM_ITEMS_B_KFV (item number and description), ORG_ORGANIZATION_DEFINITIONS (organization name), and MTL_ITEM_SUB_INVENTORIES (secondary inventory).

Key Columns

The view exposes identifiers and descriptive attributes alongside planning parameters and calculated outputs. Key columns include:

• USAGE_HEADER_ID, PLANNING_PARAMETERS_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID — primary keys/linking identifiers that tie a row to the usage header, the planning parameter record, the item, and the organization.
• HEADER_DATA_TYPE, PROCESS_STATUS, PROCESS_STATUS_MEANING — classify the header record and describe its processing state; the meaning is resolved via FND_LOOKUPS.
• ORGANIZATION_NAME, ITEM_NUMBER, ITEM_DESCRIPTION, SECONDARY_INVENTORY — descriptive context joined from organization, item, and subinventory sources.
• RAW_AWU, AWU, FUNC_CALL, SAFETY_FACTOR, EDQ_FACTOR, SERVICE_LEVEL, ASL_FLAG, SAFETY_STOCK_FLAG — planning inputs and intermediate values, including the annualized usage (AWU) figures, safety and EDD factors, service level, and flags for approved supplier list and safety stock handling.
• RECOMMENDED_MIN_QTY, RECOMMENDED_MAX_QTY, MIN_QUANTITY, MAX_QUANTITY — the recommended and current min/max planning quantities; RECOMMENDED_MIN_QTY is the column users typically search on when comparing suggested minimums against existing parameters.
• ACTUAL_COST, RECOMMENDED_COST, DELTA_COST, DELTA_MIN, DELTA_MAX, DELTA_MIN_PERC, DELTA_MAX_PERC — cost and variance metrics expressing the difference between current and recommended parameters in absolute and percentage terms.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios involve reviewing planning recommendations for spares and service items, comparing recommended minimum quantities to current minimums, and auditing cost impact of recommended changes. Because the view depends on FND_GLOBAL and HR_SECURITY, queries should be executed in the correct organization and user context. A representative query for users focused on RECOMMENDED_MIN_QTY is:

• SELECT usage_header_id, inventory_item_id, organization_id, item_number, organization_name, min_quantity, recommended_min_qty, recommended_max_qty, delta_min, delta_min_perc, service_level, safety_factor FROM apps.csp_planning_headers_v WHERE organization_id = :org_id ORDER BY item_number;
• Filtering by processing state: add AND process_status = :status to restrict to headers in a specific state, with the meaning obtained from process_status_meaning.
• Cost-impact review: select actual_cost, recommended_cost, delta_cost, delta_max_perc for items where the recommended maximum differs materially from the current maximum.

Given the Oracle warning, production reports and integrations should preferably be built on the underlying CSP_USAGE_HEADERS, CSP_PLANNING_PARAMETERS, and related objects rather than on this view, which may be redefined across releases.