Search Results source_organization_name




Overview
Explore in AI Chat

Overview

The CSP_DC_PARTS_V view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a reporting and integration construct belonging to the CSP – Spares Management product. It consolidates demand, supply, and reservation information for spare parts so that downstream applications, dashboards, and interface programs can present a unified "direct current" (DC) view of a part's requirement pipeline. The view merges multiple sourcing scenarios — notably reserved material sourced from internal inventory — into a single normalized result set.

The user interest in schedule_arrival_date reflects the common requirement to project when a required spare part will physically arrive. In this view, SCHEDULE_ARRIVAL_DATE is explicitly defined as TO_DATE(NULL) in the reserved-material query branch, meaning the column is structurally exposed but not populated for reservation-sourced rows. Practitioners should be aware that the arrival date is a placeholder in this branch, and populated logic (if any) resides in the UNION ALL branches sourced from purchasing or shipping objects.

Underlying Base Objects

The documented metadata shows CSP_DC_PARTS_V is defined over a broad set of base objects spanning inventory, purchasing, order management, and CSP-specific tables, plus several packages and views. Core CSP synonyms include CSP_REQUIREMENT_HEADERS, CSP_REQUIREMENT_LINES, and CSP_REQ_LINE_DETAILS, which supply the requirement header/line identifiers, need-by dates, order-by dates, and task references.

Supply and reservation detail comes from MTL_RESERVATIONS, MTL_PARAMETERS, and MTL_SYSTEM_ITEMS_B_KFV for item concatenated segments. Organization names are resolved through HR_ALL_ORGANIZATION_UNITS (and its VL view). Lookup decoding uses FND_LOOKUPS and FND_LOOKUP_VALUES_VL. Additional documented references include OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, PO_HEADERS, PO_LINE_LOCATIONS_V, PO_REQUISITION_HEADERS, PO_REQUISITION_LINES, and CSP views such as CSP_SHIPPING_DETAILS_V and CSP_PART_PRIORITIES_V, along with packages CS_STD, FND_GLOBAL, HR_GENERAL, HR_SECURITY, CSP_PART_SEARCH_PVT, and CSP_PICK_UTILS. These objects supply validation, security, and item-organization resolution logic.

Key Columns

Common Use Cases and Queries

Typical uses include spare-parts availability dashboards, reservation-based demand reports, and integration extracts feeding planning or procurement systems. A representative query filtering on requirement dates and exposed arrival column follows:

SELECT requirement_header_id, requirement_line_id, inventory_item_id,
concatenated_segments, status_meaning, required_quantity,
need_by_date, order_by_date, schedule_arrival_date
FROM apps.csp_dc_parts_v
WHERE need_by_date BETWEEN :p_from AND :p_to
AND organization_code = :p_org;

Because SCHEDULE_ARRIVAL_DATE returns NULL for reservation-sourced rows, consumers seeking a true arrival projection should join to shipping or purchasing sources (for example, CSP_SHIPPING_DETAILS_V, PO_LINE_LOCATIONS_V) or rely on the UNION ALL branches that populate this attribute. When schedule_arrival_date is the primary filter, results will be empty for reserved-inventory rows, which is an important behavioral caveat in EBS 12.1.1 and 12.2.2.