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: ITA.ITA_SETUP_CHANGE_HISTORY

Object Details

Object Name:	ITA_SETUP_CHANGE_HISTORY
Object Type:	TABLE
Owner:	ITA
Subobject Name:
Status:	VALID

This table stores changes to a parameter.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ITA_SETUP_CHANGE_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INSTANCE_CODE CHANGE_ID
ITA_SETUP_CHANGE_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_CODE PARAMETER_CODE CHANGE_DATE PK1_VALUE
ITA_SETUP_CHANGE_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_CODE SETUP_GROUP_CODE CHANGE_DATE
ITA_SETUP_CHANGE_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_AUTHOR INSTANCE_CODE PARAMETER_CODE CHANGE_DATE PK1_VALUE
ITA_SETUP_CHANGE_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_AUTHOR INSTANCE_CODE SETUP_GROUP_CODE CHANGE_DATE
ITA_SETUP_CHANGE_HISTORY_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_CODE PARAMETER_CODE PK1_VALUE
ITA_SETUP_CHANGE_HISTORY_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARAMETER_CODE PK1_VALUE CHANGE_DATE
ITA_SETUP_CHANGE_HISTORY_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_CODE PARAMETER_CODE PK7_VALUE PK2_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE_CODE	VARCHAR2	(30)	Yes	Instance identifier
CHANGE_ID	NUMBER		Yes	Entity identifier.
PARAMETER_CODE	VARCHAR2	(111)		Parameter identifier
SETUP_GROUP_CODE	VARCHAR2	(81)		Setup group identifier
CHANGE_AUTHOR	VARCHAR2	(100)		Change author
CHANGE_DATE	DATE			Change date
RECOMMENDED_VALUE	VARCHAR2	(3000)		Recommended value meaning (user-displayable string)
PRIOR_VALUE	VARCHAR2	(3000)		Prior value meaning (user-displayable string)
CURRENT_VALUE	VARCHAR2	(3000)		Current value meaning (user-displayable string)
PK1_VALUE	VARCHAR2	(3000)		Organization name
PK2_VALUE	VARCHAR2	(3000)		Organization identifier
PK3_VALUE	VARCHAR2	(3000)		Current value code
PK4_VALUE	VARCHAR2	(3000)		Prior value code
PK5_VALUE	VARCHAR2	(3000)		Recommended value code
PK6_VALUE	VARCHAR2	(3000)		Context parameter 2 value
PK7_VALUE	VARCHAR2	(3000)		Supplier identifier
PK8_VALUE	VARCHAR2	(3000)		Site name
PK9_VALUE	VARCHAR2	(3000)		Site identifier
PK10_VALUE	VARCHAR2	(3000)		Currently not used
PK11_VALUE	VARCHAR2	(3000)		Currently not used
PK12_VALUE	VARCHAR2	(3000)		Currently not used
PK13_VALUE	VARCHAR2	(3000)		Currently not used
PK14_VALUE	VARCHAR2	(3000)		Currently not used
PK15_VALUE	VARCHAR2	(3000)		Currently not used
PK16_VALUE	VARCHAR2	(3000)		Currently not used
PK17_VALUE	VARCHAR2	(3000)		Currently not used
PK18_VALUE	VARCHAR2	(3000)		Currently not used
PK19_VALUE	VARCHAR2	(3000)		Currently not used
PK20_VALUE	VARCHAR2	(3000)		Currently not used
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
SECURITY_GROUP_ID	NUMBER			Standard Applications column
OBJECT_VERSION_NUMBER	NUMBER			Standard Applications column
TO_DATE	DATE			To date

Query Text

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


SELECT INSTANCE_CODE
,      CHANGE_ID
,      PARAMETER_CODE
,      SETUP_GROUP_CODE
,      CHANGE_AUTHOR
,      CHANGE_DATE
,      RECOMMENDED_VALUE
,      PRIOR_VALUE
,      CURRENT_VALUE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      PK6_VALUE
,      PK7_VALUE
,      PK8_VALUE
,      PK9_VALUE
,      PK10_VALUE
,      PK11_VALUE
,      PK12_VALUE
,      PK13_VALUE
,      PK14_VALUE
,      PK15_VALUE
,      PK16_VALUE
,      PK17_VALUE
,      PK18_VALUE
,      PK19_VALUE
,      PK20_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      TO_DATE
FROM ITA.ITA_SETUP_CHANGE_HISTORY;

Dependencies

[top of page]

ITA.ITA_SETUP_CHANGE_HISTORY does not reference any database object

ITA.ITA_SETUP_CHANGE_HISTORY is referenced by following:

APPS: ITA_SETUP_CHANGE_HISTORY