Search Results item_conc_seg




Overview
Explore in AI Chat

Overview

OEXVWLIN is a PL/SQL package in the APPS schema that supports Oracle Order Management (OM) in Oracle EBS 12.1.1 and 12.2.2. It is a view-support package, declared AUTHID CURRENT_USER, and its header ($Header: OEXVWLNS.pls 115.3 99/10/19) shows it originated in the earliest releases of the Order Management module and has remained stable. The package supplies derived column values for the OM sales order line views — most notably the OEX order line view family — where descriptive attributes such as line totals, shipment numbers, line numbers, hold status, and item concatenated segments cannot be resolved by a simple join alone. Each function is wrapped with the PRAGMA RESTRICT_REFERENCES(..., WNDS, WNPS) directive, which permits the functions to be called from SQL statements and views. The package is classified as OTHER in the ETRM/API registry and is not documented as a public, declarative business API; it is an internal utility layer behind the Order Management inquiry and entry views.

Key Procedures and Functions

The package exposes eight functions, each returning a scalar value derived from sales order line data:

  • LINE_TOTAL — Calculates the extended total for an order line, taking row identity, line/type attributes, service flags, ordered and cancelled quantities, and selling price as inputs. It returns a NUMBER and is the principal pricing/quantity aggregation helper for the line view.
  • SCHEDULE_STATUS — Returns the shipping schedule status for a given order line, used to display fulfillment state in the line view.
  • RESERVED_QUANTITY — Returns the quantity reserved against the order line, supporting available-to-promise and inventory commitment displays.
  • HOLD — Returns the hold status for an order line or order header, exposing whether a line is currently prevented from progressing.
  • SHIPMENT_NUMBER — Derives the shipment number for a line or ship schedule line, resolving it from line-parent and schedule-line relationships.
  • LINE_NUMBER — Derives the display line number from the order line or ship schedule line identity.
  • ITEM_CONC_SEG — Resolves the item concatenated segment (the key flexfield combination) for an item and inventory organization; this is the function referenced in the metadata search term item_conc_seg.
  • ORDER_TYPE — Returns the order type name associated with an order type identifier.

Tables Accessed

The package reads from five base tables through APPS synonyms. MTL_SYSTEM_ITEMS_KFV supplies the key flexfield (concatenated segment) description used by ITEM_CONC_SEG. SO_LINE_DETAILS provides the line-level attribute set from which LINE_TOTAL, SHIPMENT_NUMBER, and LINE_NUMBER are derived. SO_LOOKUPS supplies lookup codes and meanings used for status and type interpretation. SO_ORDER_HOLDS_ALL is the source for the HOLD function's status evaluation. SO_ORDER_TYPES provides order type information consumed by ORDER_TYPE. No documented writes are recorded; the functions are read-only and are marked WNDS (write no database state), consistent with their use inside SQL and view definitions.

Usage Notes

OEXVWLIN is invoked indirectly rather than directly by end users. Its functions are embedded in the Order Management inquiry views (the OEX view family), so any form, concurrent program, report, or custom SQL that queries those views will execute OEXVWLIN functions transparently. Because the functions carry RESTRICT_REFERENCES pragmas, they may be called directly from custom SQL or PL/SQL, but this is not the supported interface; the package is undocumented as a public API and Oracle reserves the right to change it without notice. In 12.1.1 and 12.2.2 the package is not referenced by any other documented package (referenced-by count of zero), confirming its role as a leaf utility behind the views. Developers extending Order Management inquiry screens may observe ITEM_CONC_SEG being called per row to render the item flexfield segment; performance-sensitive custom code should resolve that value through MTL_SYSTEM_ITEMS_KFV directly where possible.