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: AMW.AMW_AP_EXECUTIONS

Object Details

Object Name:	AMW_AP_EXECUTIONS
Object Type:	TABLE
Owner:	AMW
FND Design Data:	AMW.AMW_AP_EXECUTIONS
Subobject Name:
Status:	VALID

Hold information about Audit Procedure and Step executions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_AP_EXECUTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUDIT_PROCEDURE_REV_ID PK1 PK2 PK3 EXECUTION_TYPE AP_STEP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXECUTION_ID	NUMBER		Yes	Execution Identifier
AUDIT_PROCEDURE_REV_ID	NUMBER		Yes	Audit Procedure Revision Identifier
AP_STEP_ID	NUMBER			Audit Step Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
EXECUTED_ON	DATE			Execution Date
EXECUTED_BY	NUMBER			Identifier of the person who executed this audit procedure or audit step.
STATUS	VARCHAR2	(30)		Status of execution
WORK_DESC	VARCHAR2	(4000)		Work Description for execution
EXECUTION_TYPE	VARCHAR2	(30)		Execution Type - AP (Audit Procedure) or STEP (Audit Step)
PK1	NUMBER		Yes	Holds value of PK1 - Project identifier
PK2	NUMBER		Yes	Holds value of PK2 - Organization identifier
PK3	NUMBER		Yes	Holds value of PK3 - Task identifier
PK4	NUMBER			Holds value of PK4 - Not used
PK5	NUMBER			Holds value of PK5 - Not used
SECURITY_GROUP_ID	NUMBER			Used for hosted environments.
OBJECT_VERSION_NUMBER	NUMBER			This column is for optimistic locking.

Query Text

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


SELECT EXECUTION_ID
,      AUDIT_PROCEDURE_REV_ID
,      AP_STEP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EXECUTED_ON
,      EXECUTED_BY
,      STATUS
,      WORK_DESC
,      EXECUTION_TYPE
,      PK1
,      PK2
,      PK3
,      PK4
,      PK5
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM AMW.AMW_AP_EXECUTIONS;

Dependencies

[top of page]

AMW.AMW_AP_EXECUTIONS does not reference any database object

AMW.AMW_AP_EXECUTIONS is referenced by following:

APPS: AMW_AP_EXECUTIONS