[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMW_CTRL_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | AMW |
| FND Design Data: |  AMW.AMW_CTRL_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
Interface table for Control data in WebADI Upload
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AMW_CTRL_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 CTRL_INTERFACE_ID
|
| AMW_CTRL_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BATCH_ID
CREATED_BY
|
| 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 |
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;
AMW.AMW_CTRL_INTERFACE does not reference any database object
AMW.AMW_CTRL_INTERFACE is referenced by following:
APPS
AMW_CTRL_INTERFACE
|
|
|
|