Results for “element_order”

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

Overview

CSD_KB_LINKS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It is a component of the CSD (Depot Repair) product family and its documented purpose is to retrieve all solutions from the Knowledge Base, exposing the relationships between Knowledge Base elements and the repair transactions to which they are linked. In EBS 12.1.1 and 12.2.2 the object carries a VALID status, confirming that it is a supported, compiled artifact of the Depot Repair data model rather than a custom or legacy object.

Within Oracle EBS reporting and integration, the view acts as a denormalized projection layer. Rather than requiring report authors or interface developers to join the individual Knowledge Base tables themselves, CSD_KB_LINKS_V presents element names, set names, element types, ordering, and cross-references in a single row set. Because its defining query restricts rows to OBJECT_CODE = 'DR', the view is scoped specifically to Depot Repair references rather than to general Knowledge Base content.

Underlying Base Objects

The view is defined over seven documented base objects:

• CS_KB_SETS_VL (VIEW) — Knowledge Base solution sets, providing SET_NAME and SET_ID.
• CS_KB_SET_LINKS (SYNONYM) — the association between a solution set and the object it supports, providing REPAIR_LINE_ID from OTHER_ID.
• CS_KB_SET_ELES (SYNONYM) — the set-to-element membership with ELEMENT_ORDER and ASSOC_DEGREE.
• CS_KB_ELEMENTS_VL (VIEW) — the individual Knowledge Base elements supplying ELEMENT_NAME and ELEMENT_ID.
• CS_KB_ELEMENT_TYPES_VL (VIEW) — element type definitions supplying ELEMENT_TYPE and ELEMENT_TYPE_ID.
• CS_KB_SET_TYPES_VL (VIEW) — set type definitions supplying SET_TYPE and SET_TYPE_ID.
• CS_KB_ELEMENT_LINKS (SYNONYM) — direct element-to-object links used by the second branch of the view.

An important structural detail is that the view text is a UNION of two queries. The first branch returns fully populated set-level rows joined through CS_KB_SET_LINKS. The second branch returns element-level rows from CS_KB_ELEMENT_LINKS where no set context exists; in that branch the set columns are intentionally returned as NULL (cast via TO_NUMBER(NULL) where a numeric datatype is required). Consumers must therefore tolerate null set attributes and identify the row source by the presence or absence of SET_ID.

Key Columns

• ELEMENT_ID — the surrogate key of the Knowledge Base element. This is the column most commonly used in joins to element-level detail tables.
• ELEMENT_NAME — the user-facing name of the element.
• ELEMENT_TYPE, ELEMENT_TYPE_ID — the classification of the element.
• SET_TYPE, SET_TYPE_ID, SET_NAME, SET_ID — the solution set hierarchy, null for element-only rows.
• ELEMENT_ORDER — the display sequence of the element within its set.
• NOT_TRUE — the alias applied to ASSOC_DEGREE.
• REPAIR_LINE_ID — the Depot Repair line identifier sourced from OTHER_ID, linking the knowledge entry to the repair transaction.

Common Use Cases and Queries

Typical use cases include Depot Repair knowledge retrieval, solution-lookup reports, and integration extracts that must know which elements a repair line references.

SELECT element_id, element_name, element_type,
       set_name, repair_line_id
FROM   apps.csd_kb_links_v
WHERE  repair_line_id = :p_repair_line_id;

To locate all repair lines using a specific element:

SELECT repair_line_id
FROM   apps.csd_kb_links_v
WHERE  element_id = :p_element_id
AND    set_id IS NOT NULL;

Because the view is not indexed itself, filtering on ELEMENT_ID or REPAIR_LINE_ID and joining back to base tables is preferable to restricting on view-level scalar functions.