Search Results msd_cs_stream_source_type




Overview
Explore in AI Chat

Overview

APPS.MSD_CS_DEFINITIONS_VL is a bilingual (VL) view in the Oracle E-Business Suite ETRM (Enterprise Territory and Resource Management / Advanced Planning) schema. It presents the master definition of "CS" (Constraint Stream or Collection Stream) definitions, combining a base definition table with its translation table and joining two Oracle Application Object Library lookup views to resolve coded values into user-facing meanings. The view exposes descriptive, behavioral, and technical attributes for each CS definition, including classification, stream source type, measurement type, planning server view names, and collection program configuration.

In Oracle EBS 12.1.1 and 12.2.2, this view serves as the reporting and integration interface for constraint/collection stream metadata. Rather than querying the underlying base table directly, developers and report authors use MSD_CS_DEFINITIONS_VL to obtain translated descriptions and decoded lookup meanings in a single query, which is essential for multilingual deployments.

Underlying Base Objects

The documented underlying objects referenced by this view are:

  • MSD_CS_DEFINITIONS (SYNONYM) — the base table holding the primary CS definition records and technical attributes.
  • MSD_CS_DEFINITIONS_TL (SYNONYM) — the translation table supplying language-specific descriptions, joined on CS_DEFINITION_ID and restricted to USERENV('LANG').
  • FND_LOOKUP_VALUES_VL (VIEW) — referenced twice (aliases LOK1 and LOK2) via outer joins to decode lookup codes into meanings.

The join between MSD_CS_DEFINITIONS and MSD_CS_DEFINITIONS_TL is an inner join keyed on CS_DEFINITION_ID. Two outer joins to FND_LOOKUP_VALUES_VL resolve CS_TYPE against lookup type 'MSD_CS_STREAM_SOURCE_TYPE' (LOK1) and MEASUREMENT_TYPE against lookup type 'MSD_CS_MEASUREMENT_TYPE' (LOK2).

Key Columns

Common Use Cases and Queries

This view is typically used to enumerate available CS/constraint definitions, filter by measurement type, and present decoded meanings for user reports or integration extracts. Because the user searched for "msd_cs_measurement_type," the measurement type column and its lookup decoding are of particular interest.

  • Listing all enabled definitions with their measurement type meaning.
  • Filtering definitions by classification or stream source type.
  • Identifying the collection program and source views associated with a definition.

Sample query:

SELECT cs_definition_id,
       name,
       description,
       measurement_type,
       lok2_meaning AS measurement_type_meaning,
       cs_type,
       lok1_meaning AS stream_source_type,
       enable_flag,
       collection_program_name
  FROM apps.msd_cs_definitions_vl
 WHERE enable_flag = 'Y'
   AND measurement_type = '&p_measurement_type'
 ORDER BY name;

To retrieve only the distinct measurement types available:

SELECT DISTINCT measurement_type, lok2_meaning
  FROM apps.msd_cs_definitions_vl
 ORDER BY measurement_type;

These queries return translated descriptions and decoded lookup meanings, making the view suitable for both presentation-layer reporting and downstream integration processes requiring human-readable CS definition metadata.