Search Results source_solution_id

Overview

CSD_RO_SOLNS_V is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Depot Repair (CSD) module. Its documented purpose is to display solutions that are linked to repair orders. In the ETRM repository for release 12.2.2 the object carries a VALID status, meaning it is a supported and queryable dictionary object in both the 12.1.1 and 12.2.2 code lines. The view is a reporting and integration aid rather than a transactional entity: it joins the knowledge-base solution registry to depot repair service-code activity so that a repair line can be presented together with the published solution associated with it. Because it exposes the foreign key repair_line_id — the term the user searched for — the view is frequently used to trace the relationship between a repair line and the knowledge management solution applied or recommended against it. No DML is performed against the view itself; consumers query it for listings, LOV-style lookups, and analytical extracts.

Underlying Base Objects

The view text is defined over two principal sources. The first is CS_KB_LINKED_SOLUTIONS_VIEW, aliased KB in the outer query, which supplies solution set information such as SET_ID, SET_NUMBER, SET_NAME, and the link type attributes, and which also provides the OTHER_ID column mapped to REPAIR_LINE_ID. The second is an inline derived table built from CSD_RO_SERVICE_CODES (exposed in ETRM as a synonym over the base depot repair table) joined again to CS_KB_LINKED_SOLUTIONS_VIEW, aliased CSD and KB1 respectively. This inner block determines the applied flag by matching repair line identifiers and source solution identifiers where the source type is SOLUTION. Documented base objects referenced by the view additionally include CS_KB_SECURITY_PVT, the knowledge-base security package that governs solution visibility, and FND_GLOBAL, the standard EBS context package used to resolve the effective user and application context during query execution. The join between the outer KB rowset and the inner applied-flag rowset is an outer join using the (+) operator on both REPAIR_LINE_ID and the solution identifier, ensuring solutions are returned even when no service-code application record exists.

Key Columns

• SET_ID — Identifier of the solution set in the knowledge base; joins to the underlying solution registry.
• SET_NUMBER — Human-readable solution number used in support and service desk references.
• SET_NAME — Descriptive name of the solution.
• SET_LINK_TYPE and SET_LINK_TYPE_MEANING — The coded and decoded values describing how the solution is linked, providing the descriptive text without a separate lookup join.
• REPAIR_LINE_ID — The depot repair line identifier, derived from OTHER_ID on the linked-solutions view. This is the column users search for when tracing solutions back to a specific repair order line.
• APPLIED_FLAG — A DECODE of the CSD applied flag returning 'Y' when applied and 'N' otherwise, indicating whether the solution has been applied to the estimate or work order.

Common Use Cases and Queries

The view is typically used to list published solutions tied to depot repair activity, to confirm whether a suggested solution was actually applied, and to join repair lines to the knowledge base for reporting. Because filtering is built into the definition, only rows with OBJECT_CODE 'DR' and a published status are returned.

SELECT repair_line_id,
       set_number,
       set_name,
       applied_flag
FROM   apps.csd_ro_solns_v
WHERE  repair_line_id = :p_repair_line_id;

A second common pattern retrieves all solutions that have been applied to estimate or work, using the applied flag as a filter, and a third joins the view to repair order headers through the repair line identifier for cross-module extracts. Any query should be executed with the APPS schema context so that CS_KB_SECURITY_PVT and FND_GLOBAL resolve correctly and knowledge-base security is honoured.