Search Results gmp_item_wps

Overview

The GMP_ITEM_WPS table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing (OPM) Process Planning module (GMP). Its primary function is to store and manage scheduling information for items within the Work in Process Scheduler (WPS). This table acts as a central repository that links items to specific warehouses and plants, enabling the system to control and coordinate manufacturing scheduling activities. It is essential for defining which items are subject to detailed production scheduling and where those scheduling rules are applied, forming a critical junction between item masters, organizational units, and the scheduling engine.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique scheduling record for each combination of item, warehouse, and plant. The key columns are ITEM_ID, WHSE_CODE, and PLANT_CODE. While the specific non-key columns are not detailed in the provided metadata, the foreign key relationships indicate that ITEM_NO is also stored, likely for convenience in reporting and integration. The table's primary purpose is to establish the foundational link between an item and its designated scheduling location (plant and warehouse), which the WPS uses to apply appropriate scheduling algorithms, calculate lead times, and sequence production orders.

Common Use Cases and Queries

A primary use case is validating or reporting on all items enabled for scheduling in a particular facility. For example, a planner may need a list of scheduled items in a specific plant. A common query involves joining to the item master to retrieve descriptive information.

SELECT iim.ITEM_NO, iim.DESCRIPTION, giw.WHSE_CODE, giw.PLANT_CODE
FROM GMP.GMP_ITEM_WPS giw,
     INV.IC_ITEM_MST_B iim
WHERE giw.ITEM_ID = iim.ITEM_ID
  AND giw.PLANT_CODE = 'MAIN_PLANT';

Another critical scenario is integration, where this table is referenced to determine if a new or changed item should be incorporated into the WPS scheduling horizon. Data maintenance programs or APIs will query this table to insert, update, or delete scheduling eligibility for items based on changes in item attributes or organizational assignments.

Related Objects

The GMP_ITEM_WPS table maintains strict referential integrity with several fundamental EBS inventory and organizational tables, as documented by its foreign keys:

• IC_ITEM_MST_B: The item master table. The relationship is via GMP_ITEM_WPS.ITEM_ID and GMP_ITEM_WPS.ITEM_NO to ensure the scheduled item is valid and to pull item details.
• IC_WHSE_MST: The warehouse master table. Joined via GMP_ITEM_WPS.WHSE_CODE to validate the warehouse and access its attributes.
• SY_ORGN_MST_B: The organization master table. Joined via GMP_ITEM_WPS.PLANT_CODE to validate the plant organization and its hierarchy.

The primary key constraint GMP_ITEM_WPS_PK enforces uniqueness on the combination of ITEM_ID, WHSE_CODE, and PLANT_CODE. This table is a likely parent or reference point for other GMP scheduling detail tables not listed in the provided excerpt.