DBA Data[Home] [Help] [Dependency Information]

TABLE: AMW.AMW_AUDIT_PROCEDURE_INTERFACE

Object Details
Object Name: AMW_AUDIT_PROCEDURE_INTERFACE
Object Type: TABLE
Owner: AMW
FND Design Data: TableAMW.AMW_AUDIT_PROCEDURE_INTERFACE
Subobject Name:
Status: VALID


Interface table for audit tasks results webadi upload of data


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes Batch Identifier
AP_INTERFACE_ID NUMBER
Yes Interface Indentifier
AUDIT_PROCEDURE_ID NUMBER
Yes Audit Procedure Identifier
AUDIT_PROCEDURE_REV_ID NUMBER
Yes Audit procedure revision identifier
AUDIT_PROJECT_ID NUMBER
Yes Audit project identifier
ORGANIZATION_ID NUMBER
Yes Organization identifer
CONTROL_ID NUMBER
Yes Control Identifier
TASK_ID NUMBER

Task identifier
STEP_ID NUMBER

Step identifier
AP_ASSOCIATION_ID NUMBER

AP Association identifier
AP_NAME VARCHAR2 (240)
Audit procedure name
TASK_NAME VARCHAR2 (20)
Task name
TASK_DESCRIPTION VARCHAR2 (250)
Task description
ORGANIZATION_NAME VARCHAR2 (240)
Organization name
AP_STATUS VARCHAR2 (30)
Audit procedure status
AP_WORK_DESCRIPTION VARCHAR2 (4000)
work description
AP_EXECUTED_BY NUMBER

Executed by
AP_EXECUTED_ON DATE

Executed on
AP_EXECUTION_ID NUMBER

Execution identifier
AP_EXECUTEDBY_NAME VARCHAR2 (240)
Executed by name
STEP_STATUS VARCHAR2 (30)
Step status
STEP_WORK_DESCRIPTION VARCHAR2 (4000)
Step work description
STEP_EXECUTED_BY NUMBER

Step executed by
STEP_EXECUTED_ON DATE

Step executed on
STEP_EXECUTION_ID NUMBER

Step execution identifier
STEP_EXECUTEDBY_NAME VARCHAR2 (240)
Step executed by name
STEP_NAME VARCHAR2 (240)
Step name
STEP_DESCRIPTION VARCHAR2 (4000)
Step description
STEP_NUMBER VARCHAR2 (240)
Step number
CONTROL_NAME VARCHAR2 (240)
Control name
CONTROL_DESCRIPTION VARCHAR2 (4000)
Control description
DESIGN_EFFECTIVENESS VARCHAR2 (30)
Design effectiveness
OP_EFFECTIVENESS VARCHAR2 (30)
Operating effectiveness
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 segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PROCESSED_FLAG VARCHAR2 (1)
Indicates whether the record is proccessed
ERROR_FLAG VARCHAR2 (1)
Error flag gets set if there is an error during upload
INTERFACE_STATUS VARCHAR2 (2000)
Stored the interface status message
CONTROL_OPINION VARCHAR2 (240)
Control opinion
CONTROL_OPINION_ID NUMBER

control opinion identifier
AUDIT_PROJECT_NAME VARCHAR2 (80)
Audit project name
AUDIT_PROJECT_STARTDATE DATE

Audit project start date
PROCESS_NAME VARCHAR2 (240)
Process name
RISK_NAME VARCHAR2 (240)
Risk name
KEY_CONTROL VARCHAR2 (10)
key control
CONTROL_OBJECTIVE VARCHAR2 (240)
Control objective
CTRL_OVERALL_SUMMARY VARCHAR2 (1500)
Control opinion overall summary
CTRL_OVERALL_DESCRIPTION VARCHAR2 (3000)
Control opinion overall description
CTRL_DESIGN_SUMMARY VARCHAR2 (1500)
Control design summary
CTRL_DESIGN_DESCRIPTION VARCHAR2 (3000)
Control design description
CTRL_OPERATING_SUMMARY VARCHAR2 (1500)
Control operating summary
CTRL_OPERATING_DESCRIPTION VARCHAR2 (3000)
Operating description
STEPS_ATTACHMENT_URL VARCHAR2 (2048)
Steps attachment URL
Query Text

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


SELECT BATCH_ID
,      AP_INTERFACE_ID
,      AUDIT_PROCEDURE_ID
,      AUDIT_PROCEDURE_REV_ID
,      AUDIT_PROJECT_ID
,      ORGANIZATION_ID
,      CONTROL_ID
,      TASK_ID
,      STEP_ID
,      AP_ASSOCIATION_ID
,      AP_NAME
,      TASK_NAME
,      TASK_DESCRIPTION
,      ORGANIZATION_NAME
,      AP_STATUS
,      AP_WORK_DESCRIPTION
,      AP_EXECUTED_BY
,      AP_EXECUTED_ON
,      AP_EXECUTION_ID
,      AP_EXECUTEDBY_NAME
,      STEP_STATUS
,      STEP_WORK_DESCRIPTION
,      STEP_EXECUTED_BY
,      STEP_EXECUTED_ON
,      STEP_EXECUTION_ID
,      STEP_EXECUTEDBY_NAME
,      STEP_NAME
,      STEP_DESCRIPTION
,      STEP_NUMBER
,      CONTROL_NAME
,      CONTROL_DESCRIPTION
,      DESIGN_EFFECTIVENESS
,      OP_EFFECTIVENESS
,      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
,      PROCESSED_FLAG
,      ERROR_FLAG
,      INTERFACE_STATUS
,      CONTROL_OPINION
,      CONTROL_OPINION_ID
,      AUDIT_PROJECT_NAME
,      AUDIT_PROJECT_STARTDATE
,      PROCESS_NAME
,      RISK_NAME
,      KEY_CONTROL
,      CONTROL_OBJECTIVE
,      CTRL_OVERALL_SUMMARY
,      CTRL_OVERALL_DESCRIPTION
,      CTRL_DESIGN_SUMMARY
,      CTRL_DESIGN_DESCRIPTION
,      CTRL_OPERATING_SUMMARY
,      CTRL_OPERATING_DESCRIPTION
,      STEPS_ATTACHMENT_URL
FROM AMW.AMW_AUDIT_PROCEDURE_INTERFACE;

Dependencies

[top of page]

AMW.AMW_AUDIT_PROCEDURE_INTERFACE does not reference any database object

AMW.AMW_AUDIT_PROCEDURE_INTERFACE is referenced by following:

SchemaAPPS
SynonymAMW_AUDIT_PROCEDURE_INTERFACE