Results for “csp_planning_topnode_hdr_v”

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

Overview

CSP_PLANNING_TOPNODE_HDR_V is an Oracle E-Business Suite (EBS) database view owned by the APPS schema and validated against both release 12.1.1 and 12.2.2. It belongs to the CSP – Spares Management product family, which supports the planning, provisioning, and replenishment of spare parts across a maintenance or depot network. The view presents a summarized, header-level picture of planning data — aggregating cost figures per inventory item and functional call context — rather than exposing the full detail rows held in the underlying planning structures. Because it joins planning header data to the item master key flexfield view, it resolves the surrogate INVENTORY_ITEM_ID into the concatenated item number and description that end users and report consumers can actually recognise.

For users searching on actual_cost, this view is significant because ACTUAL_COST is one of three aggregated cost columns it exposes. It allows a planner or analyst to compare actual incurred cost against recommended cost and the delta between them, on a per-item basis. The view is read-only and is typically consumed by concurrent programs, BI Publisher reports, and custom inquiry screens rather than being maintained directly.

Underlying Base Objects

The documented referenced base objects are:

• CSP_PLANNING_HEADERS_V (VIEW) — the primary source of planning header rows, supplying FUNC_CALL, INVENTORY_ITEM_ID, HEADER_DATA_TYPE, ACTUAL_COST, RECOMMENDED_COST, and DELTA_COST.
• MTL_SYSTEM_ITEMS_B_KFV (VIEW) — the key flexfield view over the item master, joined on INVENTORY_ITEM_ID and restricted to the product organization returned by CSP_PICK_UTILS.CSP_PRODUCT_ORGANIZATION. This provides ITEM_NUMBER (CONCATENATED_SEGMENTS) and ITEM_DESCRIPTION.
• CSP_PICK_UTILS (PACKAGE) — called at query time to supply the product organization identifier used in the join condition.
• FND_GLOBAL, HR_GENERAL, and HR_SECURITY (PACKAGES) — invoked by the header view chain to resolve the current responsibility, user, and organization security context.

The defining query restricts source rows with HEADER_DATA_TYPE IN (1, 4), so only the two planning header categories represented by those codes flow into the aggregation. Rows are grouped by INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION, and FUNC_CALL, with each cost column summed using NVL to treat nulls as zero. The result is one row per item and functional call combination within the product organization.

Key Columns

• FUNC_CALL — the functional call (planning activity or process context) that generated the planning header; forms part of the grouping key.
• INVENTORY_ITEM_ID — the surrogate item identifier from the item master.
• ITEM_NUMBER — the concatenated item key flexfield segments, aliased from MTL_SYSTEM_ITEMS_B_KFV.CONCATENATED_SEGMENTS.
• ITEM_DESCRIPTION — the descriptive text for the item.
• ACTUAL_COST — the summed actual cost recorded against matching planning headers, defaulted to zero where no value exists.
• RECOMMENDED_COST — the summed recommended cost proposed by the planning process.
• DELTA_COST — the summed variance between the recommended and actual positions.

Common Use Cases and Queries

Typical usage is cost variance analysis and replenishment review. A sample query listing the highest actual cost items is:

• SELECT item_number, item_description, func_call, actual_cost, recommended_cost, delta_cost FROM apps.csp_planning_topnode_hdr_v ORDER BY actual_cost DESC;
• SELECT item_number, delta_cost FROM apps.csp_planning_topnode_hdr_v WHERE delta_cost > 0;
• SELECT item_number, SUM(actual_cost) FROM apps.csp_planning_topnode_hdr_v GROUP BY item_number;

Because organization context is derived internally via CSP_PICK_UTILS and HR security packages, consumers should not append their own organization filter; results are already scoped to the product organization. This view is therefore best suited to top-node summary reporting rather than detailed transactional drill-down.