Search Results set_created_by

Overview

CS_KB_SET_ELEMENTS_V is an APPS-owned database view in the Oracle E-Business Suite Service (CS) module. It exposes a denormalized, joined representation of knowledge base "sets" and the "elements" that belong to them, combining descriptive set-level attributes with the individual elements that compose each set. The view is defined over three documented base objects: the views CS_KB_SETS_V and CS_KB_ELEMENTS_V, and the synonym CS_KB_SET_ELES. It presents set identifiers, set type information, set-level descriptive and audit columns, and the element records associated with each set, together with set-element relationship attributes such as element order and association degree. Because it flattens the many-to-many relationship between sets and elements into a single result set, the view is well suited to reporting, data extraction, and integration scenarios where a consumer needs both the parent set context and its member elements in one query. As with most APPS views, it is intended for read access and should be treated as a reporting and integration surface rather than a transactional interface.

Underlying Base Objects

The documented referenced objects are CS_KB_ELEMENTS_V (VIEW), CS_KB_SETS_V (VIEW), and CS_KB_SET_ELES (SYNONYM). CS_KB_SETS_V supplies the set-level columns, including SET_ID, SET_TYPE_ID, SET_TYPE_NAME, status, name, description, the composite/positive/negative association indices, and the full set-level audit and descriptive flexfield attribute columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15). CS_KB_ELEMENTS_V supplies the element-level columns, including ELEMENT_ID, ELEMENT_TYPE_ID, ELEMENT_TYPE_NAME, element name and description, and the element audit columns. CS_KB_SET_ELES provides the association between a set and its elements, contributing relationship attributes such as ELEMENT_ORDER and ASSOC_DEGREE. In practice, CS_KB_SET_ELES is the intersection entity that links sets to elements; the view joins the set view to this association and then to the element view to produce one row per set-element pairing. This layered construction means the underlying knowledge base data must be consistent across all three sources for the joined output to be complete.

Key Columns

• SET_ID — Unique identifier of the knowledge base set, sourced from CS_KB_SETS_V.
• SET_TYPE_ID — The set type identifier; the column most directly associated with the search term "set_type_id" and a primary filter for classifying sets.
• SET_TYPE_NAME — Descriptive name of the set type, useful for display and grouping.
• ELEMENT_ID — Unique identifier of the element associated with the set.
• ELEMENT_TYPE_ID / ELEMENT_TYPE_NAME — Classification of the element.
• ELEMENT_ORDER — Ordinal position of the element within the set, from CS_KB_SET_ELES.
• ASSOC_DEGREE — The association degree defined for the set-element relationship.
• STATUS, NAME, DESCRIPTION (SET_ variants) — Set-level status and descriptive text.
• SET_COMPOSITE_ASSOC_INDEX, SET_POSITIVE_ASSOC_INDEX, SET_NEGATIVE_ASSOC_INDEX — Association indices controlling how set members combine under composite, positive, and negative logic.
• Audit columns — SET_CREATION_DATE, SET_CREATED_BY, SET_LAST_UPDATE_DATE, SET_LAST_UPDATED_BY, and their element-level counterparts.

Common Use Cases and Queries

Typical uses include generating catalogs of sets and their member elements, validating set composition, and feeding external systems with flattened set-element data. Because the view exposes SET_TYPE_ID directly, it is a convenient entry point when a user or report must locate sets by type. A representative query filtering on set type is:

• SELECT SET_ID, SET_TYPE_ID, SET_TYPE_NAME, SET_NAME, ELEMENT_ID, ELEMENT_NAME, ELEMENT_ORDER FROM APPS.CS_KB_SET_ELEMENTS_V WHERE SET_TYPE_ID = :p_set_type_id ORDER BY SET_ID, ELEMENT_ORDER;
• SELECT SET_ID, SET_NAME, COUNT(ELEMENT_ID) ELEMENT_COUNT FROM APPS.CS_KB_SET_ELEMENTS_V GROUP BY SET_ID, SET_NAME;
• SELECT SET_ID, SET_NAME, ELEMENT_ID, ELEMENT_NAME, ASSOC_DEGREE FROM APPS.CS_KB_SET_ELEMENTS_V WHERE ASSOC_DEGREE IS NOT NULL;

All queries should be executed with the APPS schema context or a suitable synonym, and results filtered by set type or status to keep result sets manageable.