Results for “orig_system_reference_code”

50+ results




Overview
Explore in AI Chat

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

Overview

IBC_CONTENT_ITEMS is the master (header) table for Oracle EBS Content Manager (IBC), the module that manages reusable content and collateral used across marketing, proposals, and web placement. As its documented description states, it stores non-version and non-language-specific information about content items — that is, the identity, classification, ownership, and lifecycle status that remain constant across all versions and translations of a given item. Version-specific and language-specific attributes are held in the companion tables IBC_CITEM_VERSIONS_B and IBC_CITEM_VERSION_LABELS, both of which carry a CONTENT_ITEM_ID foreign key back to this table.

Its heuristic Data Vault classification is hub. In modeling terms, IBC_CONTENT_ITEMS corresponds to a hub: a single row per business entity (the content item) carrying its durable business key, while attributes that change over time — versions, labels, and relationships — are modeled as satellites and links in surrounding tables.

Key Information Stored

The table is defined in the IBC schema with 29 documented columns. The most significant are:

Common Use Cases and Queries

Typical reporting needs are finding all live items of a given type, auditing items awaiting translation, and locating content by folder.

  • List active content by type: 
    SELECT ci.content_item_id, ci.item_reference_code, ct.content_type_code
FROM   ibc_content_items ci,
       ibc_content_types_b ct
WHERE  ci.content_type_code = ct.content_type_code
AND    ci.content_item_status = 'ACTIVE';
  • Find items pending translation: 
    SELECT content_item_id, item_reference_code, base_language
FROM   ibc_content_items
WHERE  translation_required_flag = 'Y';
  • Resolve the current published version: 
    SELECT ci.item_reference_code, cv.version_number
FROM   ibc_content_items ci,
       ibc_citem_versions_b cv
WHERE  ci.live_citem_version_id = cv.content_item_id;

Related Objects

  • IBC_CITEM_VERSIONS_B — referenced via LIVE_CITEM_VERSION_ID and referencing back via CONTENT_ITEM_ID; holds version data (the satellite).
  • IBC_CITEM_VERSION_LABELS — language/label rows keyed by CONTENT_ITEM_ID.
  • IBC_CONTENT_TYPES_B — content classification, joined on CONTENT_TYPE_CODE.
  • IBC_DIRECTORY_NODES_B — folder hierarchy, joined on DIRECTORY_NODE_ID.
  • IBC_ASSOCIATIONS and IBC_COMPOUND_RELATIONS — link tables linking content items to each other and to other entities.
  • IBC_CONTENT_ITEM_NODES — site/node placement records.
  • AMS_CONTENT_RULES_B — references content items as cover letters via COVER_LETTER_ID.
  • PRP_PROPOSALS and PRP_COMPONENT_STYLES_B — proposal and style components referencing CONTENT_ITEM_ID.
  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID for access control.