Results for “csp_dc_parts_v”

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

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

• REQUIREMENT_HEADER_ID / REQUIREMENT_LINE_ID / REQ_LINE_DETAIL_ID — Primary keys linking the row to CSP requirement structures.
• SOURCE_TYPE_MEANING — Decoded lookup value describing the origin of the requirement line.
• ORDER_NUMBER — Reservation ID acting as the order reference for reserved supply.
• INVENTORY_ITEM_ID / CONCATENATED_SEGMENTS / CATEGORY — Item identity and part category.
• STATUS_MEANING — Status derived from the CSP_ORDER_LINE_STATUS_NO_OE lookup; the reserved branch hardcodes 'RESERVED'.
• SUPPLIED_ITEM_NUMBER / DESCRIPTION — Item supplied against the requirement.
• ORGANIZATION_ID / ORGANIZATION_CODE / SOURCE_ORGANIZATION_NAME — Supplying organization context.
• REQUIRED_QUANTITY / ORDERED_QUANTITY / ORDER_QUANTITY_UOM — Demand and reservation quantities; UOM is null in the reserved branch.
• NEED_BY_DATE / ORDER_BY_DATE — Planning dates from the requirement header and line.
• SCHEDULE_ARRIVAL_DATE — Exposed as TO_DATE(NULL) in the reserved branch; consumers must not assume a populated value.
• TASK_ID / TASK_ASSIGNMENT_ID — Maintenance task linkage.

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.