Search Results g_tbl_index

Overview

APPS.FLM_ROUTING is a PL/SQL package body that supports the Flow Manufacturing (FLM) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to identify and return sets of routable assemblies and option items that satisfy the selection criteria required by flow routing enquiries, mass change operations, and routing-related processing screens. The package encapsulates the logic that determines which inventory items are eligible for routing operations based on bill of material attributes, item flags, category memberships, planner codes, and alternate routing designators. By centralising this selection logic, FLM_ROUTING provides a reusable API layer for forms and concurrent programs that need to obtain lists of routing-relevant items without duplicating complex item-filtering SQL. The package body carries a header revision of 120.1 dated 2006/05/16, reflecting its maintenance lineage across multiple EBS releases.

Key Procedures and Functions

Three procedures are documented within the package body:

• RETRIEVE_ITEMS — Returns a table of inventory items that match a broad set of routing-selection parameters, including organization, item range, product family, category set, planner code, and alternate routing designator. It filters on BOM-enabled, inventory-enabled, non-pick, non-engineering items and excludes items that already carry a matching operational routing. A common cursor object, internally labelled in the source as all_items, drives this retrieval.
• RETRIEVE_OPTION_ITEMS — Returns option-class items relevant to routing configuration, typically used to populate option item selection lists in flow manufacturing enquiries.
• RETRIEVE_MASS_CHANGE_ITEMS — Returns items eligible for mass change operations on routings, supporting bulk maintenance of operational routing data across selected assemblies.

The parameter lists are declared in the package specification and are not invented here; the documented excerpt illustrates RETRIEVE_ITEMS using IN parameters for organisation, item ranges, product family, category, planner, and alternate routing designator, with two OUT NOCOPY parameters returning an item table and a return code.

Tables Accessed

The package reads from several APPS-synonym objects:

• MTL_SYSTEM_ITEMS_KFV — the key flexfield view supplying concatenated item segments and item attribute flags used for filtering.
• BOM_BILL_OF_MATERIALS and BOM_INVENTORY_COMPONENTS — referenced indirectly (not in the documented list but visible in the source) to expand product family membership into component item IDs.
• MTL_ITEM_CATEGORIES — restricts selection to items assigned to a specified category set and category.
• BOM_OPERATIONAL_ROUTINGS — used in a NOT EXISTS clause to exclude items already having a routing with a matching alternate routing designator.
• BOM_ALTERNATE_DESIGNATORS — validates and resolves alternate routing designators applied to items.
• PLITBLM — the standard EBS temporary/concurrent table used to hold item identifier lists produced by these retrieval procedures.

Usage Notes

FLM_ROUTING is typically invoked from Flow Manufacturing forms and concurrent programs that require filtered item lists for routing definition, mass change processing, and option item assignment. The procedures populate PL/SQL collection types returned through OUT NOCOPY parameters, which calling forms then bind to multi-row blocks. The ETRM metadata records that the package is referenced by zero other packages, indicating it is an entry-point API rather than a shared utility, and it is classified as OTHER rather than a public or private API. Custom code extending flow routing functionality may call these procedures directly, but callers should honour the organisation context and supply a valid alternate routing designator—often a null or sentinel value—to match the routing-exclusion logic. The g_tbl_index identifier commonly associated with this package reflects the local collection index variable used to iterate the returned item table within these procedures.