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.
Description: | IBC_ASSOCIATIONS stores the association between content items and other application objects. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_ASSOCIATIONS.CONTENT_ITEM_ID | IBC_CONTENT_ITEMS |
IBC_ASSOCIATIONS.ASSOCIATION_TYPE_CODE | IBC_ASSOCIATION_TYPES_B |
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.
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 |
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 |
IBC.IBC_ASSOCIATIONS does not reference any database object
IBC.IBC_ASSOCIATIONS is referenced by following:
Description: | IBC_ASSOCIATION_TYPES_B allows applications to register an association type code for any type ofapplication objects |
---|
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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_ASSOCIATION_TYPES_B_U1 | UNIQUE | APPS_TS_SEED |
ASSOCIATION_TYPE_CODE
ZD_EDITION_NAME |
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 |
IBC.IBC_ASSOCIATION_TYPES_B does not reference any database object
IBC.IBC_ASSOCIATION_TYPES_B is referenced by following:
Description: | IBC_ASSOCIATION_TYPES_TL stores translated information about association types in IBC_ASSOCIATION_TYPES_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_ASSOCIATION_TYPES_TL.ASSOCIATION_TYPE_CODE | IBC_ASSOCIATION_TYPES_B |
IBC_ASSOCIATION_TYPES_TL stores translated information about association types in IBC_ASSOCIATION_TYPES_B.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_ASSOCIATION_TYPES_TL_U1 | UNIQUE | APPS_TS_SEED |
ASSOCIATION_TYPE_CODE
LANGUAGE ZD_EDITION_NAME |
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 |
IBC.IBC_ASSOCIATION_TYPES_TL does not reference any database object
IBC.IBC_ASSOCIATION_TYPES_TL is referenced by following:
Description: | IBC_ATTRIBUTE_TYPES_B defines all the attribute types for a given content type |
---|
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 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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_ATTRIBUTE_TYPES_B_U1 | UNIQUE | APPS_TS_TX_IDX |
CONTENT_TYPE_CODE
ATTRIBUTE_TYPE_CODE ZD_EDITION_NAME |
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 |
IBC.IBC_ATTRIBUTE_TYPES_B does not reference any database object
IBC.IBC_ATTRIBUTE_TYPES_B is referenced by following:
Description: | IBC_ATTRIBUTE_TYPES_TL stores translated information about attribute types defined in IBC_ATTRIBUTE_TYPES_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_ATTRIBUTE_TYPES_TL.ATTRIBUTE_TYPE_CODE
IBC_ATTRIBUTE_TYPES_TL.CONTENT_TYPE_CODE |
IBC_ATTRIBUTE_TYPES_B |
IBC_ATTRIBUTE_TYPES_TL stores translated information about attribute types defined in IBC_ATTRIBUTE_TYPES_B.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_ATTRIBUTE_TYPES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_TYPE_CODE
CONTENT_TYPE_CODE LANGUAGE ZD_EDITION_NAME |
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 |
IBC.IBC_ATTRIBUTE_TYPES_TL does not reference any database object
IBC.IBC_ATTRIBUTE_TYPES_TL is referenced by following:
Description: | IBC_AUDIT_LOGS stores all the actions performed on any OCM object |
---|
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.
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 |
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 |
IBC.IBC_AUDIT_LOGS does not reference any database object
IBC.IBC_AUDIT_LOGS is referenced by following:
Description: | IBC_CITEM_VERSIONS_B stores all the versions of a content item |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_CITEM_VERSIONS_B.CONTENT_ITEM_ID | IBC_CONTENT_ITEMS |
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 |
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.
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 |
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 |
IBC.IBC_CITEM_VERSIONS_B does not reference any database object
IBC.IBC_CITEM_VERSIONS_B is referenced by following:
Description: | IBC_CITEM_VERSIONS_TL stores language striped information about content item versions defined in IBC_CITEM_VERSIONS_B. |
---|
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 Key Column | Foreign Table |
---|---|
PRP_COMP_STYLE_CTNTVERS.CITEM_VERSION_ID
PRP_COMP_STYLE_CTNTVERS.LANGUAGE |
IBC_CITEM_VERSIONS_TL |
IBC_CITEM_VERSIONS_TL stores language striped information about content item versions defined
in IBC_CITEM_VERSIONS_B.
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 |
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 |
IBC.IBC_CITEM_VERSIONS_TL does not reference any database object
IBC.IBC_CITEM_VERSIONS_TL is referenced by following:
Description: | IBC_CITEM_VERSION_LABELS stores the association between a label and the version of any content item. |
---|
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 |
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.
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 |
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 |
IBC.IBC_CITEM_VERSION_LABELS does not reference any database object
IBC.IBC_CITEM_VERSION_LABELS is referenced by following:
Description: | IBC_COMPOUND_RELATIONS stores the component content item id for each attribute of the compound item that is of data type component. |
---|
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 |
IBC_COMPOUND_RELATIONS stores the component content item id for each attribute of the compound item that is of data type component.
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 |
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 |
IBC.IBC_COMPOUND_RELATIONS does not reference any database object
IBC.IBC_COMPOUND_RELATIONS is referenced by following:
Description: | IBC_CONTENT_ITEMS stores non version or language specific information about content items |
---|
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 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 |
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
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 |
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 |
IBC.IBC_CONTENT_ITEMS does not reference any database object
IBC.IBC_CONTENT_ITEMS is referenced by following:
Description: | IBC_CONTENT_ITEM_NODES stores information about under which directory node a content itemresides. |
---|
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 |
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.
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 |
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. |
IBC.IBC_CONTENT_ITEM_NODES does not reference any database object
IBC.IBC_CONTENT_ITEM_NODES is referenced by following:
Description: | IBC_CONTENT_TYPES_B stores abstract information about a group of similar content items |
---|
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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_CONTENT_TYPES_B_U1 | UNIQUE | APPS_TS_TX_IDX |
CONTENT_TYPE_CODE
ZD_EDITION_NAME |
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 |
IBC.IBC_CONTENT_TYPES_B does not reference any database object
IBC.IBC_CONTENT_TYPES_B is referenced by following:
Description: | IBC_CONTENT_TYPES_TL stores translated information about content types. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_CONTENT_TYPES_TL.CONTENT_TYPE_CODE | IBC_CONTENT_TYPES_B |
IBC_CONTENT_TYPES_TL stores translated information about content types.
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$ |
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 |
IBC.IBC_CONTENT_TYPES_TL does not reference any database object
IBC.IBC_CONTENT_TYPES_TL is referenced by following:
Description: | IBC_DIRECTORY_NODES_B defines all directory nodes. |
---|
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 |
IBC_DIRECTORY_NODES_B defines all directory nodes. A directory node can have sub directories,
content items, or both.
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 |
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 |
IBC.IBC_DIRECTORY_NODES_B does not reference any database object
IBC.IBC_DIRECTORY_NODES_B is referenced by following:
Description: | IBC_DIRECTORY_NODES_TL stores translated information about directory nodes |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_DIRECTORY_NODES_TL.DIRECTORY_NODE_ID | IBC_DIRECTORY_NODES_B |
IBC_DIRECTORY_NODES_TL stores translated information about directory nodes
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$ |
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 |
IBC.IBC_DIRECTORY_NODES_TL does not reference any database object
IBC.IBC_DIRECTORY_NODES_TL is referenced by following:
Description: | IBC_DIRECTORY_NODE_RELS store relationship information between parent and child directory nodes. |
---|
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 |
IBC_DIRECTORY_NODE_RELS store relationship information between parent and child directory nodes.
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 |
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 |
IBC.IBC_DIRECTORY_NODE_RELS does not reference any database object
IBC.IBC_DIRECTORY_NODE_RELS is referenced by following:
Description: | This table stores all Permissions given for a particular object. |
---|
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 |
Permissions given for a particular object.
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 |
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. |
IBC.IBC_GRANTS does not reference any database object
IBC.IBC_GRANTS is referenced by following:
Description: | This Table stroes a group of grants |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_GRANTS.GRANT_GROUP_ID | IBC_GRANT_GROUPS |
IBC_OBJECT_GRANT_GROUPS.GRANT_GROUP_ID | IBC_GRANT_GROUPS |
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.
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. |
IBC.IBC_GRANT_GROUPS does not reference any database object
IBC.IBC_GRANT_GROUPS is referenced by following:
Description: | IBC_LABELS_B defines labels |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_CITEM_VERSION_LABELS.LABEL_CODE | IBC_LABELS_B |
IBC_LABELS_TL.LABEL_CODE | IBC_LABELS_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_LABELS_B_U1 | UNIQUE | APPS_TS_SEED |
LABEL_CODE
ZD_EDITION_NAME |
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 |
IBC.IBC_LABELS_B does not reference any database object
IBC.IBC_LABELS_B is referenced by following:
Description: | IBC_LABELS_TL store translated information about labels. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_LABELS_TL.LABEL_CODE | IBC_LABELS_B |
IBC_LABELS_TL store translated information about labels.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_LABELS_TL_U1 | UNIQUE | APPS_TS_SEED |
LABEL_CODE
LANGUAGE ZD_EDITION_NAME |
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 |
IBC.IBC_LABELS_TL does not reference any database object
IBC.IBC_LABELS_TL is referenced by following:
Description: | This Table stores mapping of an object instance to a particular grant group. |
---|
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 Key Column | Foreign Table |
---|---|
IBC_OBJECT_GRANT_GROUPS.INHERITED_FROM | IBC_OBJECT_GRANT_GROUPS |
Table to map an object instance to a particular grant group.
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 |
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 |
IBC.IBC_OBJECT_GRANT_GROUPS does not reference any database object
IBC.IBC_OBJECT_GRANT_GROUPS is referenced by following:
Description: | This Table defines the lookup type which holds the valid permission codes for a particular object type |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_OBJECT_PERMISSIONS.OBJECT_ID | FND_OBJECTS |
Table to define the lookup type which holds the valid permission codes for a particular object type.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_OBJECT_PERMISSIONS_U01 | UNIQUE | APPS_TS_SEED |
OBJECT_ID
ZD_EDITION_NAME |
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 |
IBC.IBC_OBJECT_PERMISSIONS does not reference any database object
IBC.IBC_OBJECT_PERMISSIONS is referenced by following:
Description: | This Table stores renditions data to support multiple file types for a content item's attachment. |
---|
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)
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 |
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 |
IBC.IBC_RENDITIONS does not reference any database object
IBC.IBC_RENDITIONS is referenced by following:
Description: | IBC_STYLESHEETS stores the associated stylesheets for a given content type. |
---|
Foreign Key Column | Foreign Table |
---|---|
IBC_STYLESHEETS.CONTENT_ITEM_ID | IBC_CONTENT_ITEMS |
IBC_STYLESHEETS.CONTENT_TYPE_CODE | IBC_CONTENT_TYPES_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IBC_STYLESHEETS_U1 | UNIQUE | APPS_TS_SEED |
CONTENT_ITEM_ID
CONTENT_TYPE_CODE ZD_EDITION_NAME |
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 |
IBC.IBC_STYLESHEETS does not reference any database object
IBC.IBC_STYLESHEETS is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_ASSOCIATIONS_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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) |
APPS.IBC_ASSOCIATION_TYPES_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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) |
APPS.IBC_ATTRIBUTE_TYPES_VL is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.IBC_AUDIT_LOGS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_CITEMS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.IBC_CITEM_DOWNLOAD_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_CITEM_LABELS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_CITEM_LIVE_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_CITEM_PERMISSIONS_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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) |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_COMPOUND_RELATIONS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_CONTENT_ITEMS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_CONTENT_ITEM_NODES_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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) |
MultiLingual view (a language resolved view of the data.)
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) |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_DIRECTORY_NODE_RELS_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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) |
APPS.IBC_LABELS_VL is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_LOOKUPS is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_PENDING_APPROVALS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_PENDING_TRANSLATIONS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.IBC_STYLESHEETS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.IBC_SUB_DIRECTORY_NODES_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |