[Home] [Help] [Dependency Information]
Object Name: | AMW_AP_TASKS |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.AMW_AP_TASKS |
Subobject Name: | |
Status: | VALID |
This table contains information about the tasks associated to an audit procedure. The user can associate tasks from project templates to an audit procedure. The task information is stored in the PA_TASKS table and the template information is stored in the PA_PROJECTS_ALL table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMW_AP_TASKS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AP_TASK_ID |
AMW_AP_TASKS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AUDIT_PROCEDURE_ID
PROJECT_ID TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AP_TASK_ID | NUMBER | Yes | Audit Procedure - Task association unique identifier | |
AUDIT_PROCEDURE_ID | NUMBER | Yes | Audit Procedure Identifier | |
TASK_ID | NUMBER | Yes | Task Identifier. This references TASK_ID from the PA_TASKS table. | |
PROJECT_ID | NUMBER | Yes | Project Identifier to which this task belongs. This references PROJECT_ID from PA_PROJECTS_ALL. | |
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 | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
SECURITY_GROUP_ID | NUMBER | Used for hosting environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Object version number for Locking. | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (30) | Original system reference | |
REQUESTOR_ID | NUMBER | Requestor Id | ||
SOURCE_CODE | VARCHAR2 | (5) | Source code from which its created |
Cut, paste (and edit) the following text to query this object:
SELECT AP_TASK_ID
, AUDIT_PROCEDURE_ID
, TASK_ID
, PROJECT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, ORIG_SYSTEM_REFERENCE
, REQUESTOR_ID
, SOURCE_CODE
FROM AMW.AMW_AP_TASKS;
AMW.AMW_AP_TASKS does not reference any database object
AMW.AMW_AP_TASKS is referenced by following:
|
|
|