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_INTERFACE

Object Details

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

Audit Procedure Interface table stores information about Audit Procedure upload data from WebADI

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_AP_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	AP_INTERFACE_ID
AMW_AP_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID CREATED_BY

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Batch identifier
AP_INTERFACE_ID	NUMBER		Yes	Table primary key
AP_NAME	VARCHAR2	(240)	Yes	Audit Procedure Name
AP_DESCRIPTION	VARCHAR2	(4000)		Audit Procedure Description
AP_APPROVAL_STATUS_CODE	VARCHAR2	(30)		Audit Procedure Approval Status Lookup Code
AP_END_DATE	DATE			Audit Procedure End Date
REVISE_AP_FLAG	VARCHAR2	(1)		Flag for revising/updating Audit Procedure
CONTROL_NAME	NUMBER			Associated Control Name selected from LoV
AP_STEP_NAME	VARCHAR2	(240)	Yes	AP Step Name
AP_STEP_DESCRIPTION	VARCHAR2	(4000)		Ap Step Description
AP_STEP_SAMPLESIZE	NUMBER			Ap Step Sample size
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
ERROR_FLAG	VARCHAR2	(1)		Error flag for row processing
INTERFACE_STATUS	VARCHAR2	(2000)		Uploaded row Interface Status
PROCESS_FLAG	VARCHAR2	(1)		Row processed flag
AP_STEP_SEQNUM	NUMBER			Ap Step Sequence Number
AP_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
AP_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
AP_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
DESIGN_EFFECTIVENESS	VARCHAR2	(1)		Ap Association Design Effectiveness
OP_EFFECTIVENESS	VARCHAR2	(1)		Ap Association Operating Effectiveness
CLASSIFICATION	NUMBER			Stores the classification details
AP_STEP_SEQNUM2	VARCHAR2	(240)		Audit Step sequence number

Query Text

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


SELECT BATCH_ID
,      AP_INTERFACE_ID
,      AP_NAME
,      AP_DESCRIPTION
,      AP_APPROVAL_STATUS_CODE
,      AP_END_DATE
,      REVISE_AP_FLAG
,      CONTROL_NAME
,      AP_STEP_NAME
,      AP_STEP_DESCRIPTION
,      AP_STEP_SAMPLESIZE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ERROR_FLAG
,      INTERFACE_STATUS
,      PROCESS_FLAG
,      AP_STEP_SEQNUM
,      AP_ATTRIBUTE_CATEGORY
,      AP_ATTRIBUTE1
,      AP_ATTRIBUTE2
,      AP_ATTRIBUTE3
,      AP_ATTRIBUTE4
,      AP_ATTRIBUTE5
,      AP_ATTRIBUTE6
,      AP_ATTRIBUTE7
,      AP_ATTRIBUTE8
,      AP_ATTRIBUTE9
,      AP_ATTRIBUTE10
,      AP_ATTRIBUTE11
,      AP_ATTRIBUTE12
,      AP_ATTRIBUTE13
,      AP_ATTRIBUTE14
,      AP_ATTRIBUTE15
,      DESIGN_EFFECTIVENESS
,      OP_EFFECTIVENESS
,      CLASSIFICATION
,      AP_STEP_SEQNUM2
FROM AMW.AMW_AP_INTERFACE;

Dependencies

[top of page]

AMW.AMW_AP_INTERFACE does not reference any database object

AMW.AMW_AP_INTERFACE is referenced by following:

APPS: AMW_AP_INTERFACE