Search Results msd_cs_defn_column_dtls_v




Overview
Explore in AI Chat

Overview

The MSD_CS_DEFN_COLUMN_DTLS_V view is an Oracle E-Business Suite database object owned by the APPS schema and associated with the MSD (Demand Planning) product family. It provides Data Stream definition column details, exposing the configuration metadata that describes how columns within a Demand Planning data stream are defined, mapped, and presented. In the ETRM 12.1.1 and 12.2.2 reference metadata, the object is documented as VALID and its stated purpose is to supply "Data Stream's Column Details."

The view serves a reporting and integration role: it flattens the relationship between a data stream definition, the underlying source and planning view columns, the column identifier master data, and the decoded lookup meanings for aggregation and allocation types. Implementers and technical analysts frequently query it when troubleshooting data stream configuration, validating column mappings, or documenting integration interfaces that consume Demand Planning data stream metadata. The user search term column_identifier_desc corresponds directly to the COLUMN_IDENTIFIER_DESC column exposed by this view, which resolves the human-readable description of a column identifier.

Underlying Base Objects

According to the documented view text, MSD_CS_DEFN_COLUMN_DTLS_V is defined over four referenced objects, joined through a series of equi-joins and outer joins:

The outer joins (denoted by (+)) ensure that column detail rows are returned even when no matching lookup value exists for aggregation or allocation type.

Key Columns

Common Use Cases and Queries

Typical uses include auditing data stream column configuration, generating mapping documentation, and diagnosing aggregation/allocation behaviour.

  • List all columns for a given data stream definition with their descriptions and decoded aggregation type.
SELECT definition_name, column_identifier, column_identifier_desc,
       source_view_column_name, planning_view_column_name,
       aggregation_type_desc, allocation_type_desc
FROM   apps.msd_cs_defn_column_dtls_v
WHERE  definition_name = :p_definition_name
ORDER BY column_identifier;
  • Search for a specific column identifier description across all definitions.
SELECT cs_definition_id, definition_name, column_identifier,
       column_identifier_desc, identifier_type, user_prompt
FROM   apps.msd_cs_defn_column_dtls_v
WHERE  UPPER(column_identifier_desc) LIKE UPPER('%' || :p_search || '%');

Because the view performs the lookup decoding internally, querying it directly avoids the need to reproduce the joins against FND_LOOKUP_VALUES_VL and MSD_CS_CLMN_IDENTIFIERS_VL, simplifying both ad hoc reporting and integration extraction logic.