Results for “csc_prof_table_columns_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSC_PROF_TABLE_COLUMNS_VL is a Multi-Language Support (MLS) validation view owned by the APPS schema in the Oracle E-Business Suite Customer Care (CSC) product family. It presents translated metadata about the columns that constitute the configurable drilldown tables used in Customer Profile Setup. The view serves as the single language-aware access point for column definitions, exposing the descriptive label appropriate to the session language while retaining all the structural attributes needed by the application. It is documented as VALID and is consumed primarily by the Customer Profile Setup form on its Drilldown Details tabs, which is why the column metadata must be both structurally accurate and translatable. The "VL" suffix denotes a "view language" object, a standard EBS naming convention that combines a base ("_B") table holding language-independent attributes with a translation ("_TL") table holding the language-dependent attributes, joined on the primary key and filtered to the user's current language.

Underlying Base Objects

The view text joins two synonyms, both resolving to tables in the APPS schema:

• CSC_PROF_TABLE_COLUMNS_B — the base table containing language-independent data such as the surrogate key, structural identifiers, physical table and column names, sequence, drilldown flags, and standard WHO audit columns. This is aliased as B in the view definition.
• CSC_PROF_TABLE_COLUMNS_TL — the translation table supplying the translated LABEL for each column row. This is aliased as TL in the view definition.

The join is performed on B.TABLE_COLUMN_ID = TL.TABLE_COLUMN_ID, and the result is restricted by the predicate TL.LANGUAGE = USERENV('LANG'), which ensures only rows translated into the session's language are returned. The view therefore presents one row per table column per active language, with the base attributes carried through unchanged and the label supplied by the translation layer.

Key Columns

• ROW_ID — the ROWID of the base table row, exposed as a stable row identifier for the view.
• TABLE_COLUMN_ID — the surrogate primary key of the column definition, carried from the base table and used to join to the translation table.
• BLOCK_ID — identifier of the profile block to which the column belongs, establishing the grouping context for the drilldown display.
• TABLE_NAME — the physical database table referenced by the drilldown configuration.
• ALIAS_NAME — the alias assigned to the table reference, used when constructing drilldown queries. This column is commonly the subject of metadata searches, since it links a display configuration to a specific aliased data source.
• COLUMN_NAME — the physical column name within TABLE_NAME.
• COLUMN_SEQUENCE — the ordering of the column within its block, controlling presentation order in the form.
• DRILLDOWN_COLUMN_FLAG — indicates whether the column participates in the drilldown query.
• LABEL — the language-specific display label from the translation table, the only MLS-sensitive attribute surfaced.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER provide standard EBS auditability and optimistic locking support.

Common Use Cases and Queries

Typical usage includes verifying drilldown configuration for a profile block, resolving alias names to physical columns, and confirming that translations exist for a targeted language. Because the view filters on USERENV('LANG'), queries executed in different language sessions return different LABEL values for the same TABLE_COLUMN_ID.

List all configured columns for a block:

• SELECT table_column_id, table_name, alias_name, column_name, column_sequence, drilldown_column_flag, label FROM csc_prof_table_columns_vl WHERE block_id = :p_block_id ORDER BY column_sequence;

Locate a configuration by alias name:

• SELECT table_column_id, block_id, table_name, column_name, label FROM csc_prof_table_columns_vl WHERE alias_name = :p_alias_name;

Retrieve only drilldown-enabled columns:

• SELECT column_name, alias_name, label FROM csc_prof_table_columns_vl WHERE drilldown_column_flag = 'Y' AND block_id = :p_block_id;

Diagnosing missing translations: a row absent from this view for a known TABLE_COLUMN_ID generally indicates a missing or mismatched TL row for the current language rather than a structural defect in the base table.