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_TASK_HISTORY

Object Details

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

PA_TASK_HISTORY stores service type and organization history for
tasks. This action is maintained using row-level update/insert
triggers on the PA_TASKS table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TASK_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TASK_HISTORY_ID
PA_TASK_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID
PA_TASK_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADW_NOTIFY_FLAG PROJECT_ID
PA_TASK_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_HISTORY_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the task history row
TASK_ID	NUMBER	(15)	Yes	The identifier of the task for which this row belongs
SERVICE_TYPE_CODE	VARCHAR2	(30)	Yes	The service type code for the task when the task is created or updated
CARRYING_OUT_ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier for the task organization when the task is created or updated
TOP_TASK_ID	NUMBER	(15)	Yes	The identifier of the top task to which this task history rolls up
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which this task history belongs
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
ADW_INTERFACE_FLAG	VARCHAR2	(1)		The flag to indicate whether this task history row has been sent to the interface table or not
ADW_NOTIFY_FLAG	VARCHAR2	(1)		Flag that indicates that this task history need to be sent to the interface table or not

Query Text

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


SELECT TASK_HISTORY_ID
,      TASK_ID
,      SERVICE_TYPE_CODE
,      CARRYING_OUT_ORGANIZATION_ID
,      TOP_TASK_ID
,      PROJECT_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADW_INTERFACE_FLAG
,      ADW_NOTIFY_FLAG
FROM PA.PA_TASK_HISTORY;

Dependencies

[top of page]

PA.PA_TASK_HISTORY does not reference any database object

PA.PA_TASK_HISTORY is referenced by following:

PA: PA_TASK_HISTORY#