Search Results supplied_item_number

Overview

APPS.CSP_DC_PARTS_V is a reporting view within the Oracle E-Business Suite 12.1.1 / 12.2.2 supply chain and order fulfillment schema. It presents a consolidated, denormalized result set of parts (items) associated with demand planning and reservation activity, drawn principally from the CSP requirement tables joined to MTL_RESERVATIONS and item master key flexfield views. The view serves as a convenient read interface for reporting on reserved and open demand lines, exposing both the demanded item and the corresponding supplied item number in a single row structure. Its name and the concatenated_segments aliases indicate that it is intended to flatten item identifiers into user-visible key flexfield (KFF) concatenations, which is typically the format required by external integrations, BI Publisher reports, and ad-hoc SQL. A specific search for "supplied_item_number" points to the column aliased as supplied_item_number, which carries the KFF concatenated_segments of the supplying (reserved) item, distinguishing it from the primary demanded inventory_item_id.

Underlying Base Objects

The documented view text shows a UNION ALL of two branches keyed on source_type = 'RES' (reserved) and a complementary set for 'OPEN' lines. Its joins flow through CSP_REQUIREMENT_LINES, CSP_REQ_LINE_DETAILS and CSP_REQUIREMENT_HEADERS, with the detail-level source_id mapped to MTL_RESERVATIONS.reservation_id. Item identification is resolved through MTL_SYSTEM_ITEMS_B_KFV (aliased msibk for the demand item and msibk1 for the supplied item), both constrained to the item-validating organization returned by CS_STD.GET_ITEM_VALDN_ORGZN_ID. Organization context is supplied by MTL_PARAMETERS and HR_ALL_ORGANIZATION_UNITS. Lookups are decoded using FND_LOOKUPS for source type and order-line status ('CSP_REQ_SOURCE_TYPE', 'CSP_ORDER_LINE_STATUS_NO_OE'). The documented metadata additionally lists dependencies on CSP_PART_PRIORITIES_V, CSP_PART_SEARCH_PVT, CSP_PICK_UTILS, CSP_SHIPPING_DETAILS_V, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, PO_HEADERS, PO_REQUISITION_HEADERS, PO_REQUISITION_LINES, PO_LINE_LOCATIONS_V, PO_HEADERS_SV3, FND_GLOBAL, HR_GENERAL and HR_SECURITY, reflecting the wider CSP demand/supply consolidation model and its organization-security and picking logic.

Key Columns

• requirement_header_id / requirement_line_id / req_line_detail_id — keys tracing the row back to the CSP requirement hierarchy.
• source_type_meaning — decoded lookup meaning for the requirement source (e.g., Reserved).
• order_number — aliased to mr.reservation_id, identifying the reservation sourcing the line.
• inventory_item_id — the demanded item identifier.
• concatenated_segments — the KFF item number of the demanded item.
• supplied_item_number — aliased to msibk1.concatenated_segments; the KFF item number of the supplying/reserved item.
• description — description of the supplied item (msibk1).
• organization_id / organization_code / source_organization_name — warehouse/organization context.
• required_quantity / ordered_quantity — demanded quantity versus reservation_quantity.
• need_by_date / order_by_date / schedule_arrival_date — scheduling dates.
• task_id / task_assignment_id — project/task references where applicable.
• status_meaning — decoded CSP order-line status (e.g., RESERVED).

Common Use Cases and Queries

The view is used to reconcile demand against reserved inventory and to expose supplied item numbers for integration or reporting. A typical query retrieving supplied item numbers for reserved lines is:

• SELECT requirement_header_id, inventory_item_id, concatenated_segments, supplied_item_number, description, ordered_quantity, status_meaning FROM APPS.CSP_DC_PARTS_V WHERE status_meaning = 'RESERVED';
• SELECT concatenated_segments AS demanded_item, supplied_item_number, SUM(ordered_quantity) FROM APPS.CSP_DC_PARTS_V GROUP BY concatenated_segments, supplied_item_number;
• SELECT * FROM APPS.CSP_DC_PARTS_V WHERE supplied_item_number = :item_number;

These patterns support reservation audit, demand-versus-supply matching, and item-level drill-down reporting where the supplied item key flexfield must be presented rather than the internal inventory_item_id.