Search Results original_line_status




Overview
Explore in AI Chat

Overview

CSD_WSH_LINE_STATUS_V is a seeded APPS-schema view in the Oracle E-Business Suite Depot Repair (CSD) module. It is documented as the "View for shipping line status on status details tab" and exists to surface the pick/release status of shipping lines associated with Depot Repair service orders. The view is defined over standard Oracle Order Management and Shipping Execution tables, joining order line information to delivery detail records and resolving the shipping status code into a user-facing meaning through the shipping lookup set.

Its principal reporting purpose is to expose the ORIGINAL_LINE_STATUS — a value that users search for directly. This column returns the translated MEANING from the WSH_LOOKUPS lookup type PICK_STATUS, derived from the RELEASED_STATUS code on the delivery detail record. Because the view is limited to standard deliveries (DELIVERY_TYPE = 'STANDARD') and to Order Management sourced lines (SOURCE_CODE = 'OE'), it presents a focused, already-filtered result set suitable for embedded UI queries and integration extracts.

Underlying Base Objects

The documented base objects, as recorded in ETRM 12.2.2, are:

  • OE_ORDER_LINES_ALL (SYNONYM) — supplies order line identity, line number, and shipment number, and is the source of SOURCE_HEADER_ID and SOURCE_LINE_ID.
  • WSH_DELIVERY_DETAILS (SYNONYM) — the central shipping table, providing REQUESTED_QUANTITY, RELEASED_STATUS, SOURCE_CODE, and the delivery detail key.
  • WSH_DELIVERY_ASSIGNMENTS_V (VIEW) — links delivery details to deliveries; the view rather than the base assignment table is used, enforcing current assignment semantics.
  • WSH_NEW_DELIVERIES (SYNONYM) — supplies the delivery header and the DELIVERY_TYPE filter.
  • WSH_LOOKUPS (VIEW) — resolves RELEASED_STATUS into the PICK_STATUS meaning returned as ORIGINAL_LINE_STATUS.

The joins are driven from OE_ORDER_LINES_ALL to WSH_DELIVERY_DETAILS on matching header and line identifiers, then to the assignments view, the delivery header, and finally to the lookup. This chain means a row is only returned when an order line is attached to a standard delivery and carries a releasable status.

Key Columns

  • SOURCE_HEADER_ID — the order header identifier from which the delivery detail originated.
  • SOURCE_LINE_ID — the order line identifier corresponding to the delivery detail.
  • LINE_NUMBER — a concatenation of the order line number and the shipment number, formatted as line.shipment.
  • REQUESTED_QUANTITY — the quantity requested on the delivery detail for that order line.
  • ORIGINAL_LINE_STATUS — the translated pick status meaning derived from the delivery detail's released status code via the PICK_STATUS lookup.

Common Use Cases and Queries

The view is typically queried from Depot Repair status detail pages and from custom reports or concurrent programs needing shipping line status without re-deriving the lookup translation. A representative query follows:

  • SELECT source_header_id, source_line_id, line_number, requested_quantity, original_line_status FROM apps.csd_wsh_line_status_v WHERE source_header_id = :p_header_id ORDER BY line_number;
  • SELECT original_line_status, COUNT(*) FROM apps.csd_wsh_line_status_v GROUP BY original_line_status;

Because the view already restricts results to standard, order-sourced deliveries, consumers do not need to repeat those predicates. Join it to Depot Repair order headers on SOURCE_HEADER_ID to drive status displays, or use ORIGINAL_LINE_STATUS directly for status summary dashboards.