Results for “okc_art_set_names_v”

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

Overview

OKC_ART_SET_NAMES_V is a backward-compatibility view in the Oracle E-Business Suite Contracts Core (OKC) module, owned by the APPS schema. It exposes contract folder (article set) definitions in a legacy column layout so that pre-existing reports, concurrent programs, and integrations written against earlier ETRM releases continue to function after the Folders data model was superseded by the current article and article set schema. In ETRM 12.1.1 and 12.2.2 the view is documented as VALID and is catalogued as a view created for backward compatibility based on Folders.

The view presents three columns — SAT_CODE, NAME and DESCRIPTION — where SAT_CODE is a character representation of the folder identifier and NAME is the folder name. This three-column shape mirrors the older "article set names" interface that older setups and extensions were built against. Because the view is read-only and carries no business logic beyond a simple join and type conversion, it is best regarded as a presentation and compatibility layer rather than a transactional object.

Underlying Base Objects

The documented definition of the view joins two base objects in the OKC schema, both referenced through APPS synonyms:

• OKC_FOLDERS_B — the base table holding folder (article set) header records, including the primary key FOLDER_ID.
• OKC_FOLDERS_ALL_TL — the translation table holding the language-dependent folder name and description, keyed by FOLDER_ID and LANGUAGE.

The join predicate is FOLD.FOLDER_ID = FOLDT.FOLDER_ID combined with FOLDT.LANGUAGE = USERENV('LANG'), which restricts the result set to the session's current language so that each folder appears once, translated into the operator's language. The FOLDER_ID is wrapped in TO_CHAR to produce the SAT_CODE column. No security predicate beyond language is applied inside the view itself, so row-level access is governed by the privileges granted on the underlying Folders objects.

Key Columns

• SAT_CODE — Character form of OKC_FOLDERS_B.FOLDER_ID. This is the legacy identifier used by older programs to reference an article set; treat it as a string, not a number, when comparing or joining.
• NAME — The folder name from OKC_FOLDERS_ALL_TL.FOLDER_NAME, returned in the session language. This is the human-readable label for the article set.
• DESCRIPTION — The folder description from OKC_FOLDERS_ALL_TL.DESCRIPTION, also language-dependent, providing the free-text explanation attached to the folder.

Common Use Cases and Queries

Typical uses include validating legacy references to article sets, listing folders for LOV-style pickers in custom concurrent programs, and reconciling custom tables that still store SAT_CODE values against the current Folders model. Because only three columns are returned, the view is unsuitable for reproducing full folder configuration such as the articles contained within a set; those details must be sourced from the current article set tables.

To list all visible article sets in the session language:

SELECT sat_code, name, description
FROM   apps.okc_art_set_names_v
ORDER  BY name;

To resolve a specific code held in a legacy custom table:

SELECT v.name, v.description
FROM   apps.okc_art_set_names_v v
WHERE  v.sat_code = :legacy_sat_code;

To locate a set by name fragment using the translated label:

SELECT sat_code, name
FROM   apps.okc_art_set_names_v
WHERE  UPPER(name) LIKE UPPER(:name_pattern);

When integrating, note that SAT_CODE is a TO_CHAR of a numeric identifier and that results depend on USERENV('LANG'); set the session language explicitly if deterministic output is required.