Search Results as_interest_codes_mc




Overview
Explore in AI Chat

Overview

The AS_INTEREST_CODES_MC table is a core data object within the Oracle E-Business Suite Sales Foundation module (AS). It functions as a multi-currency extension table, designed to store pricing information for product families in various currencies. Its primary role is to enable the recording and management of a specific price point (interest code) associated with a product family, with the flexibility to define that price in multiple currencies. This structure is essential for supporting global sales operations where pricing must be maintained and referenced in local currencies beyond the enterprise's primary currency. The table is owned by the OSM schema and is a validated component in both the 12.1.1 and 12.2.2 releases.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two critical columns. The INTEREST_CODE_ID column serves as the foreign key link to the base interest code definition in the AS_INTEREST_CODES_B table. The CURRENCY_CODE column specifies the three-character ISO currency code (e.g., USD, EUR, JPY) for which the associated price is valid. While the explicit price column is not listed in the provided metadata, the table's stated purpose is "for recording a price and currency for a product family," implying the presence of at least one numeric column to hold the price amount. This design allows a single product family interest code to have multiple corresponding rows in AS_INTEREST_CODES_MC, each representing the price in a different currency.

Common Use Cases and Queries

This table is central to multi-currency pricing lookups and configuration within the Sales Foundation. Common operational and reporting scenarios include retrieving all valid currency prices for a specific product family interest code, or determining the applicable price for a quote or order line based on the transaction currency. A typical query would join this table to its base table to get a complete view. For example:

  • Retrieve Multi-Currency Pricing: SELECT b.INTEREST_CODE_NAME, mc.CURRENCY_CODE, mc.PRICE_AMOUNT FROM AS_INTEREST_CODES_B b, AS_INTEREST_CODES_MC mc WHERE b.INTEREST_CODE_ID = mc.INTEREST_CODE_ID AND b.INTEREST_CODE_ID = :1;
  • Validate Currency for an Interest Code: SELECT 'Y' FROM AS_INTEREST_CODES_MC WHERE INTEREST_CODE_ID = :1 AND CURRENCY_CODE = :2;

These queries support pricing engines, configuration validation, and international sales reporting.

Related Objects

The AS_INTEREST_CODES_MC table has a direct and dependent relationship with the AS_INTEREST_CODES_B table, which holds the base definition of the interest code. The documented foreign key relationship is unidirectional: AS_INTEREST_CODES_MC.INTEREST_CODE_ID references AS_INTEREST_CODES_B. This indicates that AS_INTEREST_CODES_B is the parent table for the interest code entity, while AS_INTEREST_CODES_MC is a child table providing multi-currency details. The primary key constraint AS_INTEREST_CODES_MC_PK enforces uniqueness on the combination of CURRENCY_CODE and INTEREST_CODE_ID, ensuring that a price for a given currency is defined only once per interest code. This table is likely referenced by pricing APIs and views within the Sales Foundation module.