[Home] [Help] [Dependency Information]
Object Name: | CN_COPY_REQUESTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_COPY_REQUESTS_ALL |
Subobject Name: | |
Status: | VALID |
CN_COPY_REQUESTS_ALL contains information about a Plan's Import or an Export
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000454756C00018$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000454756C00019$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000454756C00023$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXP_IMP_REQUEST_ID | NUMBER | (15) | Yes | Primary Key of this table, will be generated using a sequence |
ORG_ID | NUMBER | Yes | Operating Unit, this column will contain source operating unit for export requests and will contain target operating unit for import. | |
REQUEST_NAME | VARCHAR2 | (80) | Yes | Request Name for the import or export process. |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Type of Object that is being exported or imported. |
STATUS_CODE | VARCHAR2 | (30) | Yes | Status of the export or import process |
CREATED_BY | NUMBER | Standard Who Columns | ||
CREATION_DATE | DATE | Standard Who Columns | ||
LAST_UPDATED_BY | NUMBER | Standard Who Columns | ||
LAST_UPDATE_DATE | DATE | Standard Who Columns | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Columns | ||
COMPLETION_DATE | DATE | Completion Date of the export or import process | ||
PREFIX_INFO | VARCHAR2 | (10) | Prefix will be used during import procedure that will be used to name the objects in the target operating unit | |
CHANGE_DATE_FLAG | VARCHAR2 | (1) | Stores a Y if the dates needs to be changed for objects in the target instance. | |
CHANGE_START_DATE | DATE | This column will have a date if the change_date_flag is set to Y. This start date will be used for all newly created objects in the target | ||
CHANGE_END_DATE | DATE | This end date will be used for all newly created objects in the target operating unit | ||
REQUEST_ID | NUMBER | Concurrent Request Id | ||
OPERATION | VARCHAR2 | (30) | Contains Export or Import | |
FILE_CONTENT_BLOB | BLOB | (4000) | Imported file will be stored. Export process creates the xml file. | |
FILE_CONTENT_CLOB | CLOB | (4000) | Imported / Exported file contents in CLOB format | |
REQ_SUBMISSION_DATE | DATE | Request Submission Date | ||
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
FILE_CONTENT_XMLTYPE | XMLTYPE | (2000) |
Cut, paste (and edit) the following text to query this object:
SELECT EXP_IMP_REQUEST_ID
, ORG_ID
, REQUEST_NAME
, OBJECT_TYPE
, STATUS_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, COMPLETION_DATE
, PREFIX_INFO
, CHANGE_DATE_FLAG
, CHANGE_START_DATE
, CHANGE_END_DATE
, REQUEST_ID
, OPERATION
, FILE_CONTENT_BLOB
, FILE_CONTENT_CLOB
, REQ_SUBMISSION_DATE
, OBJECT_VERSION_NUMBER
, FILE_CONTENT_XMLTYPE
FROM CN.CN_COPY_REQUESTS_ALL;
|
|
|