Results for “directory_node_id”

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

Overview

IBC_CITEM_LABELS_V is a reporting and integration view in the Oracle E-Business Suite Content Manager module (product code IBC). It is owned by the APPS schema and holds VALID status in both EBS 12.1.1 and 12.2.2. The view consolidates content item master data, version-level attributes, content type translations, and label assignments into a single denormalized projection. Its principal role is to expose the relationship between content items, their versions, and the labels applied to those versions, together with language-specific names and descriptions.

Because the view joins multilingual (TL) tables, it returns one row per label-code, content-item, and content-version and language combination. This makes it suitable for concurrent program output, discoverer reports, and interface extracts that must resolve both technical content item identifiers and user-facing labels in the session or stored language. The prompt that surfaced the object via the search term locked_by_user_id indicates a frequent need to identify content items currently checked out or locked by a specific user — for example, when auditing stale locks, troubleshooting publishing failures, or building administrative dashboards. The LOCKED_BY_USER_ID column, inherited from IBC_CONTENT_ITEMS, satisfies that requirement directly.

Underlying Base Objects

The view text confirms it is defined over five documented base objects, all accessed through APPS synonyms:

• IBC_CONTENT_ITEMS — the content item header, supplying status, ownership, directory, version pointer, and lock information.
• IBC_CITEM_VERSIONS_B — the base (non-translated) content item version rows, providing version number, version status, and effective dates.
• IBC_CITEM_VERSIONS_TL — the translated version rows, supplying content item name, description, source language, and attachment references.
• IBC_CITEM_VERSION_LABELS — the association between versions and label codes.
• IBC_CONTENT_TYPES_TL — the translated content type name, joined on content type code and language.

Joins are performed on CONTENT_ITEM_ID and CITEM_VERSION_ID, with a language-equality predicate linking CVTL.LANGUAGE to CTTL.LANGUAGE. This inner-join structure means a row is only returned when a matching label, version, and content type translation all exist.

Key Columns

• LABEL_CODE — the label assigned to the content version through IBC_CITEM_VERSION_LABELS.
• CONTENT_ITEM_ID / CITEM_VERSION_ID — the primary identifiers for the item and its version.
• CONTENT_ITEM_STATUS / CITEM_VERSION_STATUS — lifecycle states at item and version level.
• CONTENT_TYPE_CODE / CONTENT_TYPE_NAME — the type identifier and its translated display name.
• LOCKED_BY_USER_ID — the user currently holding the item lock; the central column for lock-holder investigations.
• LIVE_CITEM_VERSION_ID — pointer from the item to its currently published (live) version.
• VERSION_NUMBER — sequential version identity within the item.
• CONTENT_ITEM_NAME / DESCRIPTION / LANGUAGE / SOURCE_LANG — translated descriptive attributes.
• WD_RESTRICTED_FLAG, TRANSLATION_REQUIRED_FLAG, BASE_LANGUAGE — web-directory restriction and translation workflow flags.
• START_DATE / END_DATE — version effective dating.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID) from both the item and version entities.

Common Use Cases and Queries

A typical lock audit identifies which content items a named user has checked out:

SELECT content_item_id, content_item_name, version_number,
       label_code, locked_by_user_id, last_update_date
  FROM apps.ibc_citem_labels_v
 WHERE locked_by_user_id = :user_id;

Listing all currently locked items, regardless of holder, supports stale-lock cleanup:

SELECT content_item_id, content_item_name, locked_by_user_id,
       citem_version_status, creation_date
  FROM apps.ibc_citem_labels_v
 WHERE locked_by_user_id IS NOT NULL
 ORDER BY last_update_date;

Label inventory by language aids translation and publishing reviews:

SELECT label_code, content_type_name, language, COUNT(*)
  FROM apps.ibc_citem_labels_v
 WHERE translation_required_flag = 'Y'
 GROUP BY label_code, content_type_name, language;

Because the view performs the joins and language resolution internally, these queries avoid the complexity of assembling the same result from the five base objects, making IBC_CITEM_LABELS_V the preferred access path for content item label, lock, and version reporting in Oracle EBS.