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: APPLSYS.AD_MANUAL_STEP_HISTORY

Object Details

Object Name:	AD_MANUAL_STEP_HISTORY
Object Type:	TABLE
Owner:	APPLSYS
Subobject Name:
Status:	VALID

Stores history of manual steps applied to this instance. For each step applied on a customer instance, there will be one entry which is stored in this table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_MANUAL_STEP_HISTORY_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STEP_KEY STEP_VERSION

Columns

Name	Datatype	Length	Mandatory	Comments
HISTORY_ID	NUMBER		Yes	Primary key of the table
STEP_KEY	VARCHAR2	(100)	Yes	Stores Manual Step's unique key element
STEP_VERSION	VARCHAR2	(100)	Yes	RCS Version of Manual Step
STEP_TEXT	VARCHAR2	(2000)		Manual Step text
COND_CODE	VARCHAR2	(2000)		Conditional Code for Manual Step
PATCH_NUMBER	VARCHAR2	(100)	Yes	The patch number for which manual step is applied
STATUS	VARCHAR2	(1)	Yes	Manual step's current status, can take either D or Y
UPDATED_BY	VARCHAR2	(100)		Apps User Name

Query Text

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


SELECT HISTORY_ID
,      STEP_KEY
,      STEP_VERSION
,      STEP_TEXT
,      COND_CODE
,      PATCH_NUMBER
,      STATUS
,      UPDATED_BY
FROM APPLSYS.AD_MANUAL_STEP_HISTORY;

Dependencies

[top of page]

APPLSYS.AD_MANUAL_STEP_HISTORY does not reference any database object

APPLSYS.AD_MANUAL_STEP_HISTORY is referenced by following:

APPS: AD_MANUAL_STEP_HISTORY