Search Results okc_std_art_classings_v




Overview
Explore in AI Chat

Overview

OKC_STD_ART_CLASSINGS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKC – Contracts Core product. The view is documented as a wrapper over the base table OKC_STD_ART_CLASSINGS, which stores standard article classifications used within Oracle Contracts. The view is marked VALID in the ETRM metadata for 12.2.2 and is available in both 12.1.1 and 12.2.2 environments.

The structure and purpose of the view are consistent across both releases: it exposes the column set of the underlying classification table, including surrogate identifiers, versioning columns, business classification codes, and standard WHO audit columns. Because the view does not alter or filter the base data, it functions as a stable, read-only access point that insulates consumers from physical table changes and supports external reporting, integrations, and form-based lookups that rely on article classification data.

Underlying Base Objects

The view is defined over a single referenced object: OKC_STD_ART_CLASSINGS, documented in ETRM as a SYNONYM within the OKC – Contracts Core module. The view SELECT statement aliases the base object as SACB and projects each column directly, with the addition of a ROWID-based ROW_ID column that provides a physical row identifier for the classification record.

This one-to-one mapping means no joins, unions, or filter predicates are applied inside the view definition. Every row in OKC_STD_ART_CLASSINGS appears in OKC_STD_ART_CLASSINGS_V, and the row counts and cardinality are identical. The ROW_ID column is derived from the base table's ROWID, so it is a pseudo-column value tied to the physical storage of the underlying row and should not be treated as a durable key across reorganizations or exports.

The view should not be confused with the classification mapping structures used in contract terms and standard articles; it specifically targets the standard article classification setup table and is intended for query and integration purposes rather than direct transactional maintenance, which is typically performed through the Oracle Contracts application forms.

Key Columns

  • ROW_ID – The ROWID of the underlying OKC_STD_ART_CLASSINGS row, exposed as a means of uniquely identifying a physical record within a session or query.
  • ID – The primary surrogate identifier for the standard article classification record.
  • OBJECT_VERSION_NUMBER – The optimistic locking version number used by Oracle Applications to detect concurrent updates. Consumers performing updates through APIs must pass the current value.
  • SAT_CODE – The standard article type code, identifying the category of standard article associated with the classification.
  • PRICE_TYPE – The price type classification applied to the standard article, indicating how the article is priced.
  • SCS_CODE – The standard classification code associated with the article, governing which pricing or contract terms categories apply.
  • CREATED_BY, CREATION_DATE – Standard WHO audit columns recording the user and timestamp of record creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – WHO audit columns recording the most recent modification user, timestamp, and login session.

Common Use Cases and Queries

The view is typically used for reporting on standard article classifications, validating configuration during contract setup, and extracting classification data into external systems. A basic query retrieving all classifications with audit information is shown below.

SELECT c.id,
       c.sat_code,
       c.price_type,
       c.scs_code,
       c.last_updated_by,
       c.last_update_date
  FROM okc_std_art_classings_v c;

To restrict results to a specific standard article type and price type, add predicates on SAT_CODE and PRICE_TYPE. This pattern supports validation queries that confirm which standard classification codes are available for a given article type before contract creation.

SELECT c.id, c.sat_code, c.price_type, c.scs_code
  FROM okc_std_art_classings_v c
 WHERE c.sat_code   = :p_sat_code
   AND c.price_type = :p_price_type;

For incremental integrations, filter on LAST_UPDATE_DATE to retrieve records changed since the previous extraction run, using OBJECT_VERSION_NUMBER and ID as correlation keys.

SELECT c.id, c.object_version_number, c.sat_code, c.scs_code
  FROM okc_std_art_classings_v c
 WHERE c.last_update_date >= :p_since_date;

These queries reflect the documented column set and confirm that OKC_STD_ART_CLASSINGS_V is a straightforward, read-only projection suitable for reporting and extract-transform-load operations against Oracle Contracts Core.