Search Results identifier_type_desc

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.