Results for “ibc_content_items_v”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IBC_CONTENT_ITEMS_V view is a denormalized reporting and integration object in the Oracle E-Business Suite Content Manager module (product code IBC). Owned by the APPS schema, it consolidates content item header data with the corresponding content item version records and translated name/description attributes into a single queryable structure. In both EBS 12.1.1 and 12.2.2 it retains a VALID status, meaning it can be relied upon by custom reports, concurrent programs, and interface logic.
The view is particularly relevant when users search for citem_version_status, since that column is exposed on this view even though it physically resides on the version base table. This makes IBC_CONTENT_ITEMS_V a convenient single source for reporting the lifecycle state of a content item's versions without requiring manual joins between the item, version, and translation tables.
Underlying Base Objects
The view is defined over four documented base objects, all referenced as synonyms in the APPS schema:
- IBC_CONTENT_ITEMS — the master content item table supplying item-level identity, status, directory placement, locking, and language attributes.
- IBC_CITEM_VERSIONS_B — the content item version base table supplying
CITEM_VERSION_ID,VERSION_NUMBER, andCITEM_VERSION_STATUS. - IBC_CITEM_VERSIONS_TL — the translation table for versions, supplying
CONTENT_ITEM_NAME,DESCRIPTION, andLANGUAGE. - IBC_CONTENT_TYPES_TL — the translated content type table supplying
CONTENT_TYPE_NAME.
Joins connect content items to versions on CONTENT_ITEM_ID, versions to their translations on CITEM_VERSION_ID, and content type code/language pairs to the content type translation table. The result is one row per content item version/translation combination.
Key Columns
The view projects all columns from the item and version base tables plus translated names. Notable columns include:
CONTENT_ITEM_ID— primary identifier of the content item.CONTENT_ITEM_STATUS— status of the item header record.CITEM_VERSION_ID,VERSION_NUMBER,CITEM_VERSION_STATUS— version identity, sequence number, and the version lifecycle status (the field users most often search for).LIVE_CITEM_VERSION_ID— references the currently live version of the item.LOCKED_BY_USER_ID— user holding the item lock, if any.START_DATE,END_DATE— effective dating for the version.CONTENT_ITEM_NAME,DESCRIPTION,CONTENT_TYPE_NAME,LANGUAGE— translated descriptive attributes.- Standard WHO and audit columns (
CREATED_BY,CREATION_DATE,OBJECT_VERSION_NUMBER,SECURITY_GROUP_ID) for change tracking.
Common Use Cases and Queries
Typical uses include reporting content item version status, auditing which items are locked, and identifying live versus working versions. For example:
SELECT CONTENT_ITEM_ID, CITEM_VERSION_STATUS, VERSION_NUMBER FROM IBC_CONTENT_ITEMS_V WHERE CITEM_VERSION_STATUS = 'PUBLISHED';SELECT CONTENT_ITEM_NAME, CITEM_VERSION_STATUS FROM IBC_CONTENT_ITEMS_V WHERE LANGUAGE = 'US';
Because the view joins translation tables, consumers should filter by LANGUAGE to avoid duplicate rows when multiple translations exist.
-
View: IBC_CONTENT_ITEMS_V 12.1.1
APPS.IBC_CONTENT_ITEMS_V·↳ IBC_CITEM_VERSIONS_B·↳ IBC_CITEM_VERSIONS_TL·↳ IBC_CONTENT_ITEMS·Explore IBC module →
-
View: IBC_CONTENT_ITEMS_V 12.2.2
APPS.IBC_CONTENT_ITEMS_V·↳ IBC_CITEM_VERSIONS_B·↳ IBC_CITEM_VERSIONS_TL·↳ IBC_CONTENT_ITEMS·Explore IBC module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
eTRM - IBC Tables and Views 12.2.2
IBC_STYLESHEETS stores the associated stylesheets for a given content type.
-
eTRM - IBC Tables and Views 12.1.1
IBC_STYLESHEETS stores the associated stylesheets for a given content type.
-
eTRM - IBC Tables and Views 12.2.2
IBC_STYLESHEETS stores the associated stylesheets for a given content type.
-
eTRM - IBC Tables and Views 12.1.1
IBC_STYLESHEETS stores the associated stylesheets for a given content type.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1