Search Results get_location_name

Overview

BOM_RTG_EXP_UTIL is a utility package body owned by the APPS schema in Oracle E-Business Suite, classified in ETRM as a UTIL object. Its source header indicates initial creation on 06-OCT-2002 under the filename BOMBREVIB.pls, and it is delivered as part of the Oracle Bills of Material routing and export infrastructure. The package supplies low-level lookup and conversion helpers that other modules of the routing export feature rely upon, rather than exposing any user-facing business transaction. In the stated source excerpt the package body contains four functions: GET_ITEM_NAME, GET_ITEM_ID, GET_LOCATION_NAME, and GET_LOCATOR_ID. Together these functions translate between surrogate identifiers and human-readable flexfield segment strings for inventory items and stock locators. ETRM documents the object as referenced by one other package, confirming its role as a shared dependency rather than an entry point. The metadata carries no documented parameters, so only the purpose of each function is described below.

Key Procedures and Functions

• GET_ITEM_NAME — Returns the display name of an inventory item when supplied with its inventory item identifier. The item name is sourced from the concatenated flexfield segments of the item key flexfield.
• GET_ITEM_ID — The inverse of GET_ITEM_NAME and the function most directly associated with the search term "get_item_id". It accepts an item name and returns the corresponding inventory item identifier, resolving the flexfield concatenated segment string back to the internal numeric key.
• GET_LOCATION_NAME — Returns the concatenated segment name for a stock locator, given a locator identifier together with an organization identifier. The source shows the body delegating to INV_PROJECT.GET_LOCSEGS.
• GET_LOCATOR_ID — Performs the reverse resolution for locators, converting a location name string into a locator identifier within a specified organization. The source indicates it calls INVPUOPI.mtl_pr_parse_flex_name with flex code 'MTLL' to parse the flexfield name.

Tables Accessed

ETRM records a single directly referenced table for this package: MTL_SYSTEM_ITEMS_KFV, accessed through an APPS synonym. This is the key flexfield view of MTL_SYSTEM_ITEMS, which exposes the concatenated_segments column used both to return an item name and to look up an item identifier. Because it is a view over the item master, lookups are read-only; the package does not maintain item or locator data. Use of the KFV view means the functions are sensitive to the item key flexfield structure and to any security or organization context that constrains row visibility. Locator related behaviour additionally depends on the INV_PROJECT and INVPUOPI APIs named in the source body.

Usage Notes

As a UTIL class object, BOM_RTG_EXP_UTIL is intended for invocation from other PL/SQL code rather than directly by end users. It is most plausibly called during routing export processing, where interface records carry segment strings that must be resolved to internal identifiers, or where identifiers must be rendered back into readable names for output. Typical callers include concurrent programs and custom packages that build or consume routing export data, and the single documented referencing package indicates internal reuse within the BOM product family. Because the documented exception handling returns NULL on error, callers should not assume a valid identifier or name was resolved and should perform their own null checks. Any custom code using GET_ITEM_ID should be aware that it selects on concatenated_segments with ROWNUM restricted to one row, so duplicate or ambiguous item names across organizations may yield an unpredictable match. Callers operating in a multi-organization environment should therefore validate results against the intended organization before committing downstream data.