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


TABLE: AMW.AMW_RISK_CTRL_INTERFACE

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


Used for Web ADI when uploading Risk and Control


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_RISK_CTRL_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnRISK_CONTROL_INTERFACE_ID
AMW_RISK_CTRL_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnCREATED_BY
Columns
Name Datatype Length Mandatory Comments
CONTROL_COMP11 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
BATCH_ID NUMBER
Yes Batch Unique Identifier
CONTROL_COMP17 VARCHAR2 (1)
Control Component
CONTROL_COMP18 VARCHAR2 (1)
Control Component
CONTROL_APPROVAL_STATUS_CODE VARCHAR2 (30)
Control Approval Status
CONTROL_COMP2 VARCHAR2 (1)
Control Component
CONTROL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield structure defining column
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_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment
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_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment
CONTROL_COMP28 VARCHAR2 (1)
Control Component
CONTROL_COMP29 VARCHAR2 (1)
Control Component
CONTROL_COMP3 VARCHAR2 (1)
Control Component
CONTROL_COMP30 VARCHAR2 (1)
Control Component
CONTROL_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment
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_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment
CONTROL_COMP8 VARCHAR2 (1)
Control Component
CONTROL_COMP9 VARCHAR2 (1)
Control Component
DETECTIVE_CONTROL VARCHAR2 (1)
Determines whether Control is Detective in nature
DISCLOSURE_CONTROL VARCHAR2 (1)
Determines whether Control can be disclosed
CONTROL_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment
CONTROL_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment
CONTROL_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment
CONTROL_COMP12 VARCHAR2 (1)
Control Component
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_AUTOMATION_TYPE_CODE VARCHAR2 (100)
Contrl Automation Type
CONTROL_DESCRIPTION VARCHAR2 (4000)
Control Description
CONTROL_JOB_ID VARCHAR2 (240)
Control Job Identifier
CONTROL_APPLICATION_ID NUMBER

Controil Application Identifier
CONTROL_LOCATION_CODE VARCHAR2 (100)
Control Location lookup code
CONTROL_NAME VARCHAR2 (240)
Control Name
CONTROL_ORG_SYS_REF VARCHAR2 (240)
Control Org System Reference - not used
CONTROL_SOURCE VARCHAR2 (150)
Control Source
KEY_MITIGATING VARCHAR2 (1)
Determines whether this Control is Key or Mitigating
CONTROL_COMP19 VARCHAR2 (1)
Control Component
CONTROL_SOURCE_TYPE VARCHAR2 (240)
Control Source Type
CONTROL_TYPE_CODE VARCHAR2 (100)
Control Type
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
ERROR_FLAG VARCHAR2 (1)
Determines whether this row errored or not: Y or N
INTERFACE_STATUS VARCHAR2 (2000)
Interface Status for the processing of this row
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
PHYSICAL_EVIDENCE VARCHAR2 (240)
Physical Evidence
PROCESS_FLAG VARCHAR2 (1)
Determines whether or not this row was successfully processed or not: Y or N
PROCESS_NAME VARCHAR2 (80)
Process Name
REQUESTOR_ID NUMBER

Requestor Identifier
RISK_APPROVAL_DATE DATE

Risk Approval Date
RISK_APPROVAL_STATUS_CODE VARCHAR2 (30)
Risk Approval Status
RISK_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield structure defining column
RISK_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segement
RISK_CONTROL_INTERFACE_ID NUMBER
Yes RIsk Control Interface Identifier - PK for this table
RISK_DESCRIPTION VARCHAR2 (4000) Yes Risk Description
RISK_IMPACT_CODE VARCHAR2 (240) Yes Risk Impact lookup code
RISK_NAME VARCHAR2 (240) Yes Risk Name
RISK_ORG_SYS_REF VARCHAR2 (240)
Risk Org System Reference
RISK_TYPE_CODE VARCHAR2 (100)
Risk Type lookup code
RISK_LIKELIHOOD_CODE VARCHAR2 (30) Yes Risk Likelihood lookup code
PROCESS_ID NUMBER

