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

TABLE: AMW.AMW_CTRL_INTERFACE

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


Interface table for Control data in WebADI Upload


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_CTRL_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnCTRL_INTERFACE_ID
AMW_CTRL_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnCREATED_BY
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes Batch identifier for group upload of Controls through WebADI
CTRL_INTERFACE_ID NUMBER
Yes Stores the Identifier
CONTROL_APPROVAL_STATUS_CODE VARCHAR2 (30)
Control Approval Status Lookup Code
CONTROL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure defining column
CONTROL_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CONTROL_AUTOMATION_TYPE_CODE VARCHAR2 (100)
Stores the Control Automation Type Lookup Code
CONTROL_DESCRIPTION VARCHAR2 (4000)
Stores the Control Description
CONTROL_JOB_ID VARCHAR2 (240)
Stores the Control Job Id
CONTROL_LOCATION_CODE VARCHAR2 (100)
Stores the Control Location Lookup Code
CONTROL_NAME VARCHAR2 (240)
Stores the Name of the Control
CONTROL_ORG_SYS_REF VARCHAR2 (150)
Not used
CONTROL_SOURCE VARCHAR2 (150)
Stores the Control Source
CONTROL_SOURCE_TYPE VARCHAR2 (240)
Stores the Control Source Type
CONTROL_TYPE_CODE VARCHAR2 (100)
Stores the Control Type Lookup Code
CREATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
ERROR_FLAG VARCHAR2 (1)
Stores the Error flag for processing this row
INTERFACE_STATUS VARCHAR2 (2000)
Stores the Status for processing this row
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
PHYSICAL_EVIDENCE VARCHAR2 (240)
Stores the Physical Evidence for this Control
PROCESS_FLAG VARCHAR2 (1)
Stores the Process flag for this row
REQUESTOR_ID NUMBER

Stores the Party Id of person requesting this upload
REVISE_CTRL_FLAG VARCHAR2 (1)
Stores the Flag for revising/updating this Control
CONTROL_OBJ1 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ2 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ3 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ4 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ5 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ6 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ7 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ8 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ9 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ10 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ11 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ12 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ13 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ14 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ15 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ16 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ17 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ18 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ19 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ20 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ21 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ22 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ23 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ24 VARCHAR2 (1)
Stores the Control Objective
CONTROL_OBJ25 VARCHAR2 (1)
Control Objective
CONTROL_OBJ26 VARCHAR2 (1)
Control Objective
CONTROL_OBJ27 VARCHAR2 (1)
Control Objective
CONTROL_OBJ28 VARCHAR2 (1)
Control Objective
CONTROL_OBJ29 VARCHAR2 (1)
Control Objective
CONTROL_OBJ30 VARCHAR2 (1)
Control Objective
CONTROL_ASSERT1 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT2 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT3 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT4 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT5 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT6 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT7 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT8 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT9 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT10 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT11 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT12 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT13 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT14 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT15 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT16 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT17 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT18 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT19 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT20 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT21 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT22 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT23 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT24 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT25 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT26 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT27 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT28 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT29 VARCHAR2 (1)
Control Assertion
CONTROL_ASSERT30 VARCHAR2 (1)
Control Assertion
CONTROL_APPLICATION_ID NUMBER

