Search Results so_transactions_flag




Overview
Explore in AI Chat

Overview

The SO_PICKING_LINE_DET_OEXORRSO_V view is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 database object owned by the APPS schema and registered under the Order Entry (OE) product family. It is a denormalized, reporting-oriented view built over the picking line detail entity within Oracle Order Management and Shipping Execution. Its principal purpose is to expose picking line attribute data alongside material and warehouse denormalizations, enabling downstream reports, concurrent programs, and integration interfaces to retrieve order fulfillment details without directly joining the underlying transactional tables.

The suffix convention "OEXORRSO" indicates the object is used by an Oracle Shipping Execution (WSH) report or integration, where picking line detail information must be presented with human-readable item and warehouse context. The view is particularly relevant to users searching the so_transactions_flag element, since the picking line lifecycle flags (such as RELEASED_FLAG, TRANSACTABLE_FLAG, RESERVABLE_FLAG, and UPDATE_FLAG) are surfaced directly by this object and are frequently used to qualify transaction-eligible records.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is defined over the following objects:

  • SO_PICKING_LINE_DETAILS (synonym) — the primary transactional source, aliased as SOPLD, providing all picking line detail columns.
  • MTL_PARAMETERS (synonym) — supplies warehouse/organization context, including ORGANIZATION_CODE.
  • MTL_SYSTEM_ITEMS (synonym) — provides item control attributes such as revision, lot, and inventory asset flags.
  • MTL_SYSTEM_ITEMS_KFV (synonym) — the key flexfield concatenated view of items, used to present descriptive item identifiers.
  • SO_LOOKUPS (synonym) — resolves lookup codes such as DETAIL_TYPE_CODE and SCHEDULE_STATUS_CODE into meaningful values.
  • FND_GLOBAL (package) — provides session context, notably the organization and user identifiers used for multi-org security.
  • FND_PROFILE (package) — supplies profile option values that may drive conditional display or filtering logic.
  • OE_QUERY (package) — an Order Entry query utility invoked within the view definition to enforce organizational and functional security predicates.

The view therefore acts as a join envelope, combining picking line detail granularity with item master and warehouse attributes.

Key Columns

The view exposes the full column list of SO_PICKING_LINE_DETAILS, plus derived columns. Notable transactional columns include:

Common Use Cases and Queries

Typical usages include shipping report generation, pick confirmation reconciliation, and integration extraction for warehouse management systems. A frequent pattern is filtering picking lines by transaction readiness flags:

  • Identify released, transaction-eligible picking lines for a given warehouse.
  • Reconcile requested versus shipped quantities per picking line for fill-rate reporting.
  • Extract lot and serial controlled items requiring special handling at pick confirmation.
  • Feed external shipping systems with denormalized item and warehouse descriptions.

Sample query:

SELECT v.picking_line_detail_id,
       v.picking_line_id,
       v.warehouse,
       v.segment1 AS item,
       v.requested_quantity,
       v.shipped_quantity,
       v.released_flag,
       v.transactable_flag
FROM   apps.so_picking_line_det_oexorrso_v v
WHERE  v.released_flag = 'Y'
AND    v.transactable_flag = 'Y'
AND    v.warehouse_id = :p_organization_id;

Because the view incorporates FND_GLOBAL and OE_QUERY calls, queries automatically respect the session's organization and functional security context, which is essential when the view is consumed from concurrent programs or custom integrations in an EBS 12.1.1 or 12.2.2 environment.