Results for “invbv_abc_assignment_groups”

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

Overview

The INVBV_ABC_ASSIGNMENT_GROUPS view is a read-only reporting object owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Inventory (INV) product family and is classified as a retrofitted view, meaning it was introduced or re-implemented to expose ABC assignment group data for external consumption without granting direct access to the underlying transaction table. ABC (Activity-Based Classification) assignment groups drive cycle count scheduling by grouping items according to their classification (A, B, or C) so that high-value or high-velocity items are counted more frequently than low-value stock. The view presents the assignment group header together with organization context, compilation reference, and optional subinventory restriction. Because it is defined WITH READ ONLY, it cannot be used to insert or update assignment group definitions; all maintenance must be performed through the originating Inventory forms or APIs. The view is commonly referenced when users search on the column abc_assignment_group_name, which is the business-facing identifier for a compilation scope. Report writers, integrations, and concurrent programs query it to translate an internal ASSIGNMENT_GROUP_ID into a meaningful name or to enumerate the ABC scopes defined for a given operating unit or inventory organization.

Underlying Base Objects

The view is defined over a single documented base object, the synonym MTL_ABC_ASSIGNMENT_GROUPS, which resolves to the base table of the same name in the APPS schema. The view projects a subset of columns from that table and augments them with descriptive flexfield and value-set metadata used by the Oracle Forms layer. Two of the projected expressions are special: one carries the item scope type lookup mapping against the MTL_ABC_ITEM_SCOPE lookup type in MFG_LOOKUPS, and the other applies a security predicate on ORGANIZATION_ID (rendered in the metadata as a value-set construct). The read-only clause enforces that the view is a query vehicle only. No joins to MTL_SYSTEM_ITEMS, MTL_SECONDARY_INVENTORIES, or MTL_ABC_COMPILES are embedded in the view text, so any enrichment with item or compilation details must be added by the calling query.

Key Columns

• ABC_ASSIGNMENT_GROUP_ID – Primary key of the assignment group; the value stored on compilation records.
• ABC_ASSIGNMENT_GROUP_NAME – The user-defined name of the assignment group, and the column most frequently used as a search or display attribute.
• ORGANIZATION_ID – Inventory organization that owns the assignment group; also the column subject to the view's security predicate.
• ABC_COMPILE_ID – Reference to the ABC compilation that consumed the group definition.
• SUBINVENTORY_NAME – Optional subinventory scope; null when the group applies to all subinventories in the organization.
• "_LA:VALUATION_SCOPE" – Descriptive flexfield / lookup-derived attribute indicating the item scope type (for example, all items versus a compiled subset).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE – Standard WHO audit columns tracking record authorship and change history.

Common Use Cases and Queries

The most common requirement is resolving a group name to its organization, or listing all groups for an organization prior to invoking an ABC compilation. A typical lookup by name is:

• SELECT abc_assignment_group_id, abc_assignment_group_name, organization_id, subinventory_name FROM apps.invbv_abc_assignment_groups WHERE UPPER(abc_assignment_group_name) LIKE UPPER(:p_name)||'%';
• SELECT abc_assignment_group_name, abc_compile_id FROM apps.invbv_abc_assignment_groups WHERE organization_id = :p_org_id ORDER BY abc_assignment_group_name;
• SELECT g.abc_assignment_group_name, c.compile_name FROM apps.invbv_abc_assignment_groups g, apps.mtl_abc_compiles c WHERE g.abc_compile_id = c.compile_id;

Additional scenarios include populating LOVs in custom concurrent programs, validating inbound interface data before calling the ABC compilation APIs, and auditing assignment group definitions across organizations during a merger or data migration. Because the view is read-only and unfiltered beyond the organization security predicate, callers should always constrain ORGANIZATION_ID and expected group names to avoid full-table scans on large MTL_ABC_ASSIGNMENT_GROUPS populations.