Results for “gmp_item_aps”

50+ results




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

Overview

GMP_ITEM_APS is an item master table owned by the GMP schema and belongs to the Oracle Process Manufacturing (OPM) Process Planning module. In Oracle EBS 12.1.1 and 12.2.2 deployments, this table serves as a planning-oriented snapshot of item definitions scoped by plant and warehouse. It enables the Advanced Planning and Scheduling (APS) and process planning engines to retrieve item attributes that are relevant to replenishment, consumption, and sequencing without joining the broader, transaction-heavy item master structures on every planning pass.

From a data-modeling perspective, the ETRM metadata classifies this object heuristically as a link table. This suggests it functions as an associative structure binding item identity to organizational context — specifically plant and warehouse — while also carrying descriptive and control attributes. In practice it is best understood as a planning resolution table that joins item master data to plant and warehouse master data, resolving valid item-organization-warehouse combinations used by the planning engine.

Key Information Stored

The table contains 20 documented columns. The composite primary key is defined by the GMP_ITEM_APS_PK unique index across ITEM_ID, WHSE_CODE, and PLANT_CODE. This composite key is the business-key candidate: each row represents a unique item-warehouse-plant combination. Because the keys are drawn directly from master data rather than an artificial sequence, there is no separate surrogate primary key column documented.

  • ITEM_ID / ITEM_NO — The item identifier and item number, linking to the item master.
  • ITEM_UM / UOM_CODE — Primary unit of measure for the item and its associated UOM code.
  • WHSE_CODE — Warehouse in which the item is planned; part of the primary key.
  • PLANT_CODE — Plant or organization context; part of the primary key.
  • ORGANIZATION_ID — Internal organization identifier aligned to the plant.
  • APS_ITEM_ID — Planning-specific item identifier used by the APS engine.
  • LOT_CONTROL — Indicates whether the item is lot-controlled, affecting planning and allocation.
  • REPLEN_IND — Replenishment indicator controlling whether the item is planned for supply.
  • CONSUM_IND — Consumption indicator governing whether the item is consumed in planning.
  • CATEGORY_ID — Item category association used for reporting and grouping.
  • SEQ_DEP_ID / SEQ_DPND_CLASS — Sequencing dependency identifiers and class used for process sequencing rules.
  • ITEM_DESC1 — Primary descriptive text for the item.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard EBS audit tracking.

Common Use Cases and Queries

Typical scenarios include validating which items are plannable within a given plant and warehouse, extracting lot-controlled items for compliance, and reconciling APS item definitions against the base item master. A representative query retrieving planning items for a plant follows:

  • SELECT ITEM_NO, ITEM_ID, WHSE_CODE, PLANT_CODE, REPLEN_IND, CONSUM_IND FROM GMP_ITEM_APS WHERE PLANT_CODE = :plant AND WHSE_CODE = :whse;
  • Join to item master for descriptions: SELECT a.ITEM_NO, b.ITEM_DESC FROM GMP_ITEM_APS a, IC_ITEM_MST_B b WHERE a.ITEM_ID = b.ITEM_ID;
  • Filter lot-controlled items: WHERE LOT_CONTROL = 'Y';

Reporting use cases include APS planning extracts, replenishment indicator audits, and warehouse-level item footprint analysis.

Related Objects

The foreign keys establish the object's core relationships. The most significant related tables are:

  • IC_ITEM_MST_B / IC_ITEM_MST — Item master base and translation tables, joined on ITEM_ID and ITEM_NO.
  • IC_WHSE_MST — Warehouse master, joined on WHSE_CODE.
  • SY_ORGN_MST_B / SY_ORGN_MST — Organization master, joined on PLANT_CODE.
  • SY_UOMS_MST — Unit of measure master, joined on ITEM_UM.

These dependencies make GMP_ITEM_APS a planning hub whose validity depends on the corresponding item, warehouse, organization, and UOM master records.