Results for “ordered_quantity”

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

Overview

CSD_OE_LINE_STATUS_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CSD (Depot Repair) product family. It exposes order management line-level status information that is surfaced to the user through the Status Details tab of the Depot Repair (Service) application. The view provides a concise, pre-joined representation of depot repair order lines, allowing the user interface and dependent components to display order line context alongside flow status without querying the large Order Management transaction tables directly.

Because the object is a VIEW rather than a table, it stores no data of its own. It is a read-only projection defined over a synonym that resolves to the Order Management base table. The view is marked VALID in the APPS schema for both Oracle EBS 12.1.1 and 12.2.2, confirming that the underlying definition has remained consistent across these releases. Its narrow column list and simple filter logic make it suitable for lightweight reporting and for populating the Status Details tab, where administrators and depot repair users inspect line-level progress of repair orders.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is defined over a single referenced base object: the synonym OE_ORDER_LINES_ALL. During compilation and execution this synonym resolves to the Order Management tables OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL (the header and line transaction tables). The view text confirms this relationship directly:

• The SELECT list draws HEADER_ID, LINE_ID, LINE_NUMBER, SHIPMENT_NUMBER, ORDERED_QUANTITY, and FLOW_STATUS_CODE from OE_ORDER_LINES_ALL.
• The derived LINE_NUMBER column concatenates LINE_NUMBER and SHIPMENT_NUMBER with a period delimiter.
• Results are ordered by LINE_NUMBER and SHIPMENT_NUMBER, producing the ordered line sequence displayed on the Status Details tab.

No joins, filters, or grouping clauses are present in the documented view text, so the view is a straightforward ordered projection of Order Management line records. In 12.1.1 the same OE_ORDER_LINES_ALL synonym is referenced, ensuring behavioral parity between the two release levels.

Key Columns

• HEADER_ID — Identifier of the parent order header, linking each line to its Order Management header record. Useful for grouping lines by order.
• LINE_ID — Unique identifier of the order line; the primary join key back to OE_ORDER_LINES_ALL and to downstream depot repair entities.
• LINE_NUMBER — A formatted character value combining the numeric line number with the shipment number (for example, 1.1), matching the display convention of the Status Details tab.
• ORDERED_QUANTITY — The quantity ordered for the line, reflecting the transaction quantity recorded in Order Management.
• FLOW_STATUS_CODE — The current Order Management flow status code (for example, BOOKED, SHIPPED, CLOSED, or CANCELLED), indicating the line's position in the order lifecycle.

These columns provide a compact, human-readable status summary. Note that the view exposes no header-level status or customer attributes; consumers requiring those must join to Order Management headers or to depot repair tables on HEADER_ID or LINE_ID.

Common Use Cases and Queries

The view is most commonly used to drive the Status Details tab in Depot Repair and to support diagnostic queries that reconcile depot repair order lines with their Order Management flow status. Because ordering is applied within the view, results return in line/shipment sequence without requiring additional ORDER BY clauses in simple reports.

• Displaying all line statuses for a specific order: filter on HEADER_ID.
• Inspecting a single line's lifecycle state: filter on LINE_ID.
• Monitoring lines in a particular state: filter on FLOW_STATUS_CODE.
• Reconciling repair order quantities against Order Management: select the order-related columns and cross-reference with depot repair tables.

Sample query retrieving the status of all lines for a given order:

SELECT header_id, line_id, line_number, ordered_quantity, flow_status_code FROM apps.csd_oe_line_status_v WHERE header_id = :p_header_id;

Sample query listing all currently booked lines:

SELECT line_id, line_number, ordered_quantity FROM apps.csd_oe_line_status_v WHERE flow_status_code = 'BOOKED' ORDER BY line_number;

Because the view contains no depot repair-specific columns, queries that require repair order context should join back to the relevant CSD tables using HEADER_ID or LINE_ID. The view remains a reliable, release-stable access path to Order Management line status information across EBS 12.1.1 and 12.2.2.