Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IBC Tables and Views

TABLE - IBC.IBC_ASSOCIATIONS
TABLE - IBC.IBC_ASSOCIATION_TYPES_B
TABLE - IBC.IBC_ASSOCIATION_TYPES_TL
TABLE - IBC.IBC_ATTRIBUTE_TYPES_B
TABLE - IBC.IBC_ATTRIBUTE_TYPES_TL
TABLE - IBC.IBC_AUDIT_LOGS
TABLE - IBC.IBC_CITEM_VERSIONS_B
TABLE - IBC.IBC_CITEM_VERSIONS_TL
TABLE - IBC.IBC_CITEM_VERSION_LABELS
TABLE - IBC.IBC_COMPOUND_RELATIONS
TABLE - IBC.IBC_CONTENT_ITEMS
TABLE - IBC.IBC_CONTENT_ITEM_NODES
TABLE - IBC.IBC_CONTENT_TYPES_B
TABLE - IBC.IBC_CONTENT_TYPES_TL
TABLE - IBC.IBC_DIRECTORY_NODES_B
TABLE - IBC.IBC_DIRECTORY_NODES_TL
TABLE - IBC.IBC_DIRECTORY_NODE_RELS
TABLE - IBC.IBC_GRANTS
TABLE - IBC.IBC_GRANT_GROUPS
TABLE - IBC.IBC_LABELS_B
TABLE - IBC.IBC_LABELS_TL
TABLE - IBC.IBC_OBJECT_GRANT_GROUPS
TABLE - IBC.IBC_OBJECT_PERMISSIONS
TABLE - IBC.IBC_RENDITIONS
TABLE - IBC.IBC_STYLESHEETS
VIEW - APPS.IBC_ASSOCIATIONS_V
VIEW - APPS.IBC_ASSOCIATION_TYPES_VL
VIEW - APPS.IBC_ATTRIBUTE_TYPES_VL
VIEW - APPS.IBC_AUDIT_LOGS_V
VIEW - APPS.IBC_CITEMS_V
VIEW - APPS.IBC_CITEM_DOWNLOAD_V
VIEW - APPS.IBC_CITEM_LABELS_V
VIEW - APPS.IBC_CITEM_LIVE_V
VIEW - APPS.IBC_CITEM_PERMISSIONS_V
VIEW - APPS.IBC_CITEM_VERSIONS_VL
VIEW - APPS.IBC_COMPOUND_RELATIONS_V
VIEW - APPS.IBC_CONTENT_ITEMS_V
VIEW - APPS.IBC_CONTENT_ITEM_NODES_V
VIEW - APPS.IBC_CONTENT_TYPES_VL
VIEW - APPS.IBC_DIRECTORY_NODES_VL
VIEW - APPS.IBC_DIRECTORY_NODE_RELS_V
VIEW - APPS.IBC_LABELS_VL
VIEW - APPS.IBC_LOOKUPS
VIEW - APPS.IBC_PENDING_APPROVALS_V
VIEW - APPS.IBC_PENDING_TRANSLATIONS_V
VIEW - APPS.IBC_STYLESHEETS_V
VIEW - APPS.IBC_SUB_DIRECTORY_NODES_V

Table: IBC_ASSOCIATIONS

Description: IBC_ASSOCIATIONS stores the association between content items and other application objects.
Primary Key: IBC_ASSOCIATIONS_PK
  1. ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_ASSOCIATIONS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_ASSOCIATIONS.ASSOCIATION_TYPE_CODE IBC_ASSOCIATION_TYPES_B

[top of page]

IBC.IBC_ASSOCIATIONS does not reference any database object

IBC.IBC_ASSOCIATIONS is referenced by following:

IBC
VIEW - IBC_ASSOCIATIONS#

[top of page]

Table: IBC_ASSOCIATION_TYPES_B

Description: IBC_ASSOCIATION_TYPES_B allows applications to register an association type code for any type ofapplication objects
Primary Key: IBC_ASSOCIATION_TYPES_B_PK
  1. ASSOCIATION_TYPE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_ASSOCIATIONS.ASSOCIATION_TYPE_CODE IBC_ASSOCIATION_TYPES_B
IBC_ASSOCIATION_TYPES_TL.ASSOCIATION_TYPE_CODE IBC_ASSOCIATION_TYPES_B

[top of page]

IBC.IBC_ASSOCIATION_TYPES_B does not reference any database object

IBC.IBC_ASSOCIATION_TYPES_B is referenced by following:

IBC
VIEW - IBC_ASSOCIATION_TYPES_B#

[top of page]

Table: IBC_ASSOCIATION_TYPES_TL

Description: IBC_ASSOCIATION_TYPES_TL stores translated information about association types in IBC_ASSOCIATION_TYPES_B.
Primary Key: IBC_ASSOCIATION_TYPES_TL_PK
  1. ASSOCIATION_TYPE_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_ASSOCIATION_TYPES_TL.ASSOCIATION_TYPE_CODE IBC_ASSOCIATION_TYPES_B

[top of page]

IBC.IBC_ASSOCIATION_TYPES_TL does not reference any database object

IBC.IBC_ASSOCIATION_TYPES_TL is referenced by following:

IBC
VIEW - IBC_ASSOCIATION_TYPES_TL#

[top of page]

Table: IBC_ATTRIBUTE_TYPES_B

Description: IBC_ATTRIBUTE_TYPES_B defines all the attribute types for a given content type
Primary Key: IBC_ATTRIBUTE_TYPES_B_PK
  1. ATTRIBUTE_TYPE_CODE
  2. CONTENT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_ATTRIBUTE_TYPES_B.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B
IBC_ATTRIBUTE_TYPES_B.FLEX_VALUE_SET_ID FND_FLEX_VALUE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_ATTRIBUTE_TYPES_TL.ATTRIBUTE_TYPE_CODE
IBC_ATTRIBUTE_TYPES_TL.CONTENT_TYPE_CODE 		IBC_ATTRIBUTE_TYPES_B
IBC_COMPOUND_RELATIONS.ATTRIBUTE_TYPE_CODE
IBC_COMPOUND_RELATIONS.CONTENT_TYPE_CODE 		IBC_ATTRIBUTE_TYPES_B

[top of page]

IBC.IBC_ATTRIBUTE_TYPES_B does not reference any database object

IBC.IBC_ATTRIBUTE_TYPES_B is referenced by following:

IBC
VIEW - IBC_ATTRIBUTE_TYPES_B#

[top of page]

Table: IBC_ATTRIBUTE_TYPES_TL

Description: IBC_ATTRIBUTE_TYPES_TL stores translated information about attribute types defined in IBC_ATTRIBUTE_TYPES_B.
Primary Key: IBC_ATTRIBUTE_TYPES_TL_PK
  1. ATTRIBUTE_TYPE_CODE
  2. CONTENT_TYPE_CODE
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_ATTRIBUTE_TYPES_TL.ATTRIBUTE_TYPE_CODE
IBC_ATTRIBUTE_TYPES_TL.CONTENT_TYPE_CODE 		IBC_ATTRIBUTE_TYPES_B

[top of page]

IBC.IBC_ATTRIBUTE_TYPES_TL does not reference any database object

IBC.IBC_ATTRIBUTE_TYPES_TL is referenced by following:

IBC
VIEW - IBC_ATTRIBUTE_TYPES_TL#

[top of page]

Table: IBC_AUDIT_LOGS

Description: IBC_AUDIT_LOGS stores all the actions performed on any OCM object
Primary Key: IBC_AUDIT_LOGS_PK
  1. AUDIT_LOG_ID

[top of page]

IBC.IBC_AUDIT_LOGS does not reference any database object

IBC.IBC_AUDIT_LOGS is referenced by following:

IBC
VIEW - IBC_AUDIT_LOGS#

[top of page]

Table: IBC_CITEM_VERSIONS_B

Description: IBC_CITEM_VERSIONS_B stores all the versions of a content item
Primary Key: IBC_CITEM_VERSIONS_B_PK
  1. CITEM_VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_CITEM_VERSIONS_B.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_CITEM_VERSIONS_TL.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
IBC_CITEM_VERSION_LABELS.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
IBC_COMPOUND_RELATIONS.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
IBC_CONTENT_ITEMS.LIVE_CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
PRP_PERZ_FILES.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
PRP_PROPOSAL_CTNTVERS.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
PV_PARTNER_PROGRAM_B.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B

[top of page]

IBC.IBC_CITEM_VERSIONS_B does not reference any database object

IBC.IBC_CITEM_VERSIONS_B is referenced by following:

IBC
VIEW - IBC_CITEM_VERSIONS_B#

[top of page]

Table: IBC_CITEM_VERSIONS_TL

Description: IBC_CITEM_VERSIONS_TL stores language striped information about content item versions defined in IBC_CITEM_VERSIONS_B.
Primary Key: IBC_CITEM_VERSION_LANGS_PK
  1. CITEM_VERSION_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_CITEM_VERSIONS_TL.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
IBC_CITEM_VERSIONS_TL.ATTACHMENT_FILE_ID FND_LOBS
IBC_CITEM_VERSIONS_TL.ATTRIBUTE_FILE_ID FND_LOBS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_COMP_STYLE_CTNTVERS.CITEM_VERSION_ID
PRP_COMP_STYLE_CTNTVERS.LANGUAGE 		IBC_CITEM_VERSIONS_TL

[top of page]

IBC.IBC_CITEM_VERSIONS_TL does not reference any database object

IBC.IBC_CITEM_VERSIONS_TL is referenced by following:

IBC
VIEW - IBC_CITEM_VERSIONS_TL#

[top of page]

Table: IBC_CITEM_VERSION_LABELS

Description: IBC_CITEM_VERSION_LABELS stores the association between a label and the version of any content item.
Primary Key: IBC_CITEM_VERSION_LABELS_PK
  1. LABEL_CODE
  2. CONTENT_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_CITEM_VERSION_LABELS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_CITEM_VERSION_LABELS.LABEL_CODE IBC_LABELS_B
IBC_CITEM_VERSION_LABELS.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B

[top of page]

IBC.IBC_CITEM_VERSION_LABELS does not reference any database object

IBC.IBC_CITEM_VERSION_LABELS is referenced by following:

IBC
VIEW - IBC_CITEM_VERSION_LABELS#

[top of page]

Table: IBC_COMPOUND_RELATIONS

Description: IBC_COMPOUND_RELATIONS stores the component content item id for each attribute of the compound item that is of data type component.
Primary Key: IBC_COMPOUND_RELATIONS_PK
  1. COMPOUND_RELATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_COMPOUND_RELATIONS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_COMPOUND_RELATIONS.ATTRIBUTE_TYPE_CODE
IBC_COMPOUND_RELATIONS.CONTENT_TYPE_CODE 		IBC_ATTRIBUTE_TYPES_B
IBC_COMPOUND_RELATIONS.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B

[top of page]

IBC.IBC_COMPOUND_RELATIONS does not reference any database object

IBC.IBC_COMPOUND_RELATIONS is referenced by following:

IBC
VIEW - IBC_COMPOUND_RELATIONS#

[top of page]

Table: IBC_CONTENT_ITEMS

Description: IBC_CONTENT_ITEMS stores non version or language specific information about content items
Primary Key: IBC_CONTENT_ITEMS_PK
  1. CONTENT_ITEM_ID
Primary Key: IBC_CONTENT_ITEMS_UK
  1. ITEM_REFERENCE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B
IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID IBC_DIRECTORY_NODES_B
IBC_CONTENT_ITEMS.LIVE_CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
AMS_CONTENT_RULES_B.COVER_LETTER_ID IBC_CONTENT_ITEMS
IBC_ASSOCIATIONS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_CONTENT_ITEM_NODES.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_CITEM_VERSIONS_B.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_CITEM_VERSION_LABELS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_COMPOUND_RELATIONS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_STYLESHEETS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
PRP_COMPONENT_STYLES_B.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
PRP_PROPOSALS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS

[top of page]

IBC.IBC_CONTENT_ITEMS does not reference any database object

IBC.IBC_CONTENT_ITEMS is referenced by following:

IBC
VIEW - IBC_CONTENT_ITEMS#

[top of page]

Table: IBC_CONTENT_ITEM_NODES

Description: IBC_CONTENT_ITEM_NODES stores information about under which directory node a content itemresides.
Primary Key: IBC_CONTENT_ITEM_NODES_PK
  1. CONTENT_ITEM_NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_CONTENT_ITEM_NODES.DIRECTORY_NODE_ID IBC_DIRECTORY_NODES_B
IBC_CONTENT_ITEM_NODES.CONTENT_ITEM_ID IBC_CONTENT_ITEMS

[top of page]

IBC.IBC_CONTENT_ITEM_NODES does not reference any database object