Process Identifier
PARENT_PROCESS_ID NUMBER

Parent Process Identifier
REVISE_RISK_FLAG VARCHAR2 (1)
Revise / Update this Risk: Y or N
REVISE_CTRL_FLAG VARCHAR2 (1)
Revise / Update this Control: Y or N
CONTROL_OBJ1 VARCHAR2 (1)
Control Objective
CONTROL_OBJ2 VARCHAR2 (1)
Control Objective
CONTROL_OBJ3 VARCHAR2 (1)
Control Objective
CONTROL_OBJ4 VARCHAR2 (1)
Control Objective
CONTROL_OBJ5 VARCHAR2 (1)
Control Objective
CONTROL_OBJ6 VARCHAR2 (1)
Control Objective
CONTROL_OBJ7 VARCHAR2 (1)
Control Objective
CONTROL_OBJ8 VARCHAR2 (1)
Control Objective
CONTROL_OBJ9 VARCHAR2 (1)
Control Objective
CONTROL_OBJ10 VARCHAR2 (1)
Control Objective
CONTROL_OBJ11 VARCHAR2 (1)
Control Objective
CONTROL_OBJ12 VARCHAR2 (1)
Control Objective
CONTROL_OBJ13 VARCHAR2 (1)
Control Objective
CONTROL_OBJ14 VARCHAR2 (1)
Control Objective
CONTROL_OBJ15 VARCHAR2 (1)
Control Objective
CONTROL_OBJ16 VARCHAR2 (1)
Control Objective
CONTROL_OBJ17 VARCHAR2 (1)
Control Objective
CONTROL_OBJ18 VARCHAR2 (1)
Control Objective
CONTROL_OBJ19 VARCHAR2 (1)
Control Objective
CONTROL_OBJ20 VARCHAR2 (1)
Control Objective
CONTROL_OBJ21 VARCHAR2 (1)
Control Objective
CONTROL_OBJ22 VARCHAR2 (1)
Control Objective
CONTROL_OBJ23 VARCHAR2 (1)
Control Objective
CONTROL_OBJ24 VARCHAR2 (1)
Control Objective
CONTROL_COMP1 VARCHAR2 (1)
Control Component
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
RISK_TYPE1 VARCHAR2 (100)
Risk Type
RISK_TYPE2 VARCHAR2 (100)
Risk Type
RISK_TYPE3 VARCHAR2 (100)
Risk Type
RISK_TYPE4 VARCHAR2 (100)
Risk Type
RISK_TYPE5 VARCHAR2 (100)
Risk Type
RISK_TYPE6 VARCHAR2 (100)
Risk Type
RISK_TYPE7 VARCHAR2 (100)
Risk Type
RISK_TYPE8 VARCHAR2 (100)
Risk Type
RISK_TYPE9 VARCHAR2 (100)
Risk Type
RISK_TYPE10 VARCHAR2 (100)
Risk Type
RISK_TYPE11 VARCHAR2 (100)
Risk Type
RISK_TYPE12 VARCHAR2 (100)
Risk Type
RISK_TYPE13 VARCHAR2 (100)
Risk Type
RISK_TYPE14 VARCHAR2 (100)
Risk Type
RISK_TYPE15 VARCHAR2 (100)
Risk Type
RISK_TYPE16 VARCHAR2 (100)
Risk Type
RISK_TYPE17 VARCHAR2 (100)
Risk Type
RISK_TYPE18 VARCHAR2 (100)
Risk Type
RISK_TYPE19 VARCHAR2 (100)
Risk Type
RISK_TYPE20 VARCHAR2 (100)
Risk Type
RISK_TYPE21 VARCHAR2 (100)
Risk Type
RISK_TYPE22 VARCHAR2 (100)
Risk Type
RISK_TYPE23 VARCHAR2 (100)
Risk Type
RISK_TYPE24 VARCHAR2 (100)
Risk Type
RISK_TYPE25 VARCHAR2 (100)
Risk Type
RISK_TYPE26 VARCHAR2 (100)
Risk Type
RISK_TYPE27 VARCHAR2 (100)
Risk Type
RISK_TYPE28 VARCHAR2 (100)
Risk Type
RISK_TYPE29 VARCHAR2 (100)
Risk Type
RISK_TYPE30 VARCHAR2 (100)
Risk Type
PROCESS_OBJECTIVE_ID NUMBER

