Results for “as_interest_category_sets_v”

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

Overview

AS_INTEREST_CATEGORY_SETS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered under the AS – Sales Foundation product family. Its documented description is simply "Interest category sets view." The view presents the intersection of interest types and inventory category sets, exposing the configuration that determines which item categories are eligible for interest (late-charge) calculation logic in Oracle Order Management and related sales foundation flows. Because it is a view rather than a table, it holds no data of its own; it is a read-only, denormalized projection whose purpose is to make interest-to-category-set assignments available to reports, concurrent programs, and integration extract queries without requiring the caller to write the multi-table join manually. The object carries a VALID status in the ETRM 12.2.2 metadata and uses standard APPS ownership conventions, meaning it must be referenced through the APPS schema or a synonym granted for that purpose.

Underlying Base Objects

The view is defined over three referenced objects, each of which is itself a view:

• AS_INTEREST_CATEGORY_SETS — the driving object, supplying the interest type identifier, category set identifier, enabled flag, and standard WHO audit columns.
• MTL_CATEGORY_SETS_VL — the inventory category set view-language object, supplying CATEGORY_SET_NAME and DESCRIPTION.
• AS_INTEREST_TYPES_VL — the interest type view-language object, supplying the translatable INTEREST_TYPE value.

Joins are performed on INTCAT.CATEGORY_SET_ID = MTLSET.CATEGORY_SET_ID and INTCAT.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID. Because two of the three sources are _VL views, the descriptive text returned (interest type name and category set name) is language-sensitive and respects the session language of the calling user.

Key Columns

• ROW_ID — the row identifier of the underlying AS_INTEREST_CATEGORY_SETS record.
• CATEGORY_SET_ID — the inventory category set identifier linking the interest type to a specific set of categories.
• INTEREST_TYPE_ID — the numeric key of the interest type the category set is associated with.
• INTEREST_TYPE — the translatable display name of the interest type.
• CATEGORY_SET_NAME — the translatable name of the category set.
• DESCRIPTION — the descriptive text associated with the category set.
• ENABLED_FLAG — indicates whether the interest type / category set association is active.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard WHO tracking of the seeded configuration rows.

Common Use Cases and Queries

The view is typically queried to audit which category sets are wired to which interest type, to drive interest calculation seeding, and to join back to item category assignments. A representative query filters on the enabled flag:

• SELECT interest_type, category_set_name, enabled_flag FROM apps.as_interest_category_sets_v WHERE enabled_flag = 'Y' ORDER BY interest_type;
• SELECT category_set_name, interest_type FROM apps.as_interest_category_sets_v WHERE category_set_id = :p_category_set_id;

Users hunting for the object via the term mtl_category_sets_vl should note that MTL_CATEGORY_SETS_VL is not exposed directly by this view as a column source, but supplies CATEGORY_SET_NAME and DESCRIPTION. To resolve a category set name to its interest configuration, query this view rather than the inventory view, since the interest association exists only in the AS product tables. All references should be schema-qualified as APPS.AS_INTEREST_CATEGORY_SETS_V.