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: PA.PA_OBJ_STATUS_CHANGES

Object Details

Object Name:	PA_OBJ_STATUS_CHANGES
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_OBJ_STATUS_CHANGES
Subobject Name:
Status:	VALID

This table records the changes of the status of the objects.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_OBJ_STATUS_CHANGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJ_STATUS_CHANGE_ID
PA_OBJ_STATUS_CHANGES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID STATUS_TYPE LAST_UPDATE_DATE NEW_PROJECT_STATUS_CODE
PA_OBJ_STATUS_CHANGES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATED_BY OBJECT_TYPE OBJECT_ID STATUS_TYPE
PA_OBJ_STATUS_CHANGES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID STATUS_TYPE NEW_PROJECT_STATUS_CODE NEW_PROJECT_SYSTEM_STATUS_CODE OLD_PROJECT_STATUS_CODE OLD_PROJECT_SYSTEM_STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
OBJ_STATUS_CHANGE_ID	NUMBER	(15)	Yes	Unique identifier of the status change of the object.
OBJECT_TYPE	VARCHAR2	(30)	Yes	Specify the type of the object.
OBJECT_ID	NUMBER	(15)	Yes	Unique identifier of the object.
STATUS_TYPE	VARCHAR2	(30)	Yes	Status type.
NEW_PROJECT_STATUS_CODE	VARCHAR2	(30)	Yes	Code of the new user status.
NEW_PROJECT_SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	Code of the new system status.
OLD_PROJECT_STATUS_CODE	VARCHAR2	(30)	Yes	Code of the old user status.
OLD_PROJECT_SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	Code of the old system status.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CHANGE_COMMENT	VARCHAR2	(4000)		Comment on the status change.

Query Text

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


SELECT OBJ_STATUS_CHANGE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      STATUS_TYPE
,      NEW_PROJECT_STATUS_CODE
,      NEW_PROJECT_SYSTEM_STATUS_CODE
,      OLD_PROJECT_STATUS_CODE
,      OLD_PROJECT_SYSTEM_STATUS_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHANGE_COMMENT
FROM PA.PA_OBJ_STATUS_CHANGES;

Dependencies

[top of page]

PA.PA_OBJ_STATUS_CHANGES does not reference any database object

PA.PA_OBJ_STATUS_CHANGES is referenced by following:

PA: PA_OBJ_STATUS_CHANGES#