Process Objective Identifier for Process/Risk association to Process Objective
PROCESS_OBJECTIVE_NAME VARCHAR2 (240)
Process Objective Name
PROCESS_OBJ_DESCRIPTION VARCHAR2 (4000)
Process Objective Description
RISK_TYPE_MSG VARCHAR2 (240)
Risk Type Context Message
ASSOCIATION_MSG VARCHAR2 (240)
Association Context Message
MATERIAL VARCHAR2 (1)
Indicates if Risk is Material Risk or not
MATERIAL_VALUE NUMBER

Indicates Material Value of Risk for Process - Risk association
AP_NAME NUMBER

Associated Audit Procedure Name
CONTROL_COMP10 VARCHAR2 (1)
Control Component
VERIFICATION_SOURCE_NAME VARCHAR2 (240)
Verification Source Name
VERIFICATION_SOURCE VARCHAR2 (1)
Verification Source
VERIFICATION_INSTRUCTION VARCHAR2 (2000)
Verification Instruction
PREVENTIVE_CONTROL VARCHAR2 (1)
Determines whether or not this Control is Preventive in nature
DESIGN_EFFECTIVENESS VARCHAR2 (1)
Ap Association Design Effectiveness
OP_EFFECTIVENESS VARCHAR2 (1)
Ap Association Operating Effectiveness
PROCESS_CODE VARCHAR2 (30)
Process Code
RISK_CLASSIFICATION NUMBER

Risk Classification
CTRL_CLASSIFICATION NUMBER

Control Classification
UOM_CODE VARCHAR2 (30)
Control frequency Unit Of Measure code
Query Text

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


SELECT CONTROL_COMP11
,      CONTROL_COMP13
,      CONTROL_COMP14
,      CONTROL_COMP15
,      CONTROL_COMP16
,      BATCH_ID
,      CONTROL_COMP17
,      CONTROL_COMP18
,      CONTROL_APPROVAL_STATUS_CODE
,      CONTROL_COMP2
,      CONTROL_ATTRIBUTE_CATEGORY
,      CONTROL_COMP20
,      CONTROL_COMP21
,      CONTROL_COMP22
,      CONTROL_COMP23
,      CONTROL_ATTRIBUTE1
,      CONTROL_COMP24
,      CONTROL_COMP25
,      CONTROL_COMP26
,      CONTROL_COMP27
,      CONTROL_ATTRIBUTE10
,      CONTROL_COMP28
,      CONTROL_COMP29
,      CONTROL_COMP3
,      CONTROL_COMP30
,      CONTROL_ATTRIBUTE11
,      CONTROL_COMP4
,      CONTROL_COMP5
,      CONTROL_COMP6
,      CONTROL_COMP7
,      CONTROL_ATTRIBUTE12
,      CONTROL_COMP8
,      CONTROL_COMP9
,      DETECTIVE_CONTROL
,      DISCLOSURE_CONTROL
,      CONTROL_ATTRIBUTE13
,      CONTROL_ATTRIBUTE14
,      CONTROL_ATTRIBUTE15
,      CONTROL_COMP12
,      CONTROL_ATTRIBUTE2
,      CONTROL_ATTRIBUTE3
,      CONTROL_ATTRIBUTE4
,      CONTROL_ATTRIBUTE5
,      CONTROL_ATTRIBUTE6
,      CONTROL_ATTRIBUTE7
,      CONTROL_ATTRIBUTE8
,      CONTROL_ATTRIBUTE9
,      CONTROL_AUTOMATION_TYPE_CODE
,      CONTROL_DESCRIPTION
,      CONTROL_JOB_ID
,      CONTROL_APPLICATION_ID
,      CONTROL_LOCATION_CODE
,      CONTROL_NAME
,      CONTROL_ORG_SYS_REF
,      CONTROL_SOURCE
,      KEY_MITIGATING
,      CONTROL_COMP19
,      CONTROL_SOURCE_TYPE
,      CONTROL_TYPE_CODE
,      CREATED_BY
,      CREATION_DATE
,      ERROR_FLAG
,      INTERFACE_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PHYSICAL_EVIDENCE
,      PROCESS_FLAG
,      PROCESS_NAME
,      REQUESTOR_ID
,      RISK_APPROVAL_DATE
,      RISK_APPROVAL_STATUS_CODE
,      RISK_ATTRIBUTE_CATEGORY
,      RISK_ATTRIBUTE1
,      RISK_ATTRIBUTE10
,      RISK_ATTRIBUTE11
,      RISK_ATTRIBUTE12
,      RISK_ATTRIBUTE13
,      RISK_ATTRIBUTE14
,      RISK_ATTRIBUTE15
,      RISK_ATTRIBUTE2
,      RISK_ATTRIBUTE3
,      RISK_ATTRIBUTE4
,      RISK_ATTRIBUTE5
,      RISK_ATTRIBUTE6
,      RISK_ATTRIBUTE7
,      RISK_ATTRIBUTE8
,      RISK_ATTRIBUTE9
,      RISK_CONTROL_INTERFACE_ID
,      RISK_DESCRIPTION
,      RISK_IMPACT_CODE
,      RISK_NAME
,      RISK_ORG_SYS_REF
,      RISK_TYPE_CODE
,      RISK_LIKELIHOOD_CODE
,      PROCESS_ID
,      PARENT_PROCESS_ID
,      REVISE_RISK_FLAG
,      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_COMP1
,      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
,      RISK_TYPE1
,      RISK_TYPE2
,      RISK_TYPE3
,      RISK_TYPE4
,      RISK_TYPE5
,      RISK_TYPE6
,      RISK_TYPE7
,      RISK_TYPE8
,      RISK_TYPE9
,      RISK_TYPE10
,      RISK_TYPE11
,      RISK_TYPE12
,      RISK_TYPE13
,      RISK_TYPE14
,      RISK_TYPE15
,      RISK_TYPE16
,      RISK_TYPE17
,      RISK_TYPE18
,      RISK_TYPE19
,      RISK_TYPE20
,      RISK_TYPE21
,      RISK_TYPE22
,      RISK_TYPE23
,      RISK_TYPE24
,      RISK_TYPE25
,      RISK_TYPE26
,      RISK_TYPE27
,      RISK_TYPE28
,      RISK_TYPE29
,      RISK_TYPE30
,      PROCESS_OBJECTIVE_ID
,      PROCESS_OBJECTIVE_NAME
,      PROCESS_OBJ_DESCRIPTION
,      RISK_TYPE_MSG
,      ASSOCIATION_MSG
,      MATERIAL
,      MATERIAL_VALUE
,      AP_NAME
,      CONTROL_COMP10
,      VERIFICATION_SOURCE_NAME
,      VERIFICATION_SOURCE
,      VERIFICATION_INSTRUCTION
,      PREVENTIVE_CONTROL
,      DESIGN_EFFECTIVENESS
,      OP_EFFECTIVENESS
,      PROCESS_CODE
,      RISK_CLASSIFICATION
,      CTRL_CLASSIFICATION
,      UOM_CODE
FROM AMW.AMW_RISK_CTRL_INTERFACE;

Dependencies

[top of page]

AMW.AMW_RISK_CTRL_INTERFACE does not reference any database object

AMW.AMW_RISK_CTRL_INTERFACE is referenced by following:

SchemaAPPS
SynonymAMW_RISK_CTRL_INTERFACE