GMI — Process Manufacturing Inventory
82 documented tables · 64 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
IC_TEXT_HDR |
Master table for creation and storage of text codes associated with GMI tables. | hub-leaning |
IC_WHSE_MST |
Warehouse master.This table contains warehouse definition information. | hub |
IC_ITEM_MST_B |
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control | hub |
IC_ITEM_MST |
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control | hub-leaning |
IC_LOTS_MST |
This is the lot master table. This table stores data about individual lots for an item. | hub |
IC_LOTS_STS |
Lot status table. | hub-leaning |
IC_TAXN_CLS |
Item tax class | hub-leaning |
IC_INVN_CLS |
This table contains the inventory classes for use throughout OPM. | satellite-leaning |
IC_PKGS_MST |
*NOT USED* | satellite-leaning |
IC_INVN_TYP |
This table contains the definition of the Inventory Types that can be used throughout OPM. | hub-leaning |
IC_COMD_CDS |
Commodity Codes Table. This table contains information about the commodity codes which are used by the Intrast | hub-leaning |
IC_TXN_REQUEST_HEADERS |
Move Order Headers | hub-leaning |
IC_PRCE_CLS |
This table contains the price classes defined for use throughout OPM. | hub-leaning |
IC_COST_CLS |
Item costing class | hub-leaning |
IC_CYCL_HDR |
This table contains the cycle header information. It will define the warehouse for which the count is taking p | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
GMI_TRANS_ENGINE_PUB |
PUB | 6 | 26 packages |
GMI_AUTO_ALLOCATE_PUB |
PUB | 1 | 5 packages |
GMI_VALID_GRP |
GRP | 47 | 4 packages |
GMI_GLOBAL_GRP |
GRP | 6 | 4 packages |
GMI_LOTS_PUB |
PUB | 2 | 3 packages |
GMI_RESERVATION_PUB |
PUB | 5 | 2 packages |
GMI_PICK_RELEASE_PUB |
PUB | 1 | 1 packages |
GMI_QUANTITY_PUB |
PUB | 1 | 1 packages |
GMI_OM_ALLOC_API_PUB |
PUB | 4 | 1 packages |
GMI_PICK_CONFIRM_PUB |
PUB | 2 | 1 packages |