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: AZ.AZ_ARCHIVE_STEPS

Object Details

Object Name:	AZ_ARCHIVE_STEPS
Object Type:	TABLE
Owner:	AZ
FND Design Data:	AZ.AZ_ARCHIVE_STEPS
Subobject Name:
Status:	VALID

AZ_ARCHIVE_STEPS stores Wizard data regarding tasks and all their steps. Each row has information regarding each step of the task, its status, the assigned user, the form name associated with the step, and the begin date for the the task step.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AZ_ARCHIVE_STEPS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ITEM_KEY ACTIVITY_TYPE STEP BEGIN_DATE
AZ_ARCHIVE_STEPS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	NODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_KEY	VARCHAR2	(240)	Yes	Unique identifier for the task
ACTIVITY_TYPE	VARCHAR2	(8)	Yes	Identifies type of task step (FUNCTION, NOTICE, or PROCESS)
STEP	VARCHAR2	(30)	Yes	Step for the task
STEP_NAME	VARCHAR2	(80)	Yes	Label for the step
ASSIGNED_USER	VARCHAR2	(100)		Assigned role for notification
ASSIGNED_USER_NAME	VARCHAR2	(4000)		User name for the notification
FORM_NAME	VARCHAR2	(4000)		The form associated with the task step
STATUS_CODE	VARCHAR2	(8)		Status for the task step, either ACTIVE, COMPLETE, NOTIFIED, or ERROR
RESULT_CODE	VARCHAR2	(30)		Response code for the step (e.g. skipped,. done, etc.)
BEGIN_DATE	DATE		Yes	Start date for the task step
END_DATE	DATE			End date for the task step
DURATION	NUMBER	(15)		Duration of the task
COMMENTS	VARCHAR2	(4000)		Comments
NODE_ID	VARCHAR2	(240)	Yes	Unique identifier for the task step

Query Text

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


SELECT ITEM_KEY
,      ACTIVITY_TYPE
,      STEP
,      STEP_NAME
,      ASSIGNED_USER
,      ASSIGNED_USER_NAME
,      FORM_NAME
,      STATUS_CODE
,      RESULT_CODE
,      BEGIN_DATE
,      END_DATE
,      DURATION
,      COMMENTS
,      NODE_ID
FROM AZ.AZ_ARCHIVE_STEPS;

Dependencies

[top of page]

AZ.AZ_ARCHIVE_STEPS does not reference any database object

AZ.AZ_ARCHIVE_STEPS is referenced by following:

AZ: AZ_ARCHIVE_STEPS#