[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBC_BULK_UPLOAD |
|---|---|
| Object Type: | TABLE |
| Owner: | IBC |
| Subobject Name: | |
| Status: | VALID |
Table used by concurrent bulk upload program. All rows for bulkupload are stored in this table and processed.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BULK_UPLOAD_SEQ_NO | NUMBER | Yes | Seq id for record to be processed. | |
| BULK_UPLOAD_ID | NUMBER | Yes | Concurrent program request call id | |
| ZIP_FILE_NAME | VARCHAR2 | (240) | zip file name used to upload contents | |
| REQUEST_ID | NUMBER | Concurrent request id | ||
| PROGRAM_ID | NUMBER | program id submitted the request | ||
| OBJECT_NAME | VARCHAR2 | (240) | original object name to be uploaded | |
| OBJECT_TYPE | VARCHAR2 | (240) | object type to be uploaded | |
| OBJECT_FULL_PATH | VARCHAR2 | (4000) | full path of object | |
| PARENT_FULL_PATH | VARCHAR2 | (4000) | Full path of parent object | |
| OBJECT_PATH | VARCHAR2 | (4000) | Displayed path of object | |
| OBJECT_FLAT_PATH | VARCHAR2 | (4000) | Displayed flat path of object | |
| OBJECT_CREATE_AS | VARCHAR2 | (240) | Object created as name | |
| OBJECT_UPLOAD_AS | VARCHAR2 | (240) | Object to be uploaded as | |
| OBJECT_UPLOAD_OPTION | VARCHAR2 | (240) | Upload option provided or displayed | |
| OBJECT_UPLOAD_OPTION_USED | VARCHAR2 | (240) | Actual upload option used for processing. | |
| OBJECT_ACTUAL_FULL_PATH | VARCHAR2 | (4000) | Actual full path of object | |
| OBJECT_UPLOAD_STATUS | VARCHAR2 | (240) | Displayed upload status as in UI | |
| FILE_EXTENSION | VARCHAR2 | (10) | File extension of attachment if exist | |
| DIRECTORY_NODE_ID | NUMBER | directory node id to which item is uploaded | ||
| MIME_TYPE | VARCHAR2 | (240) | mime type of uploaded content item attachment | |
| OWNER_RESOURCE_ID | NUMBER | owner resource id for content item | ||
| ATTACHMENT_FILE_ID | NUMBER | file id for attachment | ||
| OWNER_RESOURCE_TYPE | VARCHAR2 | (240) | owner resource type | |
| OBJECT_UPLOADED_STATUS | VARCHAR2 | (240) | Status of uploaded item | |
| BASE_LANGUAGE | VARCHAR2 | (240) | base language of uploaded item. | |
| CONTENT_TYPE_CODE | VARCHAR2 | (240) | content type code of uploaded item | |
| CONTENT_ITEM_ID | NUMBER | Id of cuploaded content item | ||
| FILE_UPLOAD_STATUS | VARCHAR2 | (1) | Upload process status for this record | |
| OBJECT_UPLOADED_AS | VARCHAR2 | (240) | Shows if the object uploaded as item or rendition | |
| FILE_UPLOAD_EXCEPTION | VARCHAR2 | (4000) | Exception if the processing result in some error. | |
| END_DATE | DATE | expiry date for content item | ||
| OBJECT_STATUS | VARCHAR2 | (1) | Workflow status of object processed. | |
| CITEM_VERSION_ID | NUMBER | version id of item created | ||
| OBJECT_EXCEPTION | VARCHAR2 | (4000) | exception related to object processing. | |
| OBJECT_CREATED_AS | VARCHAR2 | (240) | Name with which object is created. | |
| AUDIT_LOG | VARCHAR2 | (4000) | log for item processing. | |
| TRANSLATION_REQUIRED_FLAG | VARCHAR2 | (1) | Flag statting if translation is required for this item. | |
| ATTRIBUTE1 | VARCHAR2 | (240) | extra table column | |
| START_DATE | DATE | start date for content item. | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | extra table column | |
| MANAGE_FOLDER_FLAG | VARCHAR2 | (1) | Manage folder permission flag for directory node id | |
| ATTRIBUTE3 | VARCHAR2 | (240) | extra table column | |
| ATTRIBUTE4 | VARCHAR2 | (240) | extra table column | |
| ATTRIBUTE5 | VARCHAR2 | (240) | extra table column | |
| CREATED_BY | NUMBER | extra table column | ||
| LAST_UPDATED_BY | NUMBER | last updated by | ||
| CREATION_DATE | DATE | creation date for record | ||
| LAST_UPDATED_DATE | DATE | data this record was last updated. |
Cut, paste (and edit) the following text to query this object:
SELECT BULK_UPLOAD_SEQ_NO
, BULK_UPLOAD_ID
, ZIP_FILE_NAME
, REQUEST_ID
, PROGRAM_ID
, OBJECT_NAME
, OBJECT_TYPE
, OBJECT_FULL_PATH
, PARENT_FULL_PATH
, OBJECT_PATH
, OBJECT_FLAT_PATH
, OBJECT_CREATE_AS
, OBJECT_UPLOAD_AS
, OBJECT_UPLOAD_OPTION
, OBJECT_UPLOAD_OPTION_USED
, OBJECT_ACTUAL_FULL_PATH
, OBJECT_UPLOAD_STATUS
, FILE_EXTENSION
, DIRECTORY_NODE_ID
, MIME_TYPE
, OWNER_RESOURCE_ID
, ATTACHMENT_FILE_ID
, OWNER_RESOURCE_TYPE
, OBJECT_UPLOADED_STATUS
, BASE_LANGUAGE
, CONTENT_TYPE_CODE
, CONTENT_ITEM_ID
, FILE_UPLOAD_STATUS
, OBJECT_UPLOADED_AS
, FILE_UPLOAD_EXCEPTION
, END_DATE
, OBJECT_STATUS
, CITEM_VERSION_ID
, OBJECT_EXCEPTION
, OBJECT_CREATED_AS
, AUDIT_LOG
, TRANSLATION_REQUIRED_FLAG
, ATTRIBUTE1
, START_DATE
, ATTRIBUTE2
, MANAGE_FOLDER_FLAG
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATED_DATE
FROM IBC.IBC_BULK_UPLOAD;
IBC.IBC_BULK_UPLOAD does not reference any database object
IBC.IBC_BULK_UPLOAD is referenced by following:
APPS
IBC_BULK_UPLOAD
|
|
|
|