Results for “lot_control”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMP_ITEM_WPS is a table in the GMP schema (Process Manufacturing Process Planning) that stores OPM items scheduling data used by the Work-in-Process Scheduling (WPS) functionality in Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, this table acts as a plant and warehouse-scoped registry of process manufacturing items that participate in scheduling, replenishment, and consumption activities. Each row represents a specific item, defined at a specific warehouse within a specific plant, with attributes that drive how that item is scheduled.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is link. This classification suggests the table functions as a connector that associates an item with a warehouse and a plant, rather than existing as a pure reference hub or an attribute satellite. The table therefore sits at the intersection of item, warehouse, and organization master data and carries both relationship and descriptive scheduling attributes.

Key Information Stored

The table is keyed by the composite primary key GMP_ITEM_WPS_PK, defined on ITEM_ID, WHSE_CODE, and PLANT_CODE. This composite key is the documented unique index and business-key candidate, meaning that an item may appear multiple times if it is scheduled in more than one warehouse or plant combination.

• ITEM_ID — Foreign key to the item master (IC_ITEM_MST_B), identifying the process manufacturing item.
• ITEM_NO — The user-visible item number, also related to IC_ITEM_MST_B.
• ITEM_DESC1 — The primary description of the item.
• ITEM_UM / UOM_CODE — The unit of measure associated with the item.
• LOT_CONTROL — Indicates whether the item is lot-controlled, a critical attribute for process manufacturing scheduling.
• APS_ITEM_ID — The identifier linking the item to Advanced Planning and Scheduling (APS) logic, supporting scheduling integration.
• ORGANIZATION_ID — The inventory organization context for the item record.
• WHSE_CODE — Foreign key to IC_WHSE_MST, the warehouse where the item is scheduled.
• PLANT_CODE — Foreign key to SY_ORGN_MST_B, the plant or operating unit organization.
• REPLEN_IND — A replenishment indicator controlling whether the item participates in replenishment scheduling.
• CONSUM_IND — A consumption indicator governing whether the item is treated as a consumed component in scheduling.
• CREATION_DATE / CREATED_BY / LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard audit columns tracking record creation and maintenance.

Common Use Cases and Queries

Typical scenarios include validating which items are eligible for scheduling at a plant or warehouse, reporting on replenishment versus consumption items, and troubleshooting scheduling exclusions. A common query pattern joins the table to item and warehouse masters:

• Listing scheduled items for a given plant: SELECT item_no, whse_code, replen_ind, consum_ind FROM gmp_item_wps WHERE plant_code = :plant;
• Joining to the item master to obtain descriptions and planning attributes: SELECT w.item_no, i.description FROM gmp_item_wps w, ic_item_mst_b i WHERE w.item_id = i.item_id;
• Reporting lot-controlled items by warehouse: SELECT item_no, whse_code FROM gmp_item_wps WHERE lot_control = 'Y';
• Identifying replenishment-flagged items: filtering on REPLEN_IND = 'Y' for replenishment planning reports.

Related Objects

• IC_ITEM_MST_B — The item master; joined via GMP_ITEM_WPS.ITEM_ID and GMP_ITEM_WPS.ITEM_NO. Provides core item attributes.
• IC_WHSE_MST — The warehouse master; joined via WHSE_CODE, supplying warehouse definitions.
• SY_ORGN_MST_B — The organization/plant master; joined via PLANT_CODE, supplying plant context.
• GMP_ITEM_WPS_PK — The primary key constraint/index on (ITEM_ID, WHSE_CODE, PLANT_CODE).
• APS scheduling objects referenced through APS_ITEM_ID — using this link to tie scheduling data to APS planning logic.