Results for “msd_cs_identifiers”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MSD_CS_CLMN_IDENTIFIERS_VL is a public Oracle EBS view owned by the APPS schema that exposes the set of Column Identifiers used by Oracle's Custom Stream (CS) framework within the MSD (Master Data / Demand Planning) product family. The "VL" suffix denotes a "view language" object, meaning the view internally joins a base table and its translation table so that descriptive text is returned in the session's language. The view is documented as valid with FND Design Data reference MSD.MSD_CS_CLMN_IDENTIFIERS_VL and is classified as a public view that "may be useful for custom reporting or other data requirements." It presents identifier metadata — identifier codes, descriptions, identifier types, localized descriptions, user prompts, and system-defined flags — so that reports, integrations, and dependent views can resolve column identifier semantics without querying the underlying base and translation tables directly. The view is a supporting definition object within the Custom Stream configuration model rather than a transactional one; it describes the columns that may be selected when building a custom stream or demand planning scenario.
Underlying Base Objects
Per the documented dependency information, MSD_CS_CLMN_IDENTIFIERS_VL resolves against the following objects:
- MSD_CS_CLMN_IDENTIFIERS (SYNONYM) — the base table holding the untranslated column identifier rows.
- MSD_CS_CLMN_IDENTIFIERS_TL (SYNONYM) — the translation table supplying language-specific descriptions and user prompts; the join between this table and the base table produces the "_VL" behavior.
- FND_LOOKUP_VALUES_VL (VIEW) — the Oracle Application Object Library lookup values view, used to derive IDENTIFIER_TYPE_DESC from the lookup type MSD_CS_IDENTIFIERS.
The view is itself referenced by other MSD objects, namely MSD_CS_DEFN_COLUMN_DTLS_V, MSD_DP_PARAMETERS_CS_V, and MSD_DP_SCENARIOS_VL, confirming its role as a foundational metadata source within the Custom Stream and Demand Planning definition chain.
Key Columns
- COLUMN_IDENTIFIER (VARCHAR2, 30) — the unique key identifying the column identifier.
- DESCRIPTION (VARCHAR2, 100) — the column name as presented to users.
- IDENTIFIER_TYPE (VARCHAR2, 30) — the identifier classification, validated against the FND lookup type MSD_CS_IDENTIFIERS.
- IDENTIFIER_TYPE_DESC (VARCHAR2, 80) — the translated, human-readable description of the identifier type. This is the column most often targeted when searching by "identifier_type_desc."
- USER_PROMPT (VARCHAR2, 80) — the prompt displayed to the user when the identifier is selected.
- SYSTEM_FLAG (VARCHAR2, 240) — indicates Oracle-defined column identifiers when set to 'Y'.
- The remaining columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) are the standard WHO audit columns.
Common Use Cases and Queries
Typical usage includes building custom reports of available column identifiers, filtering system versus user-defined identifiers, and resolving identifier type descriptions for dependent custom streams. A representative query is:
SELECT COLUMN_IDENTIFIER, DESCRIPTION, IDENTIFIER_TYPE, IDENTIFIER_TYPE_DESC, USER_PROMPT, SYSTEM_FLAG FROM APPS.MSD_CS_CLMN_IDENTIFIERS_VL WHERE SYSTEM_FLAG = 'Y' ORDER BY IDENTIFIER_TYPE_DESC, COLUMN_IDENTIFIER;
Because the view already resolves the lookup description, consumers should join to it rather than reproducing the FND_LOOKUP_VALUES logic, ensuring translations are applied consistently across reporting and integration layers.
-
Data Stream Column Types
-
Data Stream Column Types
-
This table has Column identifiers for Custom Data Stream.
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
This view for Custom Stream Column identifiers
APPS.MSD_CS_CLMN_IDENTIFIERS_VL·↳ FND_LOOKUP_VALUES_VL·↳ MSD_CS_CLMN_IDENTIFIERS·↳ MSD_CS_CLMN_IDENTIFIERS_TL·Explore MSD module →
-
This table has Column identifiers for Custom Data Stream.
-
This view for Custom Stream Column identifiers
APPS.MSD_CS_CLMN_IDENTIFIERS_VL·↳ FND_LOOKUP_VALUES_VL·↳ MSD_CS_CLMN_IDENTIFIERS·↳ MSD_CS_CLMN_IDENTIFIERS_TL·Explore MSD module →
-
eTRM - MSD Tables and Views 12.2.2
This is the fact table that stores the UOM conversions information.
-
eTRM - MSD Tables and Views 12.1.1
This is the fact table that stores the UOM conversions information.