[Home] [Help] [Dependency Information]
Object Name: | IBC_CITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IBC.IBC_CITEMS_V |
Subobject Name: | |
Status: | VALID |
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 | Yes | Content item Unique identifier | |
REF_CODE | VARCHAR2 | (100) | Content item reference code | |
CTYPE_CODE | VARCHAR2 | (100) | Yes | Content type code for this content item references IBC_CONTENT_TYPE_B |
DIR_NODE_ID | NUMBER | Yes | 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) | Yes | Whether this content item is private to users who have access to its working directory |
TRANS_REQUIRED | VARCHAR2 | (1) | Yes | 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) | Yes | Object version number for locking. |
CTYPE_NAME | VARCHAR2 | (240) | Yes | Name of the Content type |
DIR_NODE_CODE | VARCHAR2 | (100) | Yes | Directory node code |
DIR_NODE_NAME | VARCHAR2 | (240) | Yes | Name of this directory node |
CITEM_VER_ID | NUMBER | Yes | Citem Versions unique identifier | |
VERSION | NUMBER | (15) | Yes | 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) | Yes | 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) | Yes | 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) | Yes | Language data in this row is currently of |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | 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) | Yes | 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 | Yes | Standard Who column | |
CITEM_CREATION_DATE | DATE | Yes | The language in which this content item is created and updated | |
CITEM_LAST_UPDATED_BY | NUMBER | Yes | Language data in this row is currently of | |
CITEM_LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
GUID | ROWID | (10) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CITEM_ID
, REF_CODE
, CTYPE_CODE
, DIR_NODE_ID
, PARENT_ID
, LOCKED_BY
, WD_RESTRICTED
, TRANS_REQUIRED
, OWNER
, OWNER_TYPE
, ITEM_STATUS
, OBJECT_VERSION_NUMBER
, CTYPE_NAME
, DIR_NODE_CODE
, DIR_NODE_NAME
, CITEM_VER_ID
, VERSION
, VERSION_STATUS
, START_DATE
, END_DATE
, LANGUAGE
, ATTRIB_FID
, ATTACH_FID
, NAME
, ATTACH_FILE_NAME
, DESCRIPTION
, DEFAULT_RENDITION_MIME_TYPE
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CITEM_BASE_LANGUAGE
, NODE_STATUS
, DIRECTORY_PATH
, LIVE_CITEM_VER_ID
, CITEM_ENCRYPT_FLAG
, CITEM_TRANSLATION_STATUS
, CITEM_CREATED_BY
, CITEM_CREATION_DATE
, CITEM_LAST_UPDATED_BY
, CITEM_LAST_UPDATE_DATE
, GUID
FROM APPS.IBC_CITEMS_V;
|
|
|