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
Comments

IBC_ASSOCIATIONS stores the association between content items and other application objects.
Column ASSOCIATION_TYPE_CODE, which is a foreign key to table IBC_ASSOCIATION_TYPES_B, indicates the application object type, such as inventory item, or marketing compaign. ASSOCIATED_OBJECT_VAL1 to ASSOCIATED_OBJECT_VAL5 point to the primary key of the associated application object. With data from this table, applications can find related content items for a given application object, or find related application objects for a given content item.

Indexes
Index Type Tablespace Column
IBC_ASSOCIATIONS_U1 UNIQUE APPS_TS_SEED ASSOCIATION_ID
ZD_EDITION_NAME
IBC_ASSOCIATIONS_U2 UNIQUE APPS_TS_SEED CONTENT_ITEM_ID
ASSOCIATED_OBJECT_VAL1
ASSOCIATED_OBJECT_VAL2
ASSOCIATED_OBJECT_VAL3
ASSOCIATED_OBJECT_VAL4
ASSOCIATED_OBJECT_VAL5
ASSOCIATION_TYPE_CODE
CITEM_VERSION_ID
ZD_EDITION_NAME
IBC_ASSOCIATIONS_N1 NONUNIQUE APPS_TS_SEED ASSOCIATED_OBJECT_VAL1
ASSOCIATED_OBJECT_VAL2
ASSOCIATED_OBJECT_VAL3
ASSOCIATED_OBJECT_VAL4
ASSOCIATED_OBJECT_VAL5
ASSOCIATION_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_ID NUMBER
Y Association unique identifier
CONTENT_ITEM_ID NUMBER
Y Content item identifier
ASSOCIATION_TYPE_CODE VARCHAR2 (100) Y Association type code
ASSOCIATED_OBJECT_VAL1 VARCHAR2 (254) Y Associated object value 1
ASSOCIATED_OBJECT_VAL2 VARCHAR2 (254)
Associated object value 2
ASSOCIATED_OBJECT_VAL3 VARCHAR2 (254)
Associated object value 3
ASSOCIATED_OBJECT_VAL4 VARCHAR2 (254)
Associated object value 4
ASSOCIATED_OBJECT_VAL5 VARCHAR2 (254)
Associated object value 5
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
CITEM_VERSION_ID NUMBER

Content Item Version Identifier
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_ASSOCIATION_TYPES_B allows applications to register an association type code for any type of
application objects. The association type code is used by IBC_ASSOCIATIONS to identify what type of
application objects are associated to a content item. SEARCH_PAGE is used to register a jsp page that
OCM UI will launch when a user needs to find objects of this association type.

Indexes
Index Type Tablespace Column
IBC_ASSOCIATION_TYPES_B_U1 UNIQUE APPS_TS_SEED ASSOCIATION_TYPE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_TYPE_CODE VARCHAR2 (100) Y Association type code for a type of application objects, e.g. inventory item
CALL_BACK_PKG VARCHAR2 (50)
A call back package to validate the given application object
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SEARCH_PAGE VARCHAR2 (2000)
UI page used to search for such application objects
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_ASSOCIATION_TYPES_TL stores translated information about association types in IBC_ASSOCIATION_TYPES_B.

Indexes
Index Type Tablespace Column
IBC_ASSOCIATION_TYPES_TL_U1 UNIQUE APPS_TS_SEED ASSOCIATION_TYPE_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_TYPE_CODE VARCHAR2 (100) Y Association type code for a type of application objects, e.g. inventory item
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
ASSOCIATION_TYPE_NAME VARCHAR2 (240) Y Association type name
DESCRIPTION VARCHAR2 (2000)
Association type description
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_ATTRIBUTE_TYPES_B defines all the attribute types for a given content type. For each
attribute, the data type, data length, number of instances, and default value are defined.
The value for DATA_TYPE_CODE column has to be lookup code from ibc_attribute_data_type.

Indexes
Index Type Tablespace Column
IBC_ATTRIBUTE_TYPES_B_U1 UNIQUE APPS_TS_TX_IDX CONTENT_TYPE_CODE
ATTRIBUTE_TYPE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_TYPE_CODE VARCHAR2 (100) Y Attribute type code
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code this attribute belongs
FLEX_VALUE_SET_ID NUMBER

Flexfield value set identifier. References FND_FLEX_VALUES
DATA_TYPE_CODE VARCHAR2 (30) Y Data type of this attribute
DATA_LENGTH NUMBER (15)
Length limit for this attribute if data type is string, url or html
MIN_INSTANCES NUMBER
Y Minimal number of attribute instances for any content item of this content type
MAX_INSTANCES NUMBER

Maximum number of attribute instances for any content item of this content type
DEFAULT_VALUE VARCHAR2 (240)
Default value of the attribute
UPDATEABLE_FLAG VARCHAR2 (1) Y Whether the default value can be updated at item instance level
REFERENCE_CODE VARCHAR2 (100)
If datatype is component, this is the content type code of the component items referred via this attribute
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
DISPLAY_ORDER NUMBER

Maximum number of attribute instances for any content item of this content type
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_ATTRIBUTE_TYPES_TL stores translated information about attribute types defined in IBC_ATTRIBUTE_TYPES_B.

Indexes
Index Type Tablespace Column
IBC_ATTRIBUTE_TYPES_TL_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_TYPE_CODE
CONTENT_TYPE_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_TYPE_CODE VARCHAR2 (100) Y Attribute type code
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code this attribute belongs to.
ATTRIBUTE_TYPE_NAME VARCHAR2 (240) Y Name of the Attribute type.
DESCRIPTION VARCHAR2 (2000)
Description of Attribute type
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_AUDIT_LOGS stores all the actions performed on any OCM object. It catches activity name, user who performed the activity, date and time, OCM object type and value the activity is performed against.

