Results for “loc_assign”

50+ results




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

Overview

INV_CUSTOMER_ITEM_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified as a GRP (group) package, indicating it bundles related utility logic rather than exposing a formal public API. Its principal business function is to resolve and supply customer item attributes within the Oracle Inventory and Order Management data model. The package bridges the customer item numbering scheme and the internal inventory item master by retrieving attribute values that describe how a specific customer identifies and references an item ordered or shipped by the enterprise.

The package is validated and active in the APPS schema, and it depends on the SYS standard objects referenced in the ETRM dependency listing. It is a shared, reusable component, evidenced by the fact that six other packages reference it, including OE_BLANKET_UTIL, OE_BULK_PROCESS_LINE, OE_LINE_UTIL, OE_ORDER_IMPORT_SPECIFIC_PVT, IBE_QUOTE_MISC_PVT, and RLM_VALIDATEDEMAND_SV.

Key Procedures and Functions

The ETRM metadata documents two callable units within INV_CUSTOMER_ITEM_GRP:

  • CI_ATTRIBUTE_VALUE — Retrieves the value of a specified customer item attribute. This unit resolves the customer item context and returns the attribute value requested by the calling program.
  • FETCH_ATTRIBUTES — Performs the broader retrieval of customer item attributes, populating the set of attribute values associated with a given customer item relationship.

Both units operate on customer item data and are structured to be invoked by order entry, order import, and related processing packages. Parameter lists are not enumerated in the ETRM documentation and should be confirmed against the deployed package specification before direct invocation.

Tables Accessed

The package accesses the following tables, referenced through APPS synonyms:

  • MTL_CUSTOMER_ITEMS — The master table of customer-defined item numbers, providing the core customer item definition.
  • MTL_CUSTOMER_ITEM_XREFS — Holds cross-references between customer items and internal inventory items, enabling the resolution of the relationship the package queries.
  • MTL_SYSTEM_ITEMS — The inventory item master, supplying internal item attributes used to complete the requested information.
  • MTL_PARAMETERS — The inventory organization parameters, used to establish the operating context.
  • HZ_CUST_ACCT_SITES_ALL — The customer account site table, used to resolve the customer and ship-to context for the customer item.

Usage Notes

INV_CUSTOMER_ITEM_GRP is typically invoked indirectly rather than through a dedicated form. Order Management and related modules call it during order line processing, order import, blanket agreement utilization, bulk line processing, and demand validation. Because it is referenced by OE_LINE_UTIL and OE_BULK_PROCESS_LINE, it participates in the resolution of customer item attributes at the point where a customer item number must be translated or validated against the internal item master.

Custom code should treat the package as a supporting utility and call it only when the same customer item attribute resolution is required. Developers must verify the current package specification for exact signatures before use, and should avoid modifying the APPS-owned package, relying instead on supported extension mechanisms.