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_CI_ACTIONS

Object Details

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

This table stores the action log for each control item. Each entry store the entire requesting information and response.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_CI_ACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CI_ACTION_ID
PA_CI_ACTIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CI_ID CI_ACTION_NUMBER
PA_CI_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CI_ID STATUS_CODE TYPE_CODE
PA_CI_ACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNED_TO STATUS_CODE CI_ID
PA_CI_ACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SIGN_OFF_REQUIRED_FLAG CI_ID
PA_CI_ACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SIGN_OFF_FLAG CI_ID
PA_CI_ACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_CI_ACTION_ID CI_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CI_ACTION_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies the control item action
CI_ID	NUMBER	(15)	Yes	Identifier of the control item
CI_ACTION_NUMBER	NUMBER	(15)	Yes	System-generated number that uniquely identifies the action within a control item
STATUS_CODE	VARCHAR2	(30)	Yes	The user status code for the action
TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code indicating the type of the action
ASSIGNED_TO	NUMBER	(15)	Yes	The identifier of the person assigned to the action
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
SIGN_OFF_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag indicating that the control item can be signed off upon action closure
SIGN_OFF_FLAG	VARCHAR2	(1)	Yes	Flag indicating that the control item is signed off
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Number used for record locking in self service applications
DATE_REQUIRED	DATE			The date on which the action closure is required
DATE_CLOSED	DATE			The date on which the action is closed
SOURCE_CI_ACTION_ID	NUMBER	(15)		The identifier of the action originated this action

Query Text

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


SELECT CI_ACTION_ID
,      CI_ID
,      CI_ACTION_NUMBER
,      STATUS_CODE
,      TYPE_CODE
,      ASSIGNED_TO
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SIGN_OFF_REQUIRED_FLAG
,      SIGN_OFF_FLAG
,      RECORD_VERSION_NUMBER
,      DATE_REQUIRED
,      DATE_CLOSED
,      SOURCE_CI_ACTION_ID
FROM PA.PA_CI_ACTIONS;

Dependencies

[top of page]

PA.PA_CI_ACTIONS does not reference any database object

PA.PA_CI_ACTIONS is referenced by following:

APPS: PA_CI_ACTIONS