Application Id for this Control used in selecting Control Source
PREVENTIVE_CONTROL VARCHAR2 (1)
Stores whether this Control is Preventive in nature
DETECTIVE_CONTROL VARCHAR2 (1)
Stores whether this Control is Detective in nature
DISCLOSURE_CONTROL VARCHAR2 (1)
Stores whether this Control needs to be disclosed
KEY_MITIGATING VARCHAR2 (1)
Stores whether this Control is Key or Mitigating
VERIFICATION_SOURCE_NAME VARCHAR2 (240)
Configuration Assessment Source Name for this Control
VERIFICATION_INSTRUCTION VARCHAR2 (2000)
Configuration Assessment Source Instruction for this Control
CONTROL_COMP1 VARCHAR2 (1)
Control Component
CONTROL_COMP2 VARCHAR2 (1)
Control Component
CONTROL_COMP3 VARCHAR2 (1)
Control Component
CONTROL_COMP4 VARCHAR2 (1)
Control Component
CONTROL_COMP5 VARCHAR2 (1)
Control Component
CONTROL_COMP6 VARCHAR2 (1)
Control Component
CONTROL_COMP7 VARCHAR2 (1)
Control Component
CONTROL_COMP8 VARCHAR2 (1)
Control Component
CONTROL_COMP9 VARCHAR2 (1)
Control Component
CONTROL_COMP10 VARCHAR2 (1)
Control Component
CONTROL_COMP11 VARCHAR2 (1)
Control Component
CONTROL_COMP12 VARCHAR2 (1)
Control Component
CONTROL_COMP13 VARCHAR2 (1)
Control Component
CONTROL_COMP14 VARCHAR2 (1)
Control Component
CONTROL_COMP15 VARCHAR2 (1)
Control Component
CONTROL_COMP16 VARCHAR2 (1)
Control Component
CONTROL_COMP17 VARCHAR2 (1)
Control Component
CONTROL_COMP18 VARCHAR2 (1)
Control Component
CONTROL_COMP19 VARCHAR2 (1)
Control Component
CONTROL_COMP20 VARCHAR2 (1)
Control Component
CONTROL_COMP21 VARCHAR2 (1)
Control Component
CONTROL_COMP22 VARCHAR2 (1)
Control Component
CONTROL_COMP23 VARCHAR2 (1)
Control Component
CONTROL_COMP24 VARCHAR2 (1)
Control Component
CONTROL_COMP25 VARCHAR2 (1)
Control Component
CONTROL_COMP26 VARCHAR2 (1)
Control Component
CONTROL_COMP27 VARCHAR2 (1)
Control Component
CONTROL_COMP28 VARCHAR2 (1)
Control Component
CONTROL_COMP29 VARCHAR2 (1)
Control Component
CONTROL_COMP30 VARCHAR2 (1)
Control Component
VERIFICATION_SOURCE VARCHAR2 (1)
Configuration Assessment Source for this Control
UOM_CODE VARCHAR2 (30)
Stores the Unit of measure for control frequency
CONTROL_FREQUENCY NUMBER

Store the control frequency
CTRL_PURPOSE1 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE10 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE11 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE12 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE13 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE14 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE15 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE16 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE17 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE18 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE19 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE2 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE20 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE22 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE23 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE24 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE25 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE26 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE27 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE28 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE29 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE3 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE30 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE4 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE5 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE6 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE7 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE8 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE21 VARCHAR2 (1)
Stores the control purpose
CTRL_PURPOSE9 VARCHAR2 (1)
Stores the control purpose
CLASSIFICATION NUMBER

Stores the control classification
Query Text

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


