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

TABLE: AMW.AMW_RCM_ORG_INTERFACE

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


Used in webadi for uploading risks and controls for an organization


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_RCM_ORG_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnRCM_ORG_INTERFACE_ID
AMW_RCM_ORG_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnCREATED_BY
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes Store the batch Id
RCM_ORG_INTERFACE_ID NUMBER
Yes Interface Identifier
CONTROL_APPROVAL_STATUS_CODE VARCHAR2 (30)
Control Approval Status Code
CONTROL_AUTOMATION_TYPE_CODE VARCHAR2 (100)
Control Automation Type Code
CONTROL_DESCRIPTION VARCHAR2 (4000)
Control Description
CONTROL_JOB_ID VARCHAR2 (240)
Control Job Id
CONTROL_LOCATION_CODE VARCHAR2 (100)
Control Location Code
CONTROL_NAME VARCHAR2 (240)
Control Name
CONTROL_SOURCE VARCHAR2 (150)
Control Source
CONTROL_SOURCE_TYPE VARCHAR2 (240)
Control Source Type
CONTROL_TYPE_CODE VARCHAR2 (100)
Control Type Code
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
ERROR_FLAG VARCHAR2 (1)
Error Flag
INTERFACE_STATUS VARCHAR2 (2000)
Interface Status
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)
Process Flag
PROCESS_NAME VARCHAR2 (80)
Processs Name
PROCESS_CODE VARCHAR2 (30)
Process Code
REQUESTOR_ID NUMBER

Party Id of the user of requested the Concurrent Program
RISK_APPROVAL_DATE DATE

Risk Approval Date
RISK_APPROVAL_STATUS_CODE VARCHAR2 (30)
Risk Approval Status Code
RISK_DESCRIPTION VARCHAR2 (4000) Yes Risk Description
RISK_IMPACT_CODE VARCHAR2 (240) Yes Risk Impact Code
RISK_NAME VARCHAR2 (240) Yes Risk Name
RISK_LIKELIHOOD_CODE VARCHAR2 (30) Yes Risk Likelihood Code
PROCESS_ID NUMBER

Process Id
REVISE_RISK_FLAG VARCHAR2 (1)
Revise Risk Flag
REVISE_CTRL_FLAG VARCHAR2 (1)
Revise Control Flag
CONTROL_APPLICATION_ID NUMBER

Control Source application Id
RISK_TYPE_MSG VARCHAR2 (240)
Risk Type Message
ASSOCIATION_MSG VARCHAR2 (240)
Association Message
MATERIAL VARCHAR2 (1)
Material
MATERIAL_VALUE NUMBER

Material Value
AP_NAME NUMBER

