Results for “program_application_id”

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

Overview

MTL_ABC_CLASSES_ALL_V is an Oracle E-Business Suite view owned by the APPS schema and registered under the INV (Inventory) product. The ETRM metadata describes the object simply as "10SC ONLY," a designation indicating that the view is intended specifically for the Oracle Inventory ABC classification feature associated with inventory analysis and cycle counting. In practice, the view exposes ABC class definitions — the groupings used to categorize inventory items by their relative value or turnover contribution — so that reports, concurrent programs, and integrations can retrieve this configuration through a stable, product-owned interface rather than querying the underlying synonym directly.

Because every column in the view is a straight projection of MTL_ABC_CLASSES with no filtering or join condition, the view serves primarily as a naming and access convention. It presents the master list of ABC classes, each tied to an organization, and carries the standard EBS "WHO" audit columns and concurrent manager request tracking columns expected of a transactional configuration object. Any consumer searching on abc_class_id will find that identifier exposed at the head of the select list.

Underlying Base Objects

The documented referenced base object is MTL_ABC_CLASSES, accessed through a synonym. The view definition performs a simple SELECT of thirteen named columns from that table with no WHERE clause, GROUP BY, or UNION, so the row set returned is identical to the base table's contents. All DML restrictions of the EBS foundation layer apply: MTAL_ABC_CLASSES is maintained through the Inventory ABC analysis setup and concurrent processes, and the view is a read-oriented presentation of that data.

ABC classes are organization-specific in EBS Inventory. The ORGANIZATION_ID column present in both the view and the base table confirms that class names are not globally unique across inventory organizations; they must be evaluated within an operating unit's inventory organization context.

Key Columns

• ABC_CLASS_ID — Primary identifier/surrogate key for each ABC class record. This is the column referenced when joining to item-level ABC compilation results or other Inventory tables.
• ABC_CLASS_NAME — User-defined name of the ABC class (for example, high-value or fast-moving designations).
• ORGANIZATION_ID — The inventory organization to which the class belongs; the key scoping column for any multi-organization query.
• DESCRIPTION — Free-text explanation of the class purpose.
• DISABLE_DATE — Date on which the class was inactivated, supporting effective-dating style filtering.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard EBS audit columns identifying who created and last changed the record.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program bookkeeping columns populated when the row is created or updated by a batch process.

Common Use Cases and Queries

Typical consumers retrieve ABC class definitions for a specific organization or resolve a class ID to its name for reporting. A standard lookup follows:

SELECT abc_class_id, abc_class_name, organization_id, description, disable_date
FROM apps.mtl_abc_classes_all_v
WHERE organization_id = :p_org_id
ORDER BY abc_class_name;

To resolve a known identifier to a display name and status, the query filters on the primary key:

SELECT abc_class_name, disable_date
FROM apps.mtl_abc_classes_all_v
WHERE abc_class_id = :p_abc_class_id;

Integration and conversion programs frequently join this view to item master or ABC compilation tables using abc_class_id alongside organization_id to ensure the organization context matches. Because the view carries no row-level security predicates in its documented text, developers should always apply organization or operating-unit filters in their own SQL to avoid cross-organization exposure. The DISABLE_DATE column should be tested when only active classes are required for a given report.