SELECT BATCH_ID
,      CTRL_INTERFACE_ID
,      CONTROL_APPROVAL_STATUS_CODE
,      CONTROL_ATTRIBUTE_CATEGORY
,      CONTROL_ATTRIBUTE1
,      CONTROL_ATTRIBUTE2
,      CONTROL_ATTRIBUTE3
,      CONTROL_ATTRIBUTE4
,      CONTROL_ATTRIBUTE5
,      CONTROL_ATTRIBUTE6
,      CONTROL_ATTRIBUTE7
,      CONTROL_ATTRIBUTE8
,      CONTROL_ATTRIBUTE9
,      CONTROL_ATTRIBUTE10
,      CONTROL_ATTRIBUTE11
,      CONTROL_ATTRIBUTE12
,      CONTROL_ATTRIBUTE13
,      CONTROL_ATTRIBUTE14
,      CONTROL_ATTRIBUTE15
,      CONTROL_AUTOMATION_TYPE_CODE
,      CONTROL_DESCRIPTION
,      CONTROL_JOB_ID
,      CONTROL_LOCATION_CODE
,      CONTROL_NAME
,      CONTROL_ORG_SYS_REF
,      CONTROL_SOURCE
,      CONTROL_SOURCE_TYPE
,      CONTROL_TYPE_CODE
,      CREATED_BY
,      CREATION_DATE
,      ERROR_FLAG
,      INTERFACE_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PHYSICAL_EVIDENCE
,      PROCESS_FLAG
,      REQUESTOR_ID
,      REVISE_CTRL_FLAG
,      CONTROL_OBJ1
,      CONTROL_OBJ2
,      CONTROL_OBJ3
,      CONTROL_OBJ4
,      CONTROL_OBJ5
,      CONTROL_OBJ6
,      CONTROL_OBJ7
,      CONTROL_OBJ8
,      CONTROL_OBJ9
,      CONTROL_OBJ10
,      CONTROL_OBJ11
,      CONTROL_OBJ12
,      CONTROL_OBJ13
,      CONTROL_OBJ14
,      CONTROL_OBJ15
,      CONTROL_OBJ16
,      CONTROL_OBJ17
,      CONTROL_OBJ18
,      CONTROL_OBJ19
,      CONTROL_OBJ20
,      CONTROL_OBJ21
,      CONTROL_OBJ22
,      CONTROL_OBJ23
,      CONTROL_OBJ24
,      CONTROL_OBJ25
,      CONTROL_OBJ26
,      CONTROL_OBJ27
,      CONTROL_OBJ28
,      CONTROL_OBJ29
,      CONTROL_OBJ30
,      CONTROL_ASSERT1
,      CONTROL_ASSERT2
,      CONTROL_ASSERT3
,      CONTROL_ASSERT4
,      CONTROL_ASSERT5
,      CONTROL_ASSERT6
,      CONTROL_ASSERT7
,      CONTROL_ASSERT8
,      CONTROL_ASSERT9
,      CONTROL_ASSERT10
,      CONTROL_ASSERT11
,      CONTROL_ASSERT12
,      CONTROL_ASSERT13
,      CONTROL_ASSERT14
,      CONTROL_ASSERT15
,      CONTROL_ASSERT16
,      CONTROL_ASSERT17
,      CONTROL_ASSERT18
,      CONTROL_ASSERT19
,      CONTROL_ASSERT20
,      CONTROL_ASSERT21
,      CONTROL_ASSERT22
,      CONTROL_ASSERT23
,      CONTROL_ASSERT24
,      CONTROL_ASSERT25
,      CONTROL_ASSERT26
,      CONTROL_ASSERT27
,      CONTROL_ASSERT28
,      CONTROL_ASSERT29
,      CONTROL_ASSERT30
,      CONTROL_APPLICATION_ID
,      PREVENTIVE_CONTROL
,      DETECTIVE_CONTROL
,      DISCLOSURE_CONTROL
,      KEY_MITIGATING
,      VERIFICATION_SOURCE_NAME
,      VERIFICATION_INSTRUCTION
,      CONTROL_COMP1
,      CONTROL_COMP2
,      CONTROL_COMP3
,      CONTROL_COMP4
,      CONTROL_COMP5
,      CONTROL_COMP6
,      CONTROL_COMP7
,      CONTROL_COMP8
,      CONTROL_COMP9
,      CONTROL_COMP10
,      CONTROL_COMP11
,      CONTROL_COMP12
,      CONTROL_COMP13
,      CONTROL_COMP14
,      CONTROL_COMP15
,      CONTROL_COMP16
,      CONTROL_COMP17
,      CONTROL_COMP18
,      CONTROL_COMP19
,      CONTROL_COMP20
,      CONTROL_COMP21
,      CONTROL_COMP22
,      CONTROL_COMP23
,      CONTROL_COMP24
,      CONTROL_COMP25
,      CONTROL_COMP26
,      CONTROL_COMP27
,      CONTROL_COMP28
,      CONTROL_COMP29
,      CONTROL_COMP30
,      VERIFICATION_SOURCE
,      UOM_CODE
,      CONTROL_FREQUENCY
,      CTRL_PURPOSE1
,      CTRL_PURPOSE10
,      CTRL_PURPOSE11
,      CTRL_PURPOSE12
,      CTRL_PURPOSE13
,      CTRL_PURPOSE14
,      CTRL_PURPOSE15
,      CTRL_PURPOSE16
,      CTRL_PURPOSE17
,      CTRL_PURPOSE18
,      CTRL_PURPOSE19
,      CTRL_PURPOSE2
,      CTRL_PURPOSE20
,      CTRL_PURPOSE22
,      CTRL_PURPOSE23
,      CTRL_PURPOSE24
,      CTRL_PURPOSE25
,      CTRL_PURPOSE26
,      CTRL_PURPOSE27
,      CTRL_PURPOSE28
,      CTRL_PURPOSE29
,      CTRL_PURPOSE3
,      CTRL_PURPOSE30
,      CTRL_PURPOSE4
,      CTRL_PURPOSE5
,      CTRL_PURPOSE6
,      CTRL_PURPOSE7
,      CTRL_PURPOSE8
,      CTRL_PURPOSE21
,      CTRL_PURPOSE9
,      CLASSIFICATION
FROM AMW.AMW_CTRL_INTERFACE;

Dependencies

[top of page]

AMW.AMW_CTRL_INTERFACE does not reference any database object

AMW.AMW_CTRL_INTERFACE is referenced by following:

SchemaAPPS
SynonymAMW_CTRL_INTERFACE