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_ACTN_SETLN_AUD_AR

Object Details

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

PA_ACTION_SET LINE_AUD stores audit information for each action set line. Each audit line describes what action has been taken in order to implement the action line. For example, if the Advertising action set is to publish a requirement to a certain staffing manager, then the audit line will contain the person_id of the staffing manager to whom the requirement has been published. If the action set is to notify five staffing managers, then this audit table will contain five audit lines for that action set. Each audit line contains only one audit attribute.
This table contains action_set_type, object_type, object_id, and action_code (along with the action_set_line_id) for performance reasons.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_ACTN_SETLN_AUD_AR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PURGE_PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PURGE_BATCH_ID	NUMBER	(15)	Yes	Purge batch Id
PURGE_RELEASE	VARCHAR2	(50)	Yes	Purge release version
PURGE_PROJECT_ID	NUMBER	(15)	Yes	Purged project Id
ACTION_SET_LINE_ID	NUMBER	(15)		Identifier of the action set line associated with this audit line.
OBJECT_TYPE	VARCHAR2	(30)		The object type to which this action set line belongs. Possible values are 'PROJECT', 'PROJECT_TEMPLATE', etc
OBJECT_ID	NUMBER	(15)		The object id to which this action set line belongs. Possible values are project_id, assignment_id, etc
ACTION_SET_TYPE_CODE	VARCHAR2	(30)		Type of action set. Possible values are Advertisement, Progress Report Reminder, etc
STATUS_CODE	VARCHAR2	(30)		Status of the audit line
REASON_CODE	VARCHAR2	(30)		Reason for the audit line. Possible values include 'PEFORMED', 'REVERSED'.
ACTION_CODE	VARCHAR2	(30)		Action code for the action set line. There is a set of action codes for each action set type. For example, for action set type 'Advertisement', the action code may be 'NOTIFY_STAFFING_MANAGER'.
AUDIT_DISPLAY_ATTRIBUTE	VARCHAR2	(240)		The display attribute containing information regarding how this action set was performed. For example, for action code 'NOTIFY_STAFFING_MANAGER', audit_attribute would contain the staffing manager's full name.
AUDIT_ATTRIBUTE	VARCHAR2	(240)		The attribute containing information regarding how this action set was performed. For example, for action code 'NOTIFY_STAFFING_MANAGER', audit_attribute would contain the staffing manager's person_id.
ACTION_DATE	DATE			Date when the action is performed
ACTIVE_FLAG	VARCHAR2	(1)		Indicates if the action set line is active. 'Y' if the action set line is executed, NOT deleted and NOT reversed. Otherwise, 'N'.
REVERSED_ACTION_SET_LINE_ID	NUMBER	(15)		Unique identifier of the action set line this line reverses, if any.
OBJECT_NAME	VARCHAR2	(80)		Name of the object
ENCODED_ERROR_MESSAGE	VARCHAR2	(2000)		Error message, if any.
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
REQUEST_ID	NUMBER			Concurrent program Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent program Who column
PROGRAM_ID	NUMBER			Concurrent program Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent program Who column

Query Text

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


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      ACTION_SET_LINE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      ACTION_SET_TYPE_CODE
,      STATUS_CODE
,      REASON_CODE
,      ACTION_CODE
,      AUDIT_DISPLAY_ATTRIBUTE
,      AUDIT_ATTRIBUTE
,      ACTION_DATE
,      ACTIVE_FLAG
,      REVERSED_ACTION_SET_LINE_ID
,      OBJECT_NAME
,      ENCODED_ERROR_MESSAGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM PA.PA_ACTN_SETLN_AUD_AR;

Dependencies

[top of page]

PA.PA_ACTN_SETLN_AUD_AR does not reference any database object

PA.PA_ACTN_SETLN_AUD_AR is referenced by following:

PA: PA_ACTN_SETLN_AUD_AR#