Results for “op_prce_mst”

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

Overview

OP_PRCE_MST is the price list header table for Oracle Process Manufacturing Logistics (GML). It stores the master definition of each price list used in process manufacturing, serving as the parent record to which individual price list lines, effective-dated price entries, and item-level pricing rules are attached. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the GML schema and is documented as VALID. The header record establishes the identity, descriptive text, currency context, and global attributes that govern how pricing is applied across a given list.

Under a heuristic Data Vault classification mined from the foreign-key structure, OP_PRCE_MST is satellite-leaning, because it carries descriptive and contextual attributes around the natural business key PRICELIST_CODE rather than acting as a pure hub of unrelated entities. This classification is offered as a modeling suggestion only; the table itself is a conventional transactional master table with no Data Vault artifacts.

Key Information Stored

The table contains 45 documented columns. The most significant are:

• PRICELIST_ID — surrogate primary key (OP_PRCE_MST_PK), the internal identifier referenced by all child tables.
• PRICELIST_CODE — the human-readable unique business key (OP_PRCE_MST_UK); the value users and integrations supply when referencing a list.
• PRICELIST_DESC1 — primary descriptive name of the price list.
• PRICESORT_NAME — the sort or sequence name controlling ordering behavior for the list.
• CURRENCY_CODE — foreign key to GL_CURR_MST, defining the currency in which prices are expressed.
• TEXT_CODE — foreign key to OP_TEXT_HDR, linking the header to its associated text block.
• COMMENTS — free-form remarks on the price list.
• IN_USE and DELETE_MARK — status flags controlling active use and logical deletion.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the standard EBS descriptive flexfield (DFF) columns used for customer-specific extensions.

The distinction between PRICELIST_ID and PRICELIST_CODE matters operationally: the surrogate key is stable and used in joins, while the business key is what appears on interfaces and reports.

Common Use Cases and Queries

Typical scenarios include retrieving the header attributes for a price list by its code, listing all active price lists in a given currency, and joining the header to its lines or effective-dated entries for pricing reports.

• Lookup by business key: SELECT PRICELIST_ID, PRICELIST_DESC1, CURRENCY_CODE FROM OP_PRCE_MST WHERE PRICELIST_CODE = :code;
• Active price lists: SELECT PRICELIST_CODE, PRICELIST_DESC1 FROM OP_PRCE_MST WHERE IN_USE = 'Y' AND DELETE_MARK = 0;
• Effective-dated pricing: join OP_PRCE_MST to OP_PRCE_EFF on PRICELIST_ID to retrieve date-ranged prices for a list.
• Line-level detail: join OP_PRCE_MST to OP_PRCE_ITM on PRICELIST_ID to report item pricing under each list.
• Currency reporting: join to GL_CURR_MST on CURRENCY_CODE to resolve currency descriptions.

Reports frequently filter on DELETE_MARK and IN_USE to exclude retired or draft lists, and resolve DFF ATTRIBUTE columns when client-specific classifications are configured.

Related Objects

OP_PRCE_MST is a parent header with several dependent tables and consumers:

• OP_PRCE_EFF — references PRICELIST_ID; holds effective-dated price entries.
• OP_PRCE_ITM — references PRICELIST_ID; holds item-level price lines.
• ICX_POR_CONTRACT_REFERENCES — references PRICELIST_ID, tying procurement contracts to price lists.
• FTE_LANES — references PRICELIST_ID for transportation lane pricing.
• MTL_INTERORG_PARAMETERS — references PRICELIST_ID for inter-organization transfer pricing.
• ICX_POR_UPLOAD_IT_DUMP — references PRICELIST_ID during procurement upload processing.
• GL_CURR_MST — parent of CURRENCY_CODE.
• OP_TEXT_HDR — parent of TEXT_CODE.

These relationships establish OP_PRCE_MST as a central reference point for pricing across process manufacturing, procurement, and inventory transfer functions.