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_ARC_AUDIT_ALL

Object Details

Object Name:	CN_ARC_AUDIT_ALL
Object Type:	TABLE
Owner:	CN
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ARCHIVE_PURGE_ID	NUMBER	(15)	Yes	Unique Id for Archive or Purge Action
TOT_AP_TABLES_COUNT	NUMBER	(15)		Total number of tables archived/purged
TOT_AP_ROWS	NUMBER	(15)		Total number of rows archived/purged
ARCHIVE_PURGE_DATE	DATE			Date on which archive/purge occured
START_PERIOD_ID	NUMBER	(15)		Start Period id is the id corresponding to start period name
END_PERIOD_ID	NUMBER	(15)		End Period id is the id corresponding to end period name
ORG_ID	NUMBER	(15)		Organization Id used for fetching period id.
RUN_MODE	VARCHAR2	(15)		This will indicated the mode selected i.e. Archive or Purge.
ATTRIBUTE1	VARCHAR2	(150)		Used for storing any additional information
ATTRIBUTE2	VARCHAR2	(150)		Used for storing any additional information
ATTRIBUTE3	VARCHAR2	(150)		Used for storing any additional information
ATTRIBUTE4	VARCHAR2	(150)		Used for storing any additional information
ATTRIBUTE5	VARCHAR2	(150)		Used for storing any additional information
CREATED_BY	NUMBER	(15)		Standard created by column
CREATION_DATE	DATE			Standard creation date column
LAST_UPDATED_BY	NUMBER	(15)		Standard last updated by column
LAST_UPDATE_DATE	DATE			Standard last updated date column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard last updated login column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ARCHIVE_PURGE_ID
,      TOT_AP_TABLES_COUNT
,      TOT_AP_ROWS
,      ARCHIVE_PURGE_DATE
,      START_PERIOD_ID
,      END_PERIOD_ID
,      ORG_ID
,      RUN_MODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CN.CN_ARC_AUDIT_ALL;

Dependencies

[top of page]

CN.CN_ARC_AUDIT_ALL does not reference any database object

CN.CN_ARC_AUDIT_ALL is referenced by following:

CN: CN_ARC_AUDIT_ALL#