Audit Proceedure Name
PREVENTIVE_CONTROL VARCHAR2 (1)
Preventive Control
DETECTIVE_CONTROL VARCHAR2 (1)
Detective Control
DISCLOSURE_CONTROL VARCHAR2 (1)
Disclosure Control
KEY_MITIGATING VARCHAR2 (1)
Key Mitigating
VERIFICATION_SOURCE_NAME VARCHAR2 (240)
Verification Source Name
VERIFICATION_INSTRUCTION VARCHAR2 (2000)
verification Instruction
VERIFICATION_SOURCE VARCHAR2 (1)
Verification Source
DESIGN_EFFECTIVENESS VARCHAR2 (1)
Design Effectiveness
OP_EFFECTIVENESS VARCHAR2 (1)
Operation Effectiveness
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_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_COMP1 VARCHAR2 (1)
Control Components
CONTROL_COMP2 VARCHAR2 (1)
Control Components
CONTROL_COMP3 VARCHAR2 (1)
Control Components
CONTROL_COMP4 VARCHAR2 (1)
Control Components
CONTROL_COMP5 VARCHAR2 (1)
Control Components
CONTROL_COMP6 VARCHAR2 (1)
Control Components
CONTROL_COMP7 VARCHAR2 (1)
Control Components
CONTROL_COMP8 VARCHAR2 (1)
Control Components
CONTROL_COMP9 VARCHAR2 (1)
Control Components
CONTROL_COMP10 VARCHAR2 (1)
Control Components
CONTROL_COMP11 VARCHAR2 (1)
Control Components
CONTROL_COMP12 VARCHAR2 (1)
Control Components
CONTROL_COMP13 VARCHAR2 (1)
Control Components
CONTROL_COMP14 VARCHAR2 (1)
Control Components
CONTROL_COMP15 VARCHAR2 (1)
Control Components
CONTROL_COMP16 VARCHAR2 (1)
Control Components
CONTROL_COMP17 VARCHAR2 (1)
Control Components
CONTROL_COMP18 VARCHAR2 (1)
Control Components
CONTROL_COMP19 VARCHAR2 (1)
Control Components
CONTROL_COMP20 VARCHAR2 (1)
Control Components
CONTROL_COMP21 VARCHAR2 (1)
Control Components
CONTROL_COMP22 VARCHAR2 (1)
Control Components
CONTROL_COMP23 VARCHAR2 (1)
Control Components
CONTROL_COMP24 VARCHAR2 (1)
Control Components
CONTROL_COMP25 VARCHAR2 (1)
Control Components
CONTROL_COMP26 VARCHAR2 (1)
Control Components
CONTROL_COMP27 VARCHAR2 (1)
Control Components
CONTROL_COMP28 VARCHAR2 (1)
Control Components
CONTROL_COMP29 VARCHAR2 (1)
Control Components
CONTROL_COMP30 VARCHAR2 (1)
Control Components
RISK_TYPE1 VARCHAR2 (1)
Risk Type
RISK_TYPE2 VARCHAR2 (1)
Risk Type
RISK_TYPE3 VARCHAR2 (1)
Risk Type
RISK_TYPE4 VARCHAR2 (1)
Risk Type
RISK_TYPE5 VARCHAR2 (1)
Risk Type
RISK_TYPE6 VARCHAR2 (1)
Risk Type
RISK_TYPE7 VARCHAR2 (1)
Risk Type
RISK_TYPE8 VARCHAR2 (1)
Risk Type
RISK_TYPE9 VARCHAR2 (1)
Risk Type
RISK_TYPE10 VARCHAR2 (1)
Risk Type
RISK_TYPE11 VARCHAR2 (1)
Risk Type
RISK_TYPE12 VARCHAR2 (1)
Risk Type
RISK_TYPE13 VARCHAR2 (1)
Risk Type
RISK_TYPE14 VARCHAR2 (1)
Risk Type
RISK_TYPE15 VARCHAR2 (1)
Risk Type
RISK_TYPE16 VARCHAR2 (1)
Risk Type
RISK_TYPE17 VARCHAR2 (1)
Risk Type
RISK_TYPE18 VARCHAR2 (1)
Risk Type
RISK_TYPE19 VARCHAR2 (1)
Risk Type
RISK_TYPE20 VARCHAR2 (1)
Risk Type
RISK_TYPE21 VARCHAR2 (1)
Risk Type
RISK_TYPE22 VARCHAR2 (1)
Risk Type
RISK_TYPE23 VARCHAR2 (1)
Risk Type
RISK_TYPE24 VARCHAR2 (1)
Risk Type
RISK_TYPE25 VARCHAR2 (1)
Risk Type
RISK_TYPE26 VARCHAR2 (1)
Risk Type
RISK_TYPE27 VARCHAR2 (1)
Risk Type
RISK_TYPE28 VARCHAR2 (1)
Risk Type
RISK_TYPE29 VARCHAR2 (1)
Risk Type
RISK_TYPE30 VARCHAR2 (1)
Risk Type
ORGANIZATION_ID NUMBER

Stores the organization Id
PROCESS_OBJECTIVE_NAME VARCHAR2 (240)
Process Objective Name
PROCESS_OBJ_DESCRIPTION VARCHAR2 (4000)
Process Objective Description
RISK_CLASSIFICATION NUMBER

Risk Classification
CTRL_CLASSIFICATION NUMBER

Control Classificat
UOM_CODE VARCHAR2 (30)
Control Frequency Unit Of measure
Query Text

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


SELECT BATCH_ID
,      RCM_ORG_INTERFACE_ID
,      CONTROL_APPROVAL_STATUS_CODE
,      CONTROL_AUTOMATION_TYPE_CODE
,      CONTROL_DESCRIPTION
,      CONTROL_JOB_ID
,      CONTROL_LOCATION_CODE
,      CONTROL_NAME
,      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
,      PROCESS_NAME
,      PROCESS_CODE
,      REQUESTOR_ID
,      RISK_APPROVAL_DATE
,      RISK_APPROVAL_STATUS_CODE
,      RISK_DESCRIPTION
,      RISK_IMPACT_CODE
,      RISK_NAME
,      RISK_LIKELIHOOD_CODE
,      PROCESS_ID
,      REVISE_RISK_FLAG
,      REVISE_CTRL_FLAG
,      CONTROL_APPLICATION_ID
,      RISK_TYPE_MSG
,      ASSOCIATION_MSG
,      MATERIAL
,      MATERIAL_VALUE
,      AP_NAME
,      PREVENTIVE_CONTROL
,      DETECTIVE_CONTROL
,      DISCLOSURE_CONTROL
,      KEY_MITIGATING
,      VERIFICATION_SOURCE_NAME
,      VERIFICATION_INSTRUCTION
,      VERIFICATION_SOURCE
,      DESIGN_EFFECTIVENESS
,      OP_EFFECTIVENESS
,      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_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
,      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
,      ORGANIZATION_ID
,      PROCESS_OBJECTIVE_NAME
,      PROCESS_OBJ_DESCRIPTION
,      RISK_CLASSIFICATION
,      CTRL_CLASSIFICATION
,      UOM_CODE
FROM AMW.AMW_RCM_ORG_INTERFACE;

Dependencies

[top of page]

AMW.AMW_RCM_ORG_INTERFACE does not reference any database object

AMW.AMW_RCM_ORG_INTERFACE is referenced by following:

SchemaAPPS
SynonymAMW_RCM_ORG_INTERFACE