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.
-
Item Master Table for APS
-
Item Master Table for APS
-
SYNONYM: APPS.GMP_ITEM_APS 12.2.2
-
TABLE: GMP.GMP_ITEM_APS 12.2.2
-
SYNONYM: APPS.GMP_ITEM_APS 12.1.1
-
TABLE: GMP.GMP_ITEM_APS 12.1.1
-
VIEW: GMP.GMP_ITEM_APS# 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
VIEW: GMP.GMP_ITEM_APS# 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
Table: IC_ITEM_MST 12.1.1
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
Not implemented in this database·Explore GMI module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
Table: IC_ITEM_MST 12.2.2
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
Not implemented in this database·Explore GMI module →
-
12.2.2 FND Design Data 12.2.2
-
Table: SY_ORGN_MST 12.1.1
Organization code master.
Not implemented in this database·Explore GMA module →
-
Table: SY_ORGN_MST 12.2.2
Organization code master.
Not implemented in this database·Explore GMA module →
-
Table: SY_UOMS_MST 12.2.2
Unit of measure master for Oracle Process Manufacturing. Synchronized with MTL_UNITS_OF_MEASURE and associated tables when Oracle Financials is used.
Not implemented in this database·Explore GMA module →
-
Table: SY_UOMS_MST 12.1.1
Unit of measure master for Oracle Process Manufacturing. Synchronized with MTL_UNITS_OF_MEASURE and associated tables when Oracle Financials is used.
Not implemented in this database·Explore GMA module →
-
eTRM - GMP Tables and Views 12.2.2
* NOT USED *
-
eTRM - GMP Tables and Views 12.1.1
* NOT USED *
-
eTRM - GMP Tables and Views 12.1.1
* NOT USED *
-
eTRM - GMP Tables and Views 12.2.2
* NOT USED *
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1