Search Results altcust_no




Overview
Explore in AI Chat

Overview

OP_CUST_MST_OPM is the customer master table within the Oracle Process Manufacturing Logistics (GML) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Owned by the GML schema and marked VALID, it is the foundational repository for customer records used throughout process manufacturing order-to-cash flows, including sales order entry, shipping, pricing, credit, commissions, and financial posting.

Each row represents a single customer entity, identified internally by a surrogate key and externally by a company-scoped customer number. The table is heavily referenced by downstream transactional tables that capture orders, invoices, shipments, and receivables, making it one of the central master data objects in the Process Manufacturing suite.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests this object behaves as a link table. The table's numerous foreign keys to classification, address, currency, terms, and sales representative reference tables indicate it functions as a join point that ties independent master data domains together into a single customer profile. Analysts building dimensional or Data Vault models should treat OP_CUST_MST_OPM as a hub-like entity with substantial link-style relationships to supporting reference hubs.

Key Information Stored

The table contains 95 documented columns. The most business-critical include the following.

Common Use Cases and Queries

Typical reporting and integration scenarios retrieve customer profile data for order entry, credit review, and AR reconciliation. A frequent query joins the customer to its address and terms:

  • Lookup by business key: SELECT cust_id, cust_name FROM gml.op_cust_mst_opm WHERE co_code = :co AND cust_no = :no
  • Credit exposure review: filter by credit_limit and join to open receivable balances.
  • Customer listing by class: join cust_class to OP_CUST_CLS to group customers by sales or pricing category.
  • Currency and terms reporting: join cust_currency to GL_CURR_MST and terms_code to OP_TERM_MST.
  • Address validation: join addr_id to SY_ADDR_MST for full mailing details.
  • Active customer extracts: WHERE inactive_ind = 'N' AND delete_mark = 0 for downstream data feeds.
  • Commission assignment: join commission_code to OP_COMMISSION for sales reporting.

Related Objects

The table participates in a dense web of relationships, all enforced by documented foreign keys with the GML schema.

  • SY_ADDR_MST — joined on ADDR_ID and MAILADDR_ID for mailing and physical addresses.
  • SY_ORGN_MST_B — joined on CO_CODE, defining the owning organization/company.
  • GL_CURR_MST — joined on CUST_CURRENCY for currency conversion and reporting.
  • OP_TERM_MST — joined on TERMS_CODE for payment terms.
  • OP_SLSR_MST and OP_COMMISSION — joined on SLSREP_CODE and COMMISSION_CODE for sales and commission logic.
  • OP_CUST_CLS, OP_CGLD_CLS, OP_CPRC_CLS, and OP_CTRD_CLS — classification references for customer, GL, pricing, and trade classes.
  • IC_WHSE_MST — joined on FROM_WHSE and TO_WHSE for default shipping warehouses.
  • OP_FOBC_MST, OP_FRGT_MTH, and OP_LKBX_MST — freight and lockbox references.
  • TX_CALC_MST and TX_TLOC_CDS — tax calculation and location references.
  • OP_TEXT_HDR — joined on TEXT_CODE for attached descriptive text.