Search Results item_flex_seg




Overview
Explore in AI Chat

Overview

POS_GET is a utility package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification of OTHER. It functions as a centralized retrieval library that returns descriptive and derived values for commonly referenced entities in Oracle Order Management and related modules — persons, items, GL accounts, and GL values. Rather than duplicating lookup logic across forms, reports, and other PL/SQL units, callers invoke POS_GET to obtain a formatted string for a given identifier. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the calling schema rather than as the definer, a common convention for shared APPS utility code. Its header carries a 2002 source-control stamp, indicating it is a long-standing component of the EBS codebase, and it is referenced by 18 other packages, confirming its role as a foundational dependency in the order-processing stack.

Key Procedures and Functions

  • GET_PERSON_NAME — Returns the display name for a supplied person identifier, resolving the person through Oracle HR data. GET_PERSON_NAME_CACHE provides the same result through a cached variant, intended to reduce repeated lookups in high-volume processing.
  • ITEM_FLEX_SEG — Accepts a ROWID and returns a VARCHAR2 value representing a key flexfield segment for the item. In practice this function returns the concatenated key flexfield segment string that makes up the item identifier; it is the object most directly associated with the search term item_flex_seg.
  • GET_GL_ACCOUNT — Returns the GL account string associated with a supplied code combination identifier, producing the formatted accounting flexfield value for display or reporting.
  • GET_GL_VALUE — Retrieves a specific GL value using application, key flexfield code, flexfield number, code combination identifier, and a GL qualifier, allowing the caller to isolate one segment or value from a flexfield structure.
  • GET_ITEM_CONFIG — Returns the configuration description or configuration identifier for a given item and organization combination, supporting configured-item processing in order management.
  • GET_ITEM_NUMBER — Returns the item number (user-facing item name) for a supplied item identifier and organization identifier.
  • GET_CHANGED_AMOUNT and GET_CHG_AMT_EXCL_OPT — Documented in the 12.2.2 package metadata, these functions relate to changed-amount computations, with the latter providing the amount excluding options. They support pricing or adjustment logic where a delta amount must be derived.

Tables Accessed

The package reads from two documented sources via APPS synonyms. MTL_SYSTEM_ITEMS_KFV is the key-flexfield view over MTL_SYSTEM_ITEMS, supplying item number and flexfield segment values; it directly underlies ITEM_FLEX_SEG and GET_ITEM_NUMBER. PER_ALL_PEOPLE_F is the effective-dated HR people table, supplying person names for GET_PERSON_NAME and its cached counterpart. The GL-related functions resolve flexfield values through the standard key-flexfield infrastructure rather than through direct table access listed in the metadata.

Usage Notes

POS_GET is typically invoked from Oracle Forms personalizations and custom library code where a formatted description is needed from an identifier, for example rendering an item number or flexfield segment on an order line. It is also called from other PL/SQL packages — 18 documented dependents — which treat it as a shared lookup layer. Because each function returns a scalar VALUE, the package is well suited to SQL embedding, default-value derivation in form fields, and report formatting logic. Customizations should treat the package as read-only and avoid modifying it in the APPS schema; its functions may be called directly subject to the standard restrictions on invoking Oracle-owned code in a supported manner.