Search Results select_items_lov

Overview

APPS.GME_GANTT_LOV_PKG is a Process Manufacturing (OPM/GME) utility package that supplies list-of-values (LOV) queries for the Gantt chart scheduling interface in Oracle E-Business Suite. Its responsibilities center on populating selection lists for the batch Gantt viewer, where production schedulers and planners choose batches, items, resources, and organizations to display on a time-oriented graphical schedule. The package is classified as OTHER under the ETRM API classification scheme, meaning it is not a public, supported business API but an internal helper invoked by the Gantt chart UI layer. The header comment embedded in the source ($Header: GMEGNTLB.pls 120.4 2006/07/10) indicates the package originated in the OPM Gantt (GMEGNT) module and has been stable across releases, including 12.1.1 and 12.2.2. Its central purpose is to return the correct set of batches, filtered by status, type, organization, and date window, so the Gantt chart can render scheduled versus actual timeline bars without over-fetching data.

Key Procedures and Functions

• SELECT_BATCHES_LOV — Returns the batch LOV rows for the Gantt chart. It accepts an input search string, a starting row and row-count for pagination, pending/released/certified status values, an organization identifier, batch type, FPO (flow process order) type, and a from/to date range, returning total row count and a batch LOV detail table. The date-range logic distinguishes planned, actual, and completed batches based on batch_status and the appropriate date columns.
• SELECT_ITEMS_LOV — Populates the item selection list, retrieving inventory items in the context of the OPM batch, joining to the item master to expose concatenated segments and descriptions.
• SELECT_RESOURCES_LOV — Supplies the resource LOV, drawing on the OPM resource definition tables (CR_RSRC_MST, CR_RSRC_MST_B, CR_RSRC_DTL) so planners can filter the Gantt display by resource.
• SELECT_ORGANIZATIONS_LOV — Returns the list of valid organizations for filtering, based on the organization unit and manufacturing parameter tables.

All four procedures follow the same pattern: accept filter and pagination inputs, return a strongly typed table and a total row count via NOCOPY OUT parameters.

Tables Accessed

The package reads from the following documented tables and synonyms:

• GME_BATCH_HEADER — the primary batch master, providing batch number, organization, status, type, and plan/actual start and completion dates used by the date-window filtering.
• GME_MATERIAL_DETAILS — batch material lines; joined with line_type filtering to associate items with batches.
• GMD_PARAMETERS_HDR / GME_PARAMETERS — OPM parameter and profile storage.
• CR_RSRC_MST_B, CR_RSRC_MST, CR_RSRC_DTL — resource master and detail tables backing the resource LOV.
• HR_ALL_ORGANIZATION_UNITS and MTL_PARAMETERS — organization validation and manufacturing context for the organization LOV.
• PLITBLM — the PL/SQL table/array support object used for the paginated return collections.

The excerpt also shows a join to MTL_SYSTEM_ITEMS_VL for concatenated segment and description values, consistent with the item LOV behavior.

Usage Notes

Because it is classified OTHER and referenced by no other packages, GME_GANTT_LOV_PKG is invoked directly by the Gantt chart form or its UI controller rather than by downstream PL/SQL. The procedures are called each time the user opens or refreshes an LOV in the Gantt scheduling window, passing the current search string, pagination offsets, and filters such as organization, batch type, and date range. Custom code should treat this package as internal and unsupported; sites extending Gantt LOV behavior should wrap or replicate the queries rather than calling the procedures directly, since signatures may change between patches. Performance considerations include the DISTINCT batch query and the range predicates on plan and actual dates, which benefit from indexes on GME_BATCH_HEADER date and organization columns.