IBC.IBC_CONTENT_ITEM_NODES is referenced by following:

IBC
VIEW - IBC_CONTENT_ITEM_NODES#

[top of page]

Table: IBC_CONTENT_TYPES_B

Description: IBC_CONTENT_TYPES_B stores abstract information about a group of similar content items
Primary Key: IBC_CONTENT_TYPES_B_PK
  1. CONTENT_TYPE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_ATTRIBUTE_TYPES_B.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B
IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B
IBC_CONTENT_TYPES_TL.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B
IBC_STYLESHEETS.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B

[top of page]

IBC.IBC_CONTENT_TYPES_B does not reference any database object

IBC.IBC_CONTENT_TYPES_B is referenced by following:

IBC
VIEW - IBC_CONTENT_TYPES_B#

[top of page]

Table: IBC_CONTENT_TYPES_TL

Description: IBC_CONTENT_TYPES_TL stores translated information about content types.
Primary Key: IBC_CONTENT_TYPES_TL_PK
  1. CONTENT_TYPE_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_CONTENT_TYPES_TL.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B

[top of page]

IBC.IBC_CONTENT_TYPES_TL does not reference any database object

IBC.IBC_CONTENT_TYPES_TL is referenced by following:

IBC
VIEW - IBC_CONTENT_TYPES_TL#

[top of page]

Table: IBC_DIRECTORY_NODES_B

Description: IBC_DIRECTORY_NODES_B defines all directory nodes.
Primary Key: IBC_DIRECTORY_NODES_B_PK
  1. DIRECTORY_NODE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_CONTENT_ITEM_NODES.DIRECTORY_NODE_ID IBC_DIRECTORY_NODES_B
IBC_CONTENT_ITEMS.DIRECTORY_NODE_ID IBC_DIRECTORY_NODES_B
IBC_DIRECTORY_NODES_TL.DIRECTORY_NODE_ID IBC_DIRECTORY_NODES_B
IBC_DIRECTORY_NODE_RELS.CHILD_DIR_NODE_ID IBC_DIRECTORY_NODES_B
IBC_DIRECTORY_NODE_RELS.PARENT_DIR_NODE_ID IBC_DIRECTORY_NODES_B

[top of page]

IBC.IBC_DIRECTORY_NODES_B does not reference any database object

IBC.IBC_DIRECTORY_NODES_B is referenced by following:

IBC
VIEW - IBC_DIRECTORY_NODES_B#

[top of page]

Table: IBC_DIRECTORY_NODES_TL

Description: IBC_DIRECTORY_NODES_TL stores translated information about directory nodes
Primary Key: IBC_DIRECTORY_NODES_TL_PK
  1. DIRECTORY_NODE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_DIRECTORY_NODES_TL.DIRECTORY_NODE_ID IBC_DIRECTORY_NODES_B

[top of page]

IBC.IBC_DIRECTORY_NODES_TL does not reference any database object

IBC.IBC_DIRECTORY_NODES_TL is referenced by following:

IBC
VIEW - IBC_DIRECTORY_NODES_TL#

[top of page]

Table: IBC_DIRECTORY_NODE_RELS

Description: IBC_DIRECTORY_NODE_RELS store relationship information between parent and child directory nodes.
Primary Key: IBC_DIRECTORY_NODE_RELS_PK
  1. DIRECTORY_NODE_REL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_DIRECTORY_NODE_RELS.CHILD_DIR_NODE_ID IBC_DIRECTORY_NODES_B
IBC_DIRECTORY_NODE_RELS.PARENT_DIR_NODE_ID IBC_DIRECTORY_NODES_B

[top of page]

IBC.IBC_DIRECTORY_NODE_RELS does not reference any database object

IBC.IBC_DIRECTORY_NODE_RELS is referenced by following:

IBC
VIEW - IBC_DIRECTORY_NODE_RELS#

[top of page]

Table: IBC_GRANTS

Description: This table stores all Permissions given for a particular object.
Primary Key: IBC_GRANTS_PK
  1. GRANT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_GRANTS.GRANT_GROUP_ID IBC_GRANT_GROUPS
IBC_GRANTS.OBJECT_ID FND_OBJECTS
IBC_GRANTS.GRANTEE_USER_ID FND_USER

[top of page]

IBC.IBC_GRANTS does not reference any database object

IBC.IBC_GRANTS is referenced by following:

IBC
VIEW - IBC_GRANTS#

[top of page]

Table: IBC_GRANT_GROUPS

Description: This Table stroes a group of grants
Primary Key: IBC_GRANT_GROUPS_PK
  1. GRANT_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_GRANTS.GRANT_GROUP_ID IBC_GRANT_GROUPS
IBC_OBJECT_GRANT_GROUPS.GRANT_GROUP_ID IBC_GRANT_GROUPS

[top of page]

IBC.IBC_GRANT_GROUPS does not reference any database object

IBC.IBC_GRANT_GROUPS is referenced by following:

IBC
VIEW - IBC_GRANT_GROUPS#

[top of page]

Table: IBC_LABELS_B

Description: IBC_LABELS_B defines labels
Primary Key: IBC_LABELS_B_PK
  1. LABEL_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_CITEM_VERSION_LABELS.LABEL_CODE IBC_LABELS_B
IBC_LABELS_TL.LABEL_CODE IBC_LABELS_B

[top of page]

IBC.IBC_LABELS_B does not reference any database object

IBC.IBC_LABELS_B is referenced by following:

IBC
VIEW - IBC_LABELS_B#

[top of page]

Table: IBC_LABELS_TL

Description: IBC_LABELS_TL store translated information about labels.
Primary Key: IBC_LABELS_TL_PK
  1. LABEL_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_LABELS_TL.LABEL_CODE IBC_LABELS_B

[top of page]

IBC.IBC_LABELS_TL does not reference any database object

IBC.IBC_LABELS_TL is referenced by following:

IBC
VIEW - IBC_LABELS_TL#

[top of page]

Table: IBC_OBJECT_GRANT_GROUPS

Description: This Table stores mapping of an object instance to a particular grant group.
Primary Key: IBC_OBJECT_GRANT_GROUPS_PK
  1. OBJECT_GRANT_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_OBJECT_GRANT_GROUPS.GRANT_GROUP_ID IBC_GRANT_GROUPS
IBC_OBJECT_GRANT_GROUPS.OBJECT_ID FND_OBJECTS
IBC_OBJECT_GRANT_GROUPS.INHERITED_FROM IBC_OBJECT_GRANT_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IBC_OBJECT_GRANT_GROUPS.INHERITED_FROM IBC_OBJECT_GRANT_GROUPS

[top of page]

IBC.IBC_OBJECT_GRANT_GROUPS does not reference any database object

IBC.IBC_OBJECT_GRANT_GROUPS is referenced by following:

IBC
VIEW - IBC_OBJECT_GRANT_GROUPS#

[top of page]

Table: IBC_OBJECT_PERMISSIONS

Description: This Table defines the lookup type which holds the valid permission codes for a particular object type
Primary Key: IBC_OBJECT_PERMISSIONS_PK
  1. OBJECT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_OBJECT_PERMISSIONS.OBJECT_ID FND_OBJECTS

[top of page]

IBC.IBC_OBJECT_PERMISSIONS does not reference any database object

IBC.IBC_OBJECT_PERMISSIONS is referenced by following:

IBC
VIEW - IBC_OBJECT_PERMISSIONS#

[top of page]

Table: IBC_RENDITIONS

Description: This Table stores renditions data to support multiple file types for a content item's attachment.
Primary Key: IBC_RENDITIONS_PK
  1. RENDITION_ID

[top of page]

IBC.IBC_RENDITIONS does not reference any database object

IBC.IBC_RENDITIONS is referenced by following:

IBC
VIEW - IBC_RENDITIONS#

[top of page]

Table: IBC_STYLESHEETS

Description: IBC_STYLESHEETS stores the associated stylesheets for a given content type.
Primary Key: IBC_STYLESHEETS_PK
  1. CONTENT_TYPE_CODE
  2. CONTENT_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IBC_STYLESHEETS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
IBC_STYLESHEETS.CONTENT_TYPE_CODE IBC_CONTENT_TYPES_B

[top of page]

IBC.IBC_STYLESHEETS does not reference any database object

IBC.IBC_STYLESHEETS is referenced by following:

IBC
VIEW - IBC_STYLESHEETS#

[top of page]

View: IBC_ASSOCIATIONS_V

[top of page]

APPS.IBC_ASSOCIATIONS_V references the following:

APPS
SYNONYM - IBC_ASSOCIATIONS

APPS.IBC_ASSOCIATIONS_V is not referenced by any database object

[top of page]

View: IBC_ASSOCIATION_TYPES_VL

[top of page]

APPS.IBC_ASSOCIATION_TYPES_VL references the following:

APPS
SYNONYM - IBC_ASSOCIATION_TYPES_B
SYNONYM - IBC_ASSOCIATION_TYPES_TL

APPS.IBC_ASSOCIATION_TYPES_VL is not referenced by any database object

[top of page]

View: IBC_ATTRIBUTE_TYPES_VL

[top of page]

APPS.IBC_ATTRIBUTE_TYPES_VL references the following:

APPS
SYNONYM - IBC_ATTRIBUTE_TYPES_B
SYNONYM - IBC_ATTRIBUTE_TYPES_TL
SYNONYM - IBC_CONTENT_TYPES_TL

APPS.IBC_ATTRIBUTE_TYPES_VL is not referenced by any database object

[top of page]

View: IBC_AUDIT_LOGS_V

[top of page]

APPS.IBC_AUDIT_LOGS_V references the following:

APPS
SYNONYM - IBC_AUDIT_LOGS
PACKAGE - IBC_AUDIT_LOG_GRP

APPS.IBC_AUDIT_LOGS_V is not referenced by any database object

[top of page]

View: IBC_CITEMS_V

[top of page]

APPS.IBC_CITEMS_V references the following:

APPS
SYNONYM - IBC_CITEM_VERSIONS_B
SYNONYM - IBC_CITEM_VERSIONS_TL
SYNONYM - IBC_CONTENT_ITEMS
SYNONYM - IBC_CONTENT_TYPES_TL
SYNONYM - IBC_DIRECTORY_NODES_B
SYNONYM - IBC_DIRECTORY_NODES_TL

APPS.IBC_CITEMS_V is not referenced by any database object

[top of page]

View: IBC_CITEM_DOWNLOAD_V

[top of page]

APPS.IBC_CITEM_DOWNLOAD_V references the following:

APPS
VIEW - FND_APPLICATION_VL
SYNONYM - FND_LOBS
VIEW - IBC_CITEM_VERSIONS_VL
SYNONYM - IBC_CONTENT_ITEMS

APPS.IBC_CITEM_DOWNLOAD_V is not referenced by any database object

[top of page]

View: IBC_CITEM_LABELS_V

[top of page]

APPS.IBC_CITEM_LABELS_V references the following:

APPS
SYNONYM - IBC_CITEM_VERSIONS_B
SYNONYM - IBC_CITEM_VERSIONS_TL
SYNONYM - IBC_CITEM_VERSION_LABELS
SYNONYM - IBC_CONTENT_ITEMS
SYNONYM - IBC_CONTENT_TYPES_TL

APPS.IBC_CITEM_LABELS_V is not referenced by any database object

[top of page]

View: IBC_CITEM_LIVE_V

[top of page]

APPS.IBC_CITEM_LIVE_V references the following:

APPS
SYNONYM - IBC_CITEM_VERSIONS_B
SYNONYM - IBC_CITEM_VERSIONS_TL
SYNONYM - IBC_CONTENT_ITEMS
SYNONYM - IBC_CONTENT_TYPES_TL

APPS.IBC_CITEM_LIVE_V is not referenced by any database object

[top of page]

View: IBC_CITEM_PERMISSIONS_V

[top of page]

APPS.IBC_CITEM_PERMISSIONS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_OBJECTS
SYNONYM - IBC_CONTENT_ITEMS
SYNONYM - IBC_DIRECTORY_NODES_B
SYNONYM - IBC_GRANTS
SYNONYM - IBC_OBJECT_GRANT_GROUPS
PACKAGE - IBC_UTILITIES_PVT
SYNONYM - JTF_RS_GROUPS_DENORM
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_RESOURCE_EXTNS

APPS.IBC_CITEM_PERMISSIONS_V is not referenced by any database object

[top of page]

View: IBC_CITEM_VERSIONS_VL

[top of page]

APPS.IBC_CITEM_VERSIONS_VL references the following:

APPS
SYNONYM - IBC_CITEM_VERSIONS_B
SYNONYM - IBC_CITEM_VERSIONS_TL
APPS.IBC_CITEM_VERSIONS_VL is referenced by following:

APPS
VIEW - IBC_CITEM_DOWNLOAD_V

[top of page]

View: IBC_COMPOUND_RELATIONS_V

[top of page]

APPS.IBC_COMPOUND_RELATIONS_V references the following:

APPS
SYNONYM - IBC_COMPOUND_RELATIONS

APPS.IBC_COMPOUND_RELATIONS_V is not referenced by any database object

[top of page]

View: IBC_CONTENT_ITEMS_V

[top of page]

APPS.IBC_CONTENT_ITEMS_V references the following:

APPS
SYNONYM - IBC_CITEM_VERSIONS_B
SYNONYM - IBC_CITEM_VERSIONS_TL
SYNONYM - IBC_CONTENT_ITEMS
SYNONYM - IBC_CONTENT_TYPES_TL

APPS.IBC_CONTENT_ITEMS_V is not referenced by any database object

[top of page]

View: IBC_CONTENT_ITEM_NODES_V

[top of page]

APPS.IBC_CONTENT_ITEM_NODES_V references the following:

APPS
SYNONYM - IBC_CONTENT_ITEM_NODES

APPS.IBC_CONTENT_ITEM_NODES_V is not referenced by any database object

[top of page]

View: IBC_CONTENT_TYPES_VL

[top of page]

APPS.IBC_CONTENT_TYPES_VL references the following:

APPS
SYNONYM - IBC_CONTENT_TYPES_B
SYNONYM - IBC_CONTENT_TYPES_TL
APPS.IBC_CONTENT_TYPES_VL is referenced by following:

APPS
VIEW - IBC_CTYPE_GROUPS_V

[top of page]

View: IBC_DIRECTORY_NODES_VL

[top of page]

APPS.IBC_DIRECTORY_NODES_VL references the following:

APPS
SYNONYM - IBC_DIRECTORY_NODES_B
SYNONYM - IBC_DIRECTORY_NODES_TL
APPS.IBC_DIRECTORY_NODES_VL is referenced by following:

APPS
VIEW - IBC_SUB_DIRECTORY_NODES_V

[top of page]

View: IBC_DIRECTORY_NODE_RELS_V

[top of page]

APPS.IBC_DIRECTORY_NODE_RELS_V references the following:

APPS
SYNONYM - IBC_DIRECTORY_NODE_RELS

APPS.IBC_DIRECTORY_NODE_RELS_V is not referenced by any database object

[top of page]

View: IBC_LABELS_VL

[top of page]

APPS.IBC_LABELS_VL references the following:

APPS
SYNONYM - IBC_LABELS_B
SYNONYM - IBC_LABELS_TL

APPS.IBC_LABELS_VL is not referenced by any database object

[top of page]

View: IBC_LOOKUPS

[top of page]

APPS.IBC_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES

APPS.IBC_LOOKUPS is not referenced by any database object

[top of page]

View: IBC_PENDING_APPROVALS_V

[top of page]

APPS.IBC_PENDING_APPROVALS_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - WF_CORE
PACKAGE - WF_DIRECTORY
VIEW - WF_ITEM_ACTIVITY_STATUSES_V
VIEW - WF_USER_ROLES

APPS.IBC_PENDING_APPROVALS_V is not referenced by any database object

[top of page]

View: IBC_PENDING_TRANSLATIONS_V

[top of page]

APPS.IBC_PENDING_TRANSLATIONS_V references the following:

APPS
PACKAGE - WF_CORE
PACKAGE - WF_DIRECTORY
VIEW - WF_ITEM_ACTIVITY_STATUSES_V
VIEW - WF_USER_ROLES

APPS.IBC_PENDING_TRANSLATIONS_V is not referenced by any database object

[top of page]

View: IBC_STYLESHEETS_V

[top of page]

APPS.IBC_STYLESHEETS_V references the following:

APPS
SYNONYM - IBC_STYLESHEETS

APPS.IBC_STYLESHEETS_V is not referenced by any database object

[top of page]

View: IBC_SUB_DIRECTORY_NODES_V

[top of page]

APPS.IBC_SUB_DIRECTORY_NODES_V references the following:

APPS
VIEW - IBC_DIRECTORY_NODES_VL
SYNONYM - IBC_DIRECTORY_NODE_RELS

APPS.IBC_SUB_DIRECTORY_NODES_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract