eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CN.CN_COPY_REQUESTS_ALL

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace
SYS_IL0000454756C00018$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000454756C00019$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000454756C00023$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

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)

Query Text

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;

Dependencies

[top of page]

CN.CN_COPY_REQUESTS_ALL references the following:

SYS: STANDARD - show dependent code; XMLTYPE

CN.CN_COPY_REQUESTS_ALL is referenced by following:

CN: CN_COPY_REQUESTS_ALL#