Search Results msd_cs_allocation_type




Overview
Explore in AI Chat

Overview

APPS.MSD_CS_DEFN_COLUMN_DTLS_V is a reporting and integration view within the Oracle EBS Advanced Planning / Demand Planning schema (MSD), which supports the Collaborative Planning and constraint-based supply chain planning functionality. The view exposes column-level definition details for planning definitions configured in MSD_CS_DEFINITIONS, along with decoded lookup meanings and identifier metadata. It serves as a denormalized, read-friendly façade over the underlying MSD_CS_DEFN_COLUMN_DTLS synonym, joining definition headers, column identifier descriptions, and two FND lookup overlays to present human-readable aggregation and allocation semantics. It is commonly consumed by concurrent programs, BI Publisher reports, Discoverer workbooks, and custom extensions that need to enumerate the columns belonging to a given planning definition, together with their source/planning view column names and behavior attributes.

Underlying Base Objects

The view is defined in the APPS schema and references the following documented base objects:

The view text confirms two outer-joined lookups and two inner joins, so a definition column row is returned only when its identifier and parent definition exist, while aggregation/allocation meanings degrade to NULL when no lookup code is present.

Key Columns

Note that the two MEANING columns share the same alias in the raw text; consumers referencing them should use positional aliasing or wrap the view to disambiguate.

Common Use Cases and Queries

Typical uses include auditing column definitions for a planning definition, verifying allocation/aggregation configuration, and driving downstream mapping logic. A representative query filtering on the allocation lookup, matching the user's search term, is:

  • Enumerate all columns and decoded semantics for a definition: SELECT name, source_view_column_name, planning_view_column_name, aggregation_type, allocation_type FROM apps.msd_cs_defn_column_dtls_v WHERE cs_definition_id = :p_def_id;
  • Find columns using a specific allocation meaning: SELECT name, column_identifier, allocation_type FROM apps.msd_cs_defn_column_dtls_v WHERE allocation_type IN (SELECT lookup_code FROM fnd_lookup_values_vl WHERE lookup_type = 'MSD_CS_ALLOCATION_TYPE' AND meaning = :p_meaning);
  • Reconcile identifier prompts against mappings: SELECT column_identifier, user_prompt, identifier_type, uom_conversion_flag FROM apps.msd_cs_defn_column_dtls_v ORDER BY name, column_identifier;

Because lookups are outer-joined, reports should coalesce lookup meanings to avoid NULL display when aggregation or allocation type is unset.