Indexes
Index Type Tablespace Column
IBC_AUDIT_LOGS_U1 UNIQUE APPS_TS_TX_IDX AUDIT_LOG_ID
IBC_AUDIT_LOGS_N01 NONUNIQUE APPS_TS_TX_IDX OBJECT_VALUE1
OBJECT_VALUE2
Columns
Name Datatype Length Mandatory Comments
AUDIT_LOG_ID NUMBER
Y Audit log unique identifier
ACTIVITY VARCHAR2 (100) Y Activity name
USER_ID NUMBER (15) Y User who performed the activity
TIME_STAMP DATE
Y Date and time the activity is performed
OBJECT_TYPE VARCHAR2 (30) Y OCM object type the activity is performed on
PARENT_VALUE VARCHAR2 (254)
Parent Value
OBJECT_VALUE1 VARCHAR2 (254) Y Object value 1 to identify the OCM object
OBJECT_VALUE2 VARCHAR2 (254)
Object value 2 to identify the OCM object
OBJECT_VALUE3 VARCHAR2 (254)
Object value 3 to identify the OCM object
OBJECT_VALUE4 VARCHAR2 (254)
Object value 4 to identify the OCM object
OBJECT_VALUE5 VARCHAR2 (254)
Object value 5 to identify the OCM object
DESCRIPTION VARCHAR2 (2000)
Description of Audit Log
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
INTERNAL_FLAG VARCHAR2 (1)
Internal Flag
APPLICATION_ID NUMBER

Application id
MESSAGE_NAME VARCHAR2 (80)
Message Name
EXTRA_INFO1_TYPE VARCHAR2 (30)
Type Extra Information for Audit
EXTRA_INFO1_REF_TYPE VARCHAR2 (30)
Extra Information reference type
EXTRA_INFO1_VALUE VARCHAR2 (256)
Extra Informations value for Audit
EXTRA_INFO2_TYPE VARCHAR2 (30)
Type Extra Information for Audit
EXTRA_INFO2_REF_TYPE VARCHAR2 (30)
Extra Information reference type
EXTRA_INFO2_VALUE VARCHAR2 (256)
Extra Informations value for Audit
EXTRA_INFO3_TYPE VARCHAR2 (30)
Type Extra Information for Audit
EXTRA_INFO3_REF_TYPE VARCHAR2 (30)
Extra Information reference type
EXTRA_INFO3_VALUE VARCHAR2 (256)
Extra Informations value for Audit
EXTRA_INFO4_TYPE VARCHAR2 (30)
Type Extra Information for Audit
EXTRA_INFO4_REF_TYPE VARCHAR2 (30)
Extra Information reference type
EXTRA_INFO4_VALUE VARCHAR2 (256)
Extra Informations value for Audit
EXTRA_INFO5_TYPE VARCHAR2 (30)
Type Extra Information for Audit
EXTRA_INFO5_REF_TYPE VARCHAR2 (30)
Extra Information reference type
EXTRA_INFO5_VALUE VARCHAR2 (256)
Extra Informations value for Audit
OBJECT_STATUS VARCHAR2 (30)
Object Status
MESSAGE_APPLICATION VARCHAR2 (50)
Application Message

[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
Comments

IBC_CITEM_VERSIONS_B stores all the versions of a content item. Each version can be in any
of the status defined by lookup type ibc_citem_version_status.
Attribute values in each item version is governed by the attribute type defined along with its content type.

Indexes
Index Type Tablespace Column
IBC_CITEM_VERSIONS_B_U1 UNIQUE APPS_TS_TX_IDX CITEM_VERSION_ID
ZD_EDITION_NAME
IBC_CITEM_VERSIONS_B_U2 UNIQUE APPS_TS_TX_IDX CONTENT_ITEM_ID
VERSION_NUMBER
ZD_EDITION_NAME
IBC_CITEM_VERSIONS_B_N1 NONUNIQUE APPS_TS_TX_IDX START_DATE
END_DATE
Columns
Name Datatype Length Mandatory Comments
CITEM_VERSION_ID NUMBER
Y Citem Versions unique identifier
CONTENT_ITEM_ID NUMBER
Y Content item identifier
VERSION_NUMBER NUMBER (15) Y Version number of the content item
CITEM_VERSION_STATUS VARCHAR2 (30)
Status of this content item version.
START_DATE DATE

Effective Start date of this version
END_DATE DATE

Effective End date of this version
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_CITEM_VERSIONS_TL stores language striped information about content item versions defined
in IBC_CITEM_VERSIONS_B.

Indexes
Index Type Tablespace Column
IBC_CITEM_VERSIONS_TL_U1 UNIQUE APPS_TS_TX_IDX CITEM_VERSION_ID
LANGUAGE
ZD_EDITION_NAME
IBC_CITEM_VERSIONS_TL_FN1 NONUNIQUE APPS_TS_TX_IDX SYS_NC00017$
IBC_CITEM_VERSIONS_TL_N1 NONUNIQUE APPS_TS_TX_IDX CONTENT_ITEM_NAME
Columns
Name Datatype Length Mandatory Comments
CITEM_VERSION_ID NUMBER
Y Content item version identifier
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
ATTACHMENT_ATTRIBUTE_CODE VARCHAR2 (100)
Atachment Attribute Code
ATTRIBUTE_FILE_ID NUMBER

All primitive attribute values are stored as a XML bundle in FND_LOBS. This column points to the BLOB
ATTACHMENT_FILE_ID NUMBER

Points to the BLOB in FND_LOBS which stores the attachment file for this content item version
CONTENT_ITEM_NAME VARCHAR2 (240) Y Content item name for this version
ATTACHMENT_FILE_NAME VARCHAR2 (256)
File name of the attachment
DESCRIPTION VARCHAR2 (2000)
Content item description for this version
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
DEFAULT_RENDITION_MIME_TYPE VARCHAR2 (30)
Default Rendition Mime Type for this Content Item Version
CITEM_TRANSLATION_STATUS VARCHAR2 (30)
Atachment Attribute Code
TEXTIDX VARCHAR2 (1)
Used for user_datastore for Oracle Text
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_CITEM_VERSION_LABELS stores the association between a label and the version of any content item.
By using labels, applications can control which approved version of a content item to be delivered at
runtime instead of the the live version.

Indexes
Index Type Tablespace Column
IBC_CITEM_VERSION_LABELS_U1 UNIQUE APPS_TS_SEED CONTENT_ITEM_ID
LABEL_CODE
ZD_EDITION_NAME
IBC_CITEM_VERSION_LABELS_N1 NONUNIQUE APPS_TS_SEED LABEL_CODE
Columns
Name Datatype Length Mandatory Comments
CONTENT_ITEM_ID NUMBER
Y Content item identifier
LABEL_CODE VARCHAR2 (100) Y Label code
CITEM_VERSION_ID NUMBER
Y Content item version identifier
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_COMPOUND_RELATIONS stores the component content item id for each attribute of the compound item that is of data type component.

Indexes
Index Type Tablespace Column
IBC_COMPOUND_RELATIONS_U1 UNIQUE APPS_TS_TX_IDX COMPOUND_RELATION_ID
ZD_EDITION_NAME
IBC_COMPOUND_RELATIONS_U2 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_TYPE_CODE
CITEM_VERSION_ID
CONTENT_ITEM_ID
CONTENT_TYPE_CODE
ZD_EDITION_NAME
IBC_COMPOUND_RELATIONS_N NONUNIQUE APPS_TS_TX_IDX CITEM_VERSION_ID
IBC_COMPOUND_RELATIONS_N3 NONUNIQUE APPS_TS_TX_IDX CONTENT_ITEM_ID
IBC_COMPOUND_RELATIONS_N4 NONUNIQUE APPS_TS_TX_IDX CONTENT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
COMPOUND_RELATION_ID NUMBER
Y Compound relation unique identifier
CONTENT_ITEM_ID NUMBER
Y Content item identifier referenced by the ATTRIBUTE_TYPE_CODE
ATTRIBUTE_TYPE_CODE VARCHAR2 (100) Y Attibute type code for the compound item's attribute of which data type is component
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code for the compound item's attribute of which data type is component
CITEM_VERSION_ID NUMBER
Y Content item version identifier of the compound item
SORT_ORDER NUMBER
Y The order number of component instance of ATTRIBUTE_TYPE_CODE
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
SUBITEM_VERSION_ID NUMBER

Content item version identifier of the compound item
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_CONTENT_ITEMS stores non version or language specific information about content items.
Each content item belongs to a content type, which defines all the attributes for the content item.
A content item always resides in a directory node called its working directory. Content item status
is any value from lookup type ibc_citem_status

Indexes
Index Type Tablespace Column
IBC_CONTENT_ITEMS_U1 UNIQUE APPS_TS_TX_IDX CONTENT_ITEM_ID
ZD_EDITION_NAME
IBC_CONTENT_ITEMS_N1 NONUNIQUE APPS_TS_TX_IDX CONTENT_TYPE_CODE
IBC_CONTENT_ITEMS_N2 NONUNIQUE APPS_TS_TX_IDX DIRECTORY_NODE_ID
IBC_CONTENT_ITEMS_N3 NONUNIQUE APPS_TS_TX_IDX LIVE_CITEM_VERSION_ID
IBC_CONTENT_ITEMS_N4 NONUNIQUE APPS_TS_TX_IDX CONTENT_ITEM_STATUS
IBC_CONTENT_ITEMS_N5 NONUNIQUE APPS_TS_TX_IDX OWNER_RESOURCE_ID
OWNER_RESOURCE_TYPE
IBC_CONTENT_ITEMS_N6 NONUNIQUE APPS_TS_TX_IDX ITEM_REFERENCE_CODE
Columns
Name Datatype Length Mandatory Comments
CONTENT_ITEM_ID NUMBER
Y Content item Unique identifier
ITEM_REFERENCE_CODE VARCHAR2 (100)
Content item reference code
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code for this content item references IBC_CONTENT_TYPE_B
DIRECTORY_NODE_ID NUMBER
Y Directory node identifier to which this content item belongs
PARENT_ITEM_ID NUMBER

Parent Item Identifier
LIVE_CITEM_VERSION_ID NUMBER

Live version of this content item
CONTENT_ITEM_STATUS VARCHAR2 (30)
Status of this content item
LOCKED_BY_USER_ID NUMBER (15)
User who locked this content item for update
WD_RESTRICTED_FLAG VARCHAR2 (1) Y Whether this content item is private to users who have access to its working directory
BASE_LANGUAGE VARCHAR2 (4) Y The language in which this content item is created and updated
TRANSLATION_REQUIRED_FLAG VARCHAR2 (1) Y Whether translation is required for this content item
OWNER_RESOURCE_ID NUMBER (15)
JTF Resource identifier who owns this content item
OWNER_RESOURCE_TYPE VARCHAR2 (11)
JTF Resource type, can be RS_EMPLOYEE, or RS_GROUP
APPLICATION_ID NUMBER

Application id for decentralized data seeding
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ENCRYPT_FLAG VARCHAR2 (1)
Content type status. Values are Active, Inactive
ORIG_SYSTEM_REFERENCE_ID NUMBER

Security Group Identifier.
ORIG_SYSTEM_REFERENCE_CODE VARCHAR2 (100)
Content item reference code
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_CONTENT_ITEM_NODES stores information about under which directory node a content item
resides. Any content item can belong to only one working directory, however, it can
belong to mutiple publishing directories.

Indexes
Index Type Tablespace Column
IBC_CONTENT_ITEM_NODES_U1 UNIQUE APPS_TS_SEED CONTENT_ITEM_NODE_ID
IBC_CONTENT_ITEM_NODES_U2 UNIQUE APPS_TS_SEED DIRECTORY_NODE_ID
CONTENT_ITEM_ID
IBC_CONTENT_ITEM_NODES_N1 NONUNIQUE APPS_TS_SEED CONTENT_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
CONTENT_ITEM_NODE_ID NUMBER
Y Content item node unique identifier
CONTENT_ITEM_ID NUMBER
Y Content item identifier
DIRECTORY_NODE_ID NUMBER
Y Directory node identifier
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.

[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
Comments

IBC_CONTENT_TYPES_B stores abstract information about a group of similar content items. A content type can have many instances, called content items, which all bide to the definition of the content type.

Indexes
Index Type Tablespace Column
IBC_CONTENT_TYPES_B_U1 UNIQUE APPS_TS_TX_IDX CONTENT_TYPE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code Unique Identifier
CONTENT_TYPE_STATUS VARCHAR2 (30) Y Content type status. Values are Active, Inactive
APPLICATION_ID NUMBER

Application id for decentralized data seeding
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
OWNER_FND_USER_ID NUMBER

Standard Concurrent Program column
ENCRYPT_FLAG VARCHAR2 (1)
Content type status. Values are Active, Inactive
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_CONTENT_TYPES_TL stores translated information about content types.

Indexes
Index Type Tablespace Column
IBC_CONTENT_TYPES_TL_U1 UNIQUE APPS_TS_TX_IDX CONTENT_TYPE_CODE
LANGUAGE
ZD_EDITION_NAME
IBC_CONTENT_TYPES_TL_FN1 NONUNIQUE APPS_TS_TX_IDX SYS_NC00012$
Columns
Name Datatype Length Mandatory Comments
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code
CONTENT_TYPE_NAME VARCHAR2 (240) Y Name of the Content type
DESCRIPTION VARCHAR2 (2000)
Description of the content type
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_DIRECTORY_NODES_B defines all directory nodes. A directory node can have sub directories,
content items, or both.

Indexes
Index Type Tablespace Column
IBC_DIRECTORY_NODES_B_U1 UNIQUE APPS_TS_TX_IDX DIRECTORY_NODE_ID
ZD_EDITION_NAME
IBC_DIRECTORY_NODES_B_U2 UNIQUE APPS_TS_TX_IDX DIRECTORY_PATH
NODE_TYPE
ZD_EDITION_NAME
IBC_DIRECTORY_NODES_B_N1 NONUNIQUE APPS_TS_TX_IDX NODE_TYPE
Columns
Name Datatype Length Mandatory Comments
DIRECTORY_NODE_CODE VARCHAR2 (100) Y Directory node code
DIRECTORY_NODE_ID NUMBER
Y Directory node identifier
NODE_TYPE VARCHAR2 (30) Y Whether this node is a working directory or publish library
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
NODE_STATUS VARCHAR2 (30)
Whether this node is a working directory or publish library
DIRECTORY_PATH VARCHAR2 (3175)
Whether this node is a working directory or publish library
AVAILABLE_DATE DATE

Standard Who column
EXPIRATION_DATE DATE

Standard Who column
HIDDEN_FLAG VARCHAR2 (1)
Identifies whether the current folder is hidden or not.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_DIRECTORY_NODES_TL stores translated information about directory nodes

Indexes
Index Type Tablespace Column
IBC_DIRECTORY_NODES_TL_U1 UNIQUE APPS_TS_TX_IDX DIRECTORY_NODE_ID
LANGUAGE
ZD_EDITION_NAME
IBC_DIRECTORY_NODES_TL_FN1 NONUNIQUE APPS_TS_TX_IDX SYS_NC00012$
Columns
Name Datatype Length Mandatory Comments
DIRECTORY_NODE_ID NUMBER
Y Directory node identifier
DIRECTORY_NODE_NAME VARCHAR2 (240) Y Name of this directory node
DESCRIPTION VARCHAR2 (2000)
Description of this directory node
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_DIRECTORY_NODE_RELS store relationship information between parent and child directory nodes.

Indexes
Index Type Tablespace Column
IBC_DIRECTORY_NODE_RELS_U1 UNIQUE APPS_TS_TX_IDX DIRECTORY_NODE_REL_ID
ZD_EDITION_NAME
IBC_DIRECTORY_NODE_RELS_U2 UNIQUE APPS_TS_TX_IDX CHILD_DIR_NODE_ID
ZD_EDITION_NAME
IBC_DIRECTORY_NODE_RELS_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_DIR_NODE_ID
Columns
Name Datatype Length Mandatory Comments
DIRECTORY_NODE_REL_ID NUMBER
Y Directory node relations unique identifier
CHILD_DIR_NODE_ID NUMBER
Y Child directory node identifier
PARENT_DIR_NODE_ID NUMBER
Y Parent directory node identifier
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

Permissions given for a particular object.

Indexes
Index Type Tablespace Column
IBC_GRANTS_N01 NONUNIQUE APPS_TS_TX_IDX OBJECT_ID
GRANT_GROUP_ID
PERMISSION_CODE
ACTION
IBC_GRANTS_N02 NONUNIQUE APPS_TS_TX_IDX GRANT_GROUP_ID
OBJECT_ID
ACTION
Columns
Name Datatype Length Mandatory Comments
GRANT_ID NUMBER
Y Grants unique identifier
OBJECT_ID NUMBER
Y Permission's Object Type. Reference object_id in FND_OBJECTS
PERMISSION_CODE VARCHAR2 (30) Y It needs to be defined as a value for the lookup type defined in IBC_OBJECT_PERMISSIONS for specific object id.
GRANTEE_USER_ID NUMBER

Reference to FND_USER. User who receives the grant. If GRANTEE_USER_ID has a value then GRANTEE_RESOURCE_ID and GRANTEE_RESOURCE_TYPE must be empty.
GRANTEE_RESOURCE_ID NUMBER

GRANTEE_RESOURCE_ID and GRANTEE_RESOURCE_TYPE make reference to JTF_RS_ALL_RESOURCES_VL. They identify the resource receiving the grant.
GRANTEE_RESOURCE_TYPE VARCHAR2 (30)
Grantee Resource Type
GRANT_GROUP_ID NUMBER
Y Link to the group of grants (IBC_GRANT_GROUPS)
ACTION VARCHAR2 (30) Y Grant Action. Valid values are "ALLOW" or "RESTRICT".
GRANT_LEVEL NUMBER
Y Grant's level of inheritance. A value of zero (0) means that the grant was given at current level.
CASCADE_FLAG VARCHAR2 (1) Y Flag to signal whether current grant needs to be cascaded through the inheritance tree. Valid values are Y or N.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Security Group Identifier.

[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
Comments

Table for group of grants. A set of grants, given at a specific level or inherited, that needs to be addressed as a unit is considered a group.

Columns
Name Datatype Length Mandatory Comments
GRANT_GROUP_ID NUMBER
Y Grant Groups unique identifier
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.

[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
Comments

IBC_LABELS_B defines labels which can be used by release management to control the version
of any content item to be delivered at runtime.

Indexes
Index Type Tablespace Column
IBC_LABELS_B_U1 UNIQUE APPS_TS_SEED LABEL_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
LABEL_CODE VARCHAR2 (100) Y Label code
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_LABELS_TL store translated information about labels.

Indexes
Index Type Tablespace Column
IBC_LABELS_TL_U1 UNIQUE APPS_TS_SEED LABEL_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
LABEL_CODE VARCHAR2 (100) Y Label code
LABEL_NAME VARCHAR2 (240) Y Name of the Label
DESCRIPTION VARCHAR2 (2000)
Description of the Label
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

Table to map an object instance to a particular grant group.

Indexes
Index Type Tablespace Column
IBC_OBJECT_GRANT_GROUPS_U01 UNIQUE APPS_TS_TX_IDX GRANT_GROUP_ID
OBJECT_GRANT_GROUP_ID
IBC_OBJECT_GRANT_GROUPS_U02 UNIQUE APPS_TS_TX_IDX OBJECT_GRANT_GROUP_ID
INSTANCE_PK1_VALUE
INSTANCE_PK2_VALUE
IBC_OBJECT_GRANT_GROUPS_U03 UNIQUE APPS_TS_TX_IDX OBJECT_ID
INSTANCE_PK1_VALUE
INSTANCE_PK2_VALUE
IBC_OBJECT_GRANT_GROUPS_N01 NONUNIQUE APPS_TS_TX_IDX OBJECT_ID
GRANT_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_GRANT_GROUP_ID NUMBER
Y Object Grant Groups unique identifier
GRANT_GROUP_ID NUMBER
Y References the group of grants in (IBC_GRANT_GROUPS)
OBJECT_ID NUMBER
Y References FND_OBJECTS. It identifies object type
INHERITED_FLAG VARCHAR2 (1) Y Indicates whether grants for this particular group are shared with container or not. Value must be Y or N.
INHERITED_FROM NUMBER

Self-Reference link. It points to the row which grants are being inherited from.
INSTANCE_PK1_VALUE VARCHAR2 (30) Y Object instance primary key value
INSTANCE_PK2_VALUE VARCHAR2 (30)
Object instance primary key value
INSTANCE_PK3_VALUE VARCHAR2 (30)
Object instance primary key value
INSTANCE_PK4_VALUE VARCHAR2 (30)
Object instance primary key value
INSTANCE_PK5_VALUE VARCHAR2 (30)
Object instance primary key value
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
INHERITANCE_TYPE VARCHAR2 (30)
Object instance primary key value

[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
Comments

Table to define the lookup type which holds the valid permission codes for a particular object type.

Indexes
Index Type Tablespace Column
IBC_OBJECT_PERMISSIONS_U01 UNIQUE APPS_TS_SEED OBJECT_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER
Y References FND_OBJECTS. It identifies object type.
PERMISSIONS_LOOKUP_TYPE VARCHAR2 (30) Y Lookup Type to specify valid permission codes for grants to a particular object.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

Renditions support multiple file types for a content item's attachment.
Examples are:
1. A white paper content item could have attachment with file types (doc, pdf, txt and html)
2. An image content item could have attachment with file types (gif, jpeg, bmp)

Indexes
Index Type Tablespace Column
IBC_RENDITIONS_U1 UNIQUE APPS_TS_TX_IDX RENDITION_ID
ZD_EDITION_NAME
IBC_RENDITIONS_U2 UNIQUE APPS_TS_TX_IDX CITEM_VERSION_ID
LANGUAGE
MIME_TYPE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
RENDITION_ID NUMBER
Y Unique Identifier for a Rendition.
CITEM_VERSION_ID NUMBER
Y References CITEM_VERSIONS. It identifies the Content Items Version for which this Rendition is Stored.
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
FILE_ID NUMBER
Y Points to the BLOB in FND_LOBS which stores the attachment file for this content item version and mime type.
FILE_NAME VARCHAR2 (256) Y File name of the attachment
MIME_TYPE VARCHAR2 (30)
Mime Type of the Attachment File
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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
Comments

IBC_STYLESHEETS stores the associated stylesheets for a given content type.
Any stylesheet is a content item of STYLESHEET content type. A stylesheet can
be used to render the content items of the content type this stylesheet is
associated with.

Indexes
Index Type Tablespace Column
IBC_STYLESHEETS_U1 UNIQUE APPS_TS_SEED CONTENT_ITEM_ID
CONTENT_TYPE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code
CONTENT_ITEM_ID NUMBER
Y Content item identifier for the associated stylesheet
DEFAULT_STYLESHEET_FLAG VARCHAR2 (1) Y Whether this is a Default StyleSheet.Default is 'F'. Stores 'T' or 'F'
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ZD_EDITION_NAME VARCHAR2 (30) Y

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ASSOCIATION_ID NUMBER
Y
CONTENT_ITEM_ID NUMBER
Y
ASSOCIATION_TYPE_CODE VARCHAR2 (100) Y
ASSOCIATED_OBJECT_VAL1 VARCHAR2 (254) Y
ASSOCIATED_OBJECT_VAL2 VARCHAR2 (254)
ASSOCIATED_OBJECT_VAL3 VARCHAR2 (254)
ASSOCIATED_OBJECT_VAL4 VARCHAR2 (254)
ASSOCIATED_OBJECT_VAL5 VARCHAR2 (254)
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ASSOCIATION_TYPE_CODE VARCHAR2 (100) Y
CALL_BACK_PKG VARCHAR2 (50)
SEARCH_PAGE VARCHAR2 (2000)
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

ASSOCIATION_TYPE_NAME VARCHAR2 (240) Y
DESCRIPTION VARCHAR2 (2000)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ATTRIBUTE_TYPE_CODE VARCHAR2 (100) Y
CONTENT_TYPE_CODE VARCHAR2 (100) Y
CONTENT_TYPE_NAME VARCHAR2 (240) Y
FLEX_VALUE_SET_ID NUMBER

DISPLAY_ORDER NUMBER

DATA_TYPE_CODE VARCHAR2 (30) Y
DATA_LENGTH NUMBER (15)
MIN_INSTANCES NUMBER
Y
MAX_INSTANCES NUMBER

REFERENCE_CODE VARCHAR2 (100)
DEFAULT_VALUE VARCHAR2 (240)
UPDATEABLE_FLAG VARCHAR2 (1) Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

ATTRIBUTE_TYPE_NAME VARCHAR2 (240) Y
DESCRIPTION VARCHAR2 (2000)

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
AUDIT_LOG_ID NUMBER
Y Audit log unique identifier
ACTIVITY VARCHAR2 (100) Y Activity name
USER_ID NUMBER (15) Y User who performed the activity
TIME_STAMP DATE
Y Date and time the activity is performed
OBJECT_TYPE VARCHAR2 (30) Y OCM object type the activity is performed on
PARENT_VALUE VARCHAR2 (254)
Parent Value
OBJECT_VALUE1 VARCHAR2 (254) Y Object value 1 to identify the OCM object
OBJECT_VALUE2 VARCHAR2 (254)
Object value 2 to identify the OCM object
OBJECT_VALUE3 VARCHAR2 (254)
Object value 3 to identify the OCM object
OBJECT_VALUE4 VARCHAR2 (254)
Object value 4 to identify the OCM object
OBJECT_VALUE5 VARCHAR2 (254)
Object value 5 to identify the OCM object
DESCRIPTION VARCHAR2 (2000)
Description of Audit Log
INTERNAL_FLAG VARCHAR2 (1)
APPLICATION_ID NUMBER

CREATION_DATE DATE
Y Standard who column - date when this row was created.
OBJECT_STATUS VARCHAR2 (30)
AUDIT_MESSAGE VARCHAR2 (4000)
EXTRA_INFO1 VARCHAR2 (4000)
EXTRA_INFO2 VARCHAR2 (4000)
EXTRA_INFO3 VARCHAR2 (4000)
EXTRA_INFO4 VARCHAR2 (4000)
EXTRA_INFO5 VARCHAR2 (4000)

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CITEM_ID NUMBER
Y Content item Unique identifier
REF_CODE VARCHAR2 (100)
Content item reference code
CTYPE_CODE VARCHAR2 (100) Y Content type code for this content item references IBC_CONTENT_TYPE_B
DIR_NODE_ID NUMBER
Y Directory node identifier to which this content item belongs
PARENT_ID NUMBER

Parent Item Identifier
LOCKED_BY NUMBER (15)
User who locked this content item for update
WD_RESTRICTED VARCHAR2 (1) Y Whether this content item is private to users who have access to its working directory
TRANS_REQUIRED VARCHAR2 (1) Y Whether translation is required for this content item
OWNER NUMBER (15)
JTF Resource identifier who owns this content item
OWNER_TYPE VARCHAR2 (11)
JTF Resource type, can be RS_EMPLOYEE, or RS_GROUP
ITEM_STATUS VARCHAR2 (30)
Status of this content item
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
CTYPE_NAME VARCHAR2 (240) Y Name of the Content type
DIR_NODE_CODE VARCHAR2 (100) Y Directory node code
DIR_NODE_NAME VARCHAR2 (240) Y Name of this directory node
CITEM_VER_ID NUMBER
Y Citem Versions unique identifier
VERSION NUMBER (15) Y Version number of the content item
VERSION_STATUS VARCHAR2 (30)
Status of this content item version.
START_DATE DATE

Effective Start date of this version
END_DATE DATE

Effective End date of this version
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
ATTRIB_FID NUMBER

All primitive attribute values are stored as a XML bundle in FND_LOBS. This column points to the BLOB
ATTACH_FID NUMBER

Points to the BLOB in FND_LOBS which stores the attachment file for this content item version
NAME VARCHAR2 (240) Y Content item name for this version
ATTACH_FILE_NAME VARCHAR2 (256)
File name of the attachment
DESCRIPTION VARCHAR2 (2000)
Content item description for this version
DEFAULT_RENDITION_MIME_TYPE VARCHAR2 (30)
Default Rendition Mime Type for this Content Item Version
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CITEM_BASE_LANGUAGE VARCHAR2 (4) Y The language in which this content item is created and updated
NODE_STATUS VARCHAR2 (30)
Language data in this row is currently of
DIRECTORY_PATH VARCHAR2 (3175)
Standard Who column
LIVE_CITEM_VER_ID NUMBER

Standard Who column
CITEM_ENCRYPT_FLAG VARCHAR2 (1)
Standard Who column
CITEM_TRANSLATION_STATUS VARCHAR2 (30)
Standard Who column
CITEM_CREATED_BY NUMBER
Y Standard Who column
CITEM_CREATION_DATE DATE
Y The language in which this content item is created and updated
CITEM_LAST_UPDATED_BY NUMBER
Y Language data in this row is currently of
CITEM_LAST_UPDATE_DATE DATE
Y Standard Who column
GUID ROWID (10)
Standard Who column

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50)
CITEM_VERSION_ID NUMBER

FILE_ID NUMBER

FILE_TYPE CHAR (6)
FILE_NAME VARCHAR2 (256)
FILE_CONTENT_TYPE VARCHAR2 (256)
LANGUAGE VARCHAR2 (4)

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LABEL_CODE VARCHAR2 (100) Y Label code
CONTENT_ITEM_ID NUMBER
Y Content item Unique identifier
CONTENT_ITEM_STATUS VARCHAR2 (30)
Status of this content item
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code for this content item references IBC_CONTENT_TYPE_B
ITEM_REFERENCE_CODE VARCHAR2 (100)
Content item reference code
DIRECTORY_NODE_ID NUMBER
Y Directory node identifier to which this content item belongs
PARENT_ITEM_ID NUMBER

Parent Item Identifier
LIVE_CITEM_VERSION_ID NUMBER

Live version of this content item
LOCKED_BY_USER_ID NUMBER (15)
User who locked this content item for update
WD_RESTRICTED_FLAG VARCHAR2 (1) Y Whether this content item is private to users who have access to its working directory
BASE_LANGUAGE VARCHAR2 (4) Y The language in which this content item is created and updated
TRANSLATION_REQUIRED_FLAG VARCHAR2 (1) Y Whether translation is required for this content item
OWNER_RESOURCE_ID NUMBER (15)
JTF Resource identifier who owns this content item
OWNER_RESOURCE_TYPE VARCHAR2 (11)
JTF Resource type, can be RS_EMPLOYEE, or RS_GROUP
APPLICATION_ID NUMBER

Application id for decentralized data seeding
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
CITEM_VERSION_ID NUMBER
Y Citem Versions unique identifier
VERSION_NUMBER NUMBER (15) Y Version number of the content item
CITEM_VERSION_STATUS VARCHAR2 (30)
Status of this content item version.
VERSION_CREATED_BY NUMBER
Y Standard Who column
VERSION_CREATION_DATE DATE
Y Standard Who column
VERSION_LAST_UPDATED_BY NUMBER
Y Standard Who column
VERSION_LAST_UPDATE_DATE DATE
Y Standard Who column
VERSION_LAST_UPDATE_LOGIN NUMBER

Standard Who column
START_DATE DATE

Effective Start date of this version
END_DATE DATE

Effective End date of this version
CONTENT_ITEM_NAME VARCHAR2 (240) Y Content item name for this version
DESCRIPTION VARCHAR2 (2000)
Content item description for this version
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
CONTENT_TYPE_NAME VARCHAR2 (240) Y Name of the Content type
ATTRIBUTE_FILE_ID NUMBER

All primitive attribute values are stored as a XML bundle in FND_LOBS. This column points to the BLOB
ATTACHMENT_FILE_ID NUMBER

Points to the BLOB in FND_LOBS which stores the attachment file for this content item version
ATTACHMENT_FILE_NAME VARCHAR2 (256)
File name of the attachment
SOURCE_LANG VARCHAR2 (4) Y Language data in this row is currently of

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CONTENT_ITEM_ID NUMBER
Y
ITEM_REFERENCE_CODE VARCHAR2 (100)
CONTENT_TYPE_CODE VARCHAR2 (100) Y
PARENT_ITEM_ID NUMBER

CONTENT_TYPE_NAME VARCHAR2 (240) Y
WD_RESTRICTED_FLAG VARCHAR2 (1) Y
TRANSLATION_REQUIRED_FLAG VARCHAR2 (1) Y
OWNER_RESOURCE_ID NUMBER (15)
OWNER_RESOURCE_TYPE VARCHAR2 (11)
CITEM_VERSION_ID NUMBER
Y
VERSION_NUMBER NUMBER (15) Y
CITEM_VERSION_STATUS VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

LANGUAGE VARCHAR2 (4) Y
ATTRIBUTE_FILE_ID NUMBER

ATTACHMENT_FILE_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER (9) Y
ATTACHMENT_FILE_NAME VARCHAR2 (256)
CONTENT_ITEM_NAME VARCHAR2 (240) Y
DESCRIPTION VARCHAR2 (2000)
SOURCE_LANG VARCHAR2 (4) Y

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PERMISSION_CODE VARCHAR2 (30)
Permission Code
CONTENT_ITEM_ID NUMBER

Content Item Unique Identifier
ITEM_REFERENCE_CODE VARCHAR2 (100)
Item Reference Code
CONTENT_TYPE_CODE VARCHAR2 (100)
Content Type Unique Identifier
DIRECTORY_NODE_ID NUMBER

Directory Node Unique Identifier
PARENT_ITEM_ID NUMBER

Unique Identifier for Parent Content Item
LIVE_CITEM_VERSION_ID NUMBER

Unique Identifier for Live Content Item Version
CONTENT_ITEM_STATUS VARCHAR2 (30)
Status of the Content Item
LOCKED_BY_USER_ID NUMBER (15)
Unique Identifier in FND_USER(User_id) which has locked this Content Item
WD_RESTRICTED_FLAG VARCHAR2 (1)
Working directory restricted Flag
BASE_LANGUAGE VARCHAR2 (4)
Base language of the Content Item
TRANSLATION_REQUIRED_FLAG VARCHAR2 (1)
Whether Translation is required or not
OWNER_RESOURCE_ID NUMBER (15)
Owner or Resource of the Content Item.Unique Identifier references FND_USER or JTF_RESOURCES
OWNER_RESOURCE_TYPE VARCHAR2 (11)
Resource type in JTF_RESOURCES
APPLICATION_ID NUMBER

Application Unique Identifier
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
ENCRYPT_FLAG VARCHAR2 (1)
Encryption Flag
USER_ID NUMBER

User Unique Identifier
SECURITY_FLAG CHAR (1)
Security Flag

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CITEM_VERSION_ID NUMBER
Y
CONTENT_ITEM_ID NUMBER
Y
VERSION_NUMBER NUMBER (15) Y
CITEM_VERSION_STATUS VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

ATTRIBUTE_FILE_ID NUMBER

ATTACHMENT_FILE_ID NUMBER

ATTACHMENT_ATTRIBUTE_CODE VARCHAR2 (100)
CONTENT_ITEM_NAME VARCHAR2 (240) Y
ATTACHMENT_FILE_NAME VARCHAR2 (256)
DESCRIPTION VARCHAR2 (2000)
DEFAULT_RENDITION_MIME_TYPE VARCHAR2 (30)
CITEM_TRANSLATION_STATUS VARCHAR2 (30)

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
COMPOUND_RELATION_ID NUMBER
Y
CONTENT_ITEM_ID NUMBER
Y
ATTRIBUTE_TYPE_CODE VARCHAR2 (100) Y
CITEM_VERSION_ID NUMBER
Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CONTENT_ITEM_ID NUMBER
Y Content item Unique identifier
CONTENT_ITEM_STATUS VARCHAR2 (30)
Status of this content item
CONTENT_TYPE_CODE VARCHAR2 (100) Y Content type code for this content item references IBC_CONTENT_TYPE_B
ITEM_REFERENCE_CODE VARCHAR2 (100)
Content item reference code
DIRECTORY_NODE_ID NUMBER
Y Directory node identifier to which this content item belongs
PARENT_ITEM_ID NUMBER

Parent Item Identifier
LIVE_CITEM_VERSION_ID NUMBER

Live version of this content item
LOCKED_BY_USER_ID NUMBER (15)
User who locked this content item for update
WD_RESTRICTED_FLAG VARCHAR2 (1) Y Whether this content item is private to users who have access to its working directory
BASE_LANGUAGE VARCHAR2 (4) Y The language in which this content item is created and updated
TRANSLATION_REQUIRED_FLAG VARCHAR2 (1) Y Whether translation is required for this content item
OWNER_RESOURCE_ID NUMBER (15)
JTF Resource identifier who owns this content item
OWNER_RESOURCE_TYPE VARCHAR2 (11)
JTF Resource type, can be RS_EMPLOYEE, or RS_GROUP
APPLICATION_ID NUMBER

Application id for decentralized data seeding
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number for locking.
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
CITEM_VERSION_ID NUMBER
Y Citem Versions unique identifier
VERSION_NUMBER NUMBER (15) Y Version number of the content item
CITEM_VERSION_STATUS VARCHAR2 (30)
Status of this content item version.
VERSION_CREATED_BY NUMBER
Y Standard Who column
VERSION_CREATION_DATE DATE
Y Standard Who column
VERSION_LAST_UPDATED_BY NUMBER
Y Standard Who column
VERSION_LAST_UPDATE_DATE DATE
Y Standard Who column
VERSION_LAST_UPDATE_LOGIN NUMBER

Standard Who column
START_DATE DATE

Effective Start date of this version
END_DATE DATE

Effective End date of this version
CONTENT_ITEM_NAME VARCHAR2 (240) Y Content item name for this version
DESCRIPTION VARCHAR2 (2000)
Content item description for this version
LANGUAGE VARCHAR2 (4) Y Language this row is storing data for
CONTENT_TYPE_NAME VARCHAR2 (240) Y Name of the Content type

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTENT_ITEM_NODE_ID NUMBER
Y
CONTENT_ITEM_ID NUMBER
Y
DIRECTORY_NODE_ID NUMBER
Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTENT_TYPE_CODE VARCHAR2 (100) Y
CONTENT_TYPE_STATUS VARCHAR2 (30) Y
APPLICATION_ID NUMBER

CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
OWNER_FND_USER_ID NUMBER

PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

CONTENT_TYPE_NAME VARCHAR2 (240) Y
DESCRIPTION VARCHAR2 (2000)
ENCRYPT_FLAG VARCHAR2 (1)

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
DIRECTORY_NODE_ID NUMBER
Y
DIRECTORY_NODE_CODE VARCHAR2 (100) Y
NODE_TYPE VARCHAR2 (30) Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

DIRECTORY_NODE_NAME VARCHAR2 (240) Y
DESCRIPTION VARCHAR2 (2000)
DIRECTORY_PATH VARCHAR2 (3175)
NODE_STATUS VARCHAR2 (30)
AVAILABLE_DATE DATE

EXPIRATION_DATE DATE

HIDDEN_FLAG VARCHAR2 (1)

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
DIRECTORY_NODE_REL_ID NUMBER
Y
CHILD_DIR_NODE_ID NUMBER
Y
PARENT_DIR_NODE_ID NUMBER
Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y

[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

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
LABEL_CODE VARCHAR2 (100) Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

LABEL_NAME VARCHAR2 (240) Y
DESCRIPTION VARCHAR2 (2000)

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y
LOOKUP_CODE VARCHAR2 (30) Y
MEANING VARCHAR2 (80) Y
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CITEM_VERSION_ID VARCHAR2 (240)
Content Item version identifier
ITEM_KEY VARCHAR2 (240)
Item Key
USER_NAME VARCHAR2 (320) Y User Name
NOTIFICATION_BEGIN_DATE DATE

Notification date
RELATES_TO VARCHAR2 (80) Y Relates to Item or Translation approval
ACTIVITY_NAME VARCHAR2 (30)
Work Flow activity name
LANGUAGE VARCHAR2 (240)
Language
ROLE_NAME VARCHAR2 (320) Y Name of the workflow role

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
CITEM_VERSION_ID VARCHAR2 (240)
Item version identifier
ITEM_KEY VARCHAR2 (240)
Item Key
USER_NAME VARCHAR2 (320) Y User Name
NOTIFICATION_BEGIN_DATE DATE

Notification begin date

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTENT_TYPE_CODE VARCHAR2 (100) Y
CONTENT_ITEM_ID NUMBER
Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DEFAULT_STYLESHEET_FLAG VARCHAR2 (1) Y
OBJECT_VERSION_NUMBER NUMBER (9) Y

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DIRECTORY_NODE_REL_ID NUMBER
Y
PARENT_DIR_NODE_ID NUMBER
Y
CHILD_DIR_NODE_ID NUMBER
Y
DIRECTORY_NODE_CODE VARCHAR2 (100) Y
NODE_TYPE VARCHAR2 (30) Y
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9) Y
SECURITY_GROUP_ID NUMBER

DIRECTORY_NODE_NAME VARCHAR2 (240) Y
DESCRIPTION VARCHAR2 (2000)

[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