Results for “consign_ind”

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

Overview

IC_WHSE_MST is the warehouse master table within the Oracle Process Manufacturing (OPM) Inventory module, owned by the GMI schema. In Oracle EBS 12.1.1 and 12.2.2, it stores the definition records for every warehouse recognized by the process manufacturing application. Each row represents a single logical warehouse, and the table acts as the central reference point for inventory balances, transactions, costing, forecasting, purchasing, order management, quality, and production activities across the OPM suite.

Because the table holds the authoritative warehouse identifiers that dozens of dependent tables reference through foreign keys, it functions as a reference or master entity rather than a transactional table. Under the supplied Data Vault classification heuristic, IC_WHSE_MST is best modeled as a hub: its primary key is a stable business identifier and its relationships radiate outward to many satellite and link-style tables. This classification is a modeling suggestion derived from the foreign key structure and should not be interpreted as a physical Data Vault implementation in the EBS schema.

Key Information Stored

The table is documented with 61 columns. The most operationally significant are summarized below.

• WHSE_CODE — The surrogate primary key (IC_WHSE_MST_PK) and the warehouse identifier referenced throughout OPM. This is the column that nearly all dependent tables join on.
• MTL_ORGANIZATION_ID — The associated Oracle Inventory organization. This forms the second unique index (IC_WHSE_MST_U1), making it a strong business-key candidate that links the OPM warehouse to the discrete EBS inventory organization.
• WHSE_NAME, WHSE_CONTACT, WHSE_PHONE — Descriptive attributes identifying the warehouse for reporting and operational use.
• ORGN_CODE — The owning organization, with foreign keys to SY_ORGN_MST_B and SY_ORGN_MST.
• ADDR_ID — Foreign key to SY_ADDR_MST providing the warehouse address.
• LOCT_CTL — Indicates whether the warehouse is location-controlled, determining whether locator-level inventory is tracked.
• TAXLOC_CODE — Tax location code, referencing TX_TLOC_CDS.
• COST_ORGANIZATION_ID — The costing organization associated with the warehouse, relevant to cost rollups and costing warehouse assignment.
• WHSE_CLASS, REGION_CODE, CONSIGN_IND, NONNET_IND — Classification and behavioral flags governing consignment and non-nettable treatment.
• INGREDIENT_STAGE, PRODUCT_STAGE, RECV_STAGE, SHIP_STAGE — Stage indicators used in inventory and production flows.
• DISABLE_WAREHOUSE_IND, MIGRATED_IND, SUBINVENTORY_IND_FLAG, DELETE_MARK — Status and lifecycle flags controlling warehouse availability and migration state.
• ORGANIZATION_ID — Multi-organization identifier supporting the standard EBS organizational model.
• ATTRIBUTE1 through ATTRIBUTE30 and ATTRIBUTE_CATEGORY — The standard EBS descriptive flexfield columns for customer-defined extension data.

Common Use Cases and Queries

Typical scenarios include resolving a warehouse code to its name, organization, and costing organization for inventory reports; identifying the Oracle Inventory organization mapped to an OPM warehouse; and filtering out disabled or deleted warehouses from operational queries.

• Warehouse lookup and validation: SELECT WHSE_CODE, WHSE_NAME, ORGN_CODE, MTL_ORGANIZATION_ID FROM IC_WHSE_MST WHERE DELETE_MARK = 0 AND DISABLE_WAREHOUSE_IND = 'N';
• Mapping OPM warehouse to EBS inventory organization: join MTL_ORGANIZATION_ID to MTL_PARAMETERS.ORGANIZATION_ID to reconcile process and discrete inventory views.
• Inventory transaction reporting: join WHSE_CODE to IC_TRAN_CMP, IC_TRAN_PND, or IC_ADJS_JNL to report on warehouse-level activity.
• Costing analysis: join to CM_WHSE_ASC, CM_WHSE_EFF, or GL_ITEM_CST to examine warehouse cost associations and cost warehouse assignments.
• Cross-reference for purchasing and order management: join WHSE_CODE to the FROM_WHSE and TO_WHSE columns in PO_ORDR_HDR and OP_ORDR_HDR to trace shipping and receiving flows.

Related Objects

The foreign key graph for IC_WHSE_MST is extensive. The most significant related objects include:

• IC_ITEM_WHS — Item/warehouse inventory relationships, joined on WHSE_CODE.
• IC_LOCT_MST and IC_LOCT_INV — Locator master and locator inventory, both keyed by WHSE_CODE.
• IC_TRAN_CMP, IC_TRAN_PND, and IC_ADJS_JNL — Completed, pending, and adjustment inventory transactions.
• CM_WHSE_ASC and CM_WHSE_EFF — Warehouse cost association and effective costing warehouse definitions.
• GL_ITEM_CST, GL_ACCT_MAP, and GL_ACCU_MAP — Cost and account mapping tables referencing the warehouse.
• PO_ORDR_HDR and OP_ORDR_HDR — Purchasing and order management headers referencing FROM_WHSE and TO_WHSE.
• IC_XFER_MST — Transfer master, referencing both FROM_WAREHOUSE and TO_WAREHOUSE.
• SY_ADDR_MST, SY_ORGN_MST_B, and SY_ORGN_MST — Address and organization masters referenced by the table's own foreign keys.

Together, these relationships establish IC_WHSE_MST as a foundational reference table for OPM inventory and its adjacent costing, purchasing, order management, quality, and production modules.