Search Results gmp_item_aps




Overview
Explore in AI Chat

Overview

The GMP_ITEM_APS table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMP) module, specifically for the Process Planning submodule. It functions as the Item Master Table for Advanced Planning and Scheduling (APS). This table serves as a critical integration point, linking standard Oracle Inventory item definitions with the specialized planning and scheduling requirements of a process manufacturing environment. It stores item-specific planning parameters that are essential for APS engines to generate feasible production schedules, considering constraints like plant and warehouse assignments.

Key Information Stored

The table's structure centers on identifying an item and its relevant planning context. The primary key is a composite of ITEM_ID, WHSE_CODE, and PLANT_CODE, indicating that planning data is maintained at the granular level of a specific item within a specific warehouse and plant combination. Key columns include ITEM_ID and ITEM_NO, which link to the foundational item definition in IC_ITEM_MST/_B tables. The WHSE_CODE and PLANT_CODE columns tie the item to its physical and organizational locations, referencing IC_WHSE_MST and SY_ORGN_MST respectively. The ITEM_UM column, referencing SY_UOMS_MST, defines the unit of measure used for planning purposes. This table typically holds APS-specific attributes not found in the general item master, such as planning method flags, fixed/variable lead times, and scheduling constraints.

Common Use Cases and Queries

This table is primarily accessed during APS planning runs, custom planning reports, and data validation setups. A common use case is to extract all items enabled for APS planning within a specific plant to feed the scheduling engine. A typical query would join GMP_ITEM_APS with the inventory item master to retrieve a comprehensive planning item list:

  • SELECT gia.PLANT_CODE, gia.WHSE_CODE, iim.ITEM_NO, iim.DESCRIPTION FROM GMP.GMP_ITEM_APS gia, INV.IC_ITEM_MST iim WHERE gia.ITEM_ID = iim.ITEM_ID AND gia.PLANT_CODE = :p_plant_code;

Another critical scenario is validating that all planned items have the necessary APS master data defined, often using an anti-join to find items in IC_ITEM_MST scheduled for production but missing a corresponding entry in GMP_ITEM_APS.

Related Objects

GMP_ITEM_APS has extensive foreign key relationships, underscoring its integrative role. Its primary dependencies are on the Inventory (INV) and Foundation (SY) modules. Key related objects include:

  • IC_ITEM_MST / IC_ITEM_MST_B: The core item master tables, linked via ITEM_ID and ITEM_NO.
  • IC_WHSE_MST: The warehouse master, linked via WHSE_CODE.
  • SY_ORGN_MST / SY_ORGN_MST_B: The organization master defining plants, linked via PLANT_CODE.
  • SY_UOMS_MST: The unit of measure master, linked via ITEM_UM.
  • Other GMP planning tables (e.g., GMP_RESOURCE_APS, GMP_ROUTING_APS) likely reference or are used in conjunction with this item master to form a complete APS data model.