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: PSP.PSP_ENC_CHANGED_SCH_HISTORY

Object Details

Object Name:	PSP_ENC_CHANGED_SCH_HISTORY
Object Type:	TABLE
Owner:	PSP
FND Design Data:	PSP.PSP_ENC_CHANGED_SCH_HISTORY
Subobject Name:
Status:	VALID

To maintain history of Setup form changes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REFERENCE_FIELD	VARCHAR2	(30)		Identifies the field whose value is stored in REFERENCE_ID
ACTION_TYPE	VARCHAR2	(1)		Identifies the DML operation
CHANGE_TYPE	VARCHAR2	(2)		Identifies the change type for the affected assignments
REFERENCE_ID	NUMBER	(15)	Yes	Reference Id
REQUEST_ID	NUMBER		Yes	Identifies the Request Id

Query Text

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


SELECT REFERENCE_FIELD
,      ACTION_TYPE
,      CHANGE_TYPE
,      REFERENCE_ID
,      REQUEST_ID
FROM PSP.PSP_ENC_CHANGED_SCH_HISTORY;

Dependencies

[top of page]

PSP.PSP_ENC_CHANGED_SCH_HISTORY does not reference any database object

PSP.PSP_ENC_CHANGED_SCH_HISTORY is referenced by following:

APPS: PSP_ENC_CHANGED_SCH_HISTORY