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

VIEW: APPS.AMW_FIN_CERT_CTRL_SUM_V

Object Details
Object Name: AMW_FIN_CERT_CTRL_SUM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_FIN_CERT_CTRL_SUM_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


A View on top of AMW_FIN_CERT_CTRL_SUM to get all of control related information within a fiancial certification.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FIN_CERTIFICATION_ID NUMBER
Yes financial certification id
FINANCIAL_STATEMENT_ID NUMBER
Yes financial statement id
FINANCIAL_ITEM_ID NUMBER

financial item id
ACCOUNT_GROUP_ID NUMBER

account group id
NATURAL_ACCOUNT_ID NUMBER

natural account id
OBJECT_TYPE VARCHAR2 (30)
object type can be either ACCOUNT or FINANCIAL ITEM
CTRL_ATTRIBUTE_TYPE VARCHAR2 (30)
CONTROL ATTRIBUTE TYPE
CTRL_ATTR_CODE_1 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_1 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_1 NUMBER

Total number of controls
CTRL_ATTR_CODE_2 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_2 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_2 NUMBER

Total number of controls
CTRL_ATTR_CODE_3 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_3 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_3 NUMBER

Total number of controls
CTRL_ATTR_CODE_4 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_4 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_4 NUMBER

Total number of controls
CTRL_ATTR_CODE_5 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_5 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_5 NUMBER

Total number of controls
CTRL_ATTR_CODE_6 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_6 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_6 NUMBER

Total number of controls
CTRL_ATTR_CODE_7 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_7 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_7 NUMBER

Total number of controls
CTRL_ATTR_CODE_8 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_8 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_8 NUMBER

Total number of controls
CTRL_ATTR_CODE_9 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_9 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_9 NUMBER

Total number of controls
CTRL_ATTR_CODE_10 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_10 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_10 NUMBER

Total number of controls
CTRL_ATTR_CODE_11 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_11 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_11 NUMBER

Total number of controls
CTRL_ATTR_CODE_12 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_12 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_12 NUMBER

Total number of controls
CTRL_ATTR_CODE_13 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_13 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_13 NUMBER

Total number of controls
CTRL_ATTR_CODE_14 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_14 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_14 NUMBER

Total number of controls
CTRL_ATTR_CODE_15 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_15 NUMBER

Ineffective Controls
TOTAL_CTRL_ATTR_15 NUMBER

Total number of controls
CTRL_ATTR_CODE_16 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_16 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_16 NUMBER

Total number of controls
CTRL_ATTR_CODE_17 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_17 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_17 NUMBER

Total number of controls
CTRL_ATTR_CODE_18 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_18 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_18 NUMBER

Total number of controls
CTRL_ATTR_CODE_19 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_19 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_19 NUMBER

Total number of controls
CTRL_ATTR_CODE_20 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_20 NUMBER

ineffective controls
TOTAL_CTRL_ATTR_20 NUMBER

Total number of controls
CTRL_ATTR_CODE_21 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_21 NUMBER

ineffective controls
TOTAL_CTRL_ATTR_21 NUMBER

Total number of controls
CTRL_ATTR_CODE_22 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_22 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_22 NUMBER

Total number of controls
CTRL_ATTR_CODE_23 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_23 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_23 NUMBER

Total number of controls
CTRL_ATTR_CODE_24 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_24 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_24 NUMBER

Total number of controls
CTRL_ATTR_CODE_25 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_25 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_25 NUMBER

Total number of controls
CTRL_ATTR_CODE_26 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_26 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_26 NUMBER

Total number of controls
CTRL_ATTR_CODE_27 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_27 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_27 NUMBER

Total number of controls
CTRL_ATTR_CODE_28 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_28 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_28 NUMBER

Total number of controls
CTRL_ATTR_CODE_29 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_29 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_29 NUMBER

Total number of controls
CTRL_ATTR_CODE_30 VARCHAR2 (30)
Control Attribute Code
INEFF_CTRL_ATTR_30 NUMBER

Number of ineffective controls
TOTAL_CTRL_ATTR_30 NUMBER

Total number of controls
ACC_ASSERT_FLAG_1 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_2 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_3 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_4 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_5 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_6 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_7 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_8 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_9 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_10 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_11 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_12 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_13 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_14 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_15 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_16 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_17 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_18 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_19 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_20 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_21 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_22 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_23 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_24 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_25 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_26 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_27 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_28 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_29 VARCHAR2 (1)
Account Assertion Flag
ACC_ASSERT_FLAG_30 VARCHAR2 (1)
Account Assertion Flag
EVAL_CTRL_ATTR_1 NUMBER

evaluated controls
EVAL_CTRL_ATTR_2 NUMBER

evaluated controls
EVAL_CTRL_ATTR_3 NUMBER

evaluated controls
EVAL_CTRL_ATTR_4 NUMBER

evaluated controls
EVAL_CTRL_ATTR_5 NUMBER

evaluated controls
EVAL_CTRL_ATTR_6 NUMBER

evaluated controls
EVAL_CTRL_ATTR_7 NUMBER

evaluated controls
EVAL_CTRL_ATTR_8 NUMBER

evaluated controls
EVAL_CTRL_ATTR_9 NUMBER

evaluated controls
EVAL_CTRL_ATTR_10 NUMBER

evaluated controls
EVAL_CTRL_ATTR_11 NUMBER

evaluated controls
EVAL_CTRL_ATTR_12 NUMBER

evaluated controls
EVAL_CTRL_ATTR_13 NUMBER

evaluated controls
EVAL_CTRL_ATTR_14 NUMBER

evaluated controls
EVAL_CTRL_ATTR_15 NUMBER

evaluated controls
EVAL_CTRL_ATTR_16 NUMBER

evaluated controls
EVAL_CTRL_ATTR_17 NUMBER

evaluated controls
EVAL_CTRL_ATTR_18 NUMBER

evaluated controls
EVAL_CTRL_ATTR_19 NUMBER

evaluated controls
EVAL_CTRL_ATTR_20 NUMBER

evaluated controls
EVAL_CTRL_ATTR_21 NUMBER

evaluated controls
EVAL_CTRL_ATTR_22 NUMBER

evaluated controls
EVAL_CTRL_ATTR_23 NUMBER

evaluated controls
EVAL_CTRL_ATTR_24 NUMBER

evaluated controls
EVAL_CTRL_ATTR_25 NUMBER

evaluated controls
EVAL_CTRL_ATTR_26 NUMBER

evaluated controls
EVAL_CTRL_ATTR_27 NUMBER

evaluated controls
EVAL_CTRL_ATTR_28 NUMBER

evaluated controls
EVAL_CTRL_ATTR_29 NUMBER

evaluated controls
EVAL_CTRL_ATTR_30 NUMBER

evaluated controls
CONTROLS_EXIST_FLAG VARCHAR2 (1)
the flag to indicate if there is any related controls
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SECURITY_GROUP_ID NUMBER

Used for hosting environments
OBJECT_VERSION_NUMBER NUMBER

Object version number for locking
INEFF_CTRL_PRCNT_1 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_2 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_3 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_4 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_5 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_6 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_7 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_8 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_9 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_10 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_11 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_12 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_13 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_14 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_15 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_16 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_17 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_18 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_19 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_20 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_21 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_22 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_23 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_24 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_25 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_26 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_27 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_28 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_29 NUMBER

percentage of ineffective controls
INEFF_CTRL_PRCNT_30 NUMBER

percentage of ineffective controls
INEFF_CTRL_ATTR_BYTOTAL_1 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_2 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_3 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_4 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_5 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_6 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_7 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_8 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_9 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_10 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_11 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_12 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_13 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_14 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_15 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_16 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_17 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_18 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_19 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_20 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_21 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_22 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_23 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_24 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_25 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_26 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_27 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_28 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_29 VARCHAR2 (126)
number of ineffective contols over the total number of controls
INEFF_CTRL_ATTR_BYTOTAL_30 VARCHAR2 (126)
number of ineffective contols over the total number of controls
Query Text

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


SELECT FIN_CERTIFICATION_ID
,      FINANCIAL_STATEMENT_ID
,      FINANCIAL_ITEM_ID
,      ACCOUNT_GROUP_ID
,      NATURAL_ACCOUNT_ID
,      OBJECT_TYPE
,      CTRL_ATTRIBUTE_TYPE
,      CTRL_ATTR_CODE_1
,      INEFF_CTRL_ATTR_1
,      TOTAL_CTRL_ATTR_1
,      CTRL_ATTR_CODE_2
,      INEFF_CTRL_ATTR_2
,      TOTAL_CTRL_ATTR_2
,      CTRL_ATTR_CODE_3
,      INEFF_CTRL_ATTR_3
,      TOTAL_CTRL_ATTR_3
,      CTRL_ATTR_CODE_4
,      INEFF_CTRL_ATTR_4
,      TOTAL_CTRL_ATTR_4
,      CTRL_ATTR_CODE_5
,      INEFF_CTRL_ATTR_5
,      TOTAL_CTRL_ATTR_5
,      CTRL_ATTR_CODE_6
,      INEFF_CTRL_ATTR_6
,      TOTAL_CTRL_ATTR_6
,      CTRL_ATTR_CODE_7
,      INEFF_CTRL_ATTR_7
,      TOTAL_CTRL_ATTR_7
,      CTRL_ATTR_CODE_8
,      INEFF_CTRL_ATTR_8
,      TOTAL_CTRL_ATTR_8
,      CTRL_ATTR_CODE_9
,      INEFF_CTRL_ATTR_9
,      TOTAL_CTRL_ATTR_9
,      CTRL_ATTR_CODE_10
,      INEFF_CTRL_ATTR_10
,      TOTAL_CTRL_ATTR_10
,      CTRL_ATTR_CODE_11
,      INEFF_CTRL_ATTR_11
,      TOTAL_CTRL_ATTR_11
,      CTRL_ATTR_CODE_12
,      INEFF_CTRL_ATTR_12
,      TOTAL_CTRL_ATTR_12
,      CTRL_ATTR_CODE_13
,      INEFF_CTRL_ATTR_13
,      TOTAL_CTRL_ATTR_13
,      CTRL_ATTR_CODE_14
,      INEFF_CTRL_ATTR_14
,      TOTAL_CTRL_ATTR_14
,      CTRL_ATTR_CODE_15
,      INEFF_CTRL_ATTR_15
,      TOTAL_CTRL_ATTR_15
,      CTRL_ATTR_CODE_16
,      INEFF_CTRL_ATTR_16
,      TOTAL_CTRL_ATTR_16
,      CTRL_ATTR_CODE_17
,      INEFF_CTRL_ATTR_17
,      TOTAL_CTRL_ATTR_17
,      CTRL_ATTR_CODE_18
,      INEFF_CTRL_ATTR_18
,      TOTAL_CTRL_ATTR_18
,      CTRL_ATTR_CODE_19
,      INEFF_CTRL_ATTR_19
,      TOTAL_CTRL_ATTR_19
,      CTRL_ATTR_CODE_20
,      INEFF_CTRL_ATTR_20
,      TOTAL_CTRL_ATTR_20
,      CTRL_ATTR_CODE_21
,      INEFF_CTRL_ATTR_21
,      TOTAL_CTRL_ATTR_21
,      CTRL_ATTR_CODE_22
,      INEFF_CTRL_ATTR_22
,      TOTAL_CTRL_ATTR_22
,      CTRL_ATTR_CODE_23
,      INEFF_CTRL_ATTR_23
,      TOTAL_CTRL_ATTR_23
,      CTRL_ATTR_CODE_24
,      INEFF_CTRL_ATTR_24
,      TOTAL_CTRL_ATTR_24
,      CTRL_ATTR_CODE_25
,      INEFF_CTRL_ATTR_25
,      TOTAL_CTRL_ATTR_25
,      CTRL_ATTR_CODE_26
,      INEFF_CTRL_ATTR_26
,      TOTAL_CTRL_ATTR_26
,      CTRL_ATTR_CODE_27
,      INEFF_CTRL_ATTR_27
,      TOTAL_CTRL_ATTR_27
,      CTRL_ATTR_CODE_28
,      INEFF_CTRL_ATTR_28
,      TOTAL_CTRL_ATTR_28
,      CTRL_ATTR_CODE_29
,      INEFF_CTRL_ATTR_29
,      TOTAL_CTRL_ATTR_29
,      CTRL_ATTR_CODE_30
,      INEFF_CTRL_ATTR_30
,      TOTAL_CTRL_ATTR_30
,      ACC_ASSERT_FLAG_1
,      ACC_ASSERT_FLAG_2
,      ACC_ASSERT_FLAG_3
,      ACC_ASSERT_FLAG_4
,      ACC_ASSERT_FLAG_5
,      ACC_ASSERT_FLAG_6
,      ACC_ASSERT_FLAG_7
,      ACC_ASSERT_FLAG_8
,      ACC_ASSERT_FLAG_9
,      ACC_ASSERT_FLAG_10
,      ACC_ASSERT_FLAG_11
,      ACC_ASSERT_FLAG_12
,      ACC_ASSERT_FLAG_13
,      ACC_ASSERT_FLAG_14
,      ACC_ASSERT_FLAG_15
,      ACC_ASSERT_FLAG_16
,      ACC_ASSERT_FLAG_17
,      ACC_ASSERT_FLAG_18
,      ACC_ASSERT_FLAG_19
,      ACC_ASSERT_FLAG_20
,      ACC_ASSERT_FLAG_21
,      ACC_ASSERT_FLAG_22
,      ACC_ASSERT_FLAG_23
,      ACC_ASSERT_FLAG_24
,      ACC_ASSERT_FLAG_25
,      ACC_ASSERT_FLAG_26
,      ACC_ASSERT_FLAG_27
,      ACC_ASSERT_FLAG_28
,      ACC_ASSERT_FLAG_29
,      ACC_ASSERT_FLAG_30
,      EVAL_CTRL_ATTR_1
,      EVAL_CTRL_ATTR_2
,      EVAL_CTRL_ATTR_3
,      EVAL_CTRL_ATTR_4
,      EVAL_CTRL_ATTR_5
,      EVAL_CTRL_ATTR_6
,      EVAL_CTRL_ATTR_7
,      EVAL_CTRL_ATTR_8
,      EVAL_CTRL_ATTR_9
,      EVAL_CTRL_ATTR_10
,      EVAL_CTRL_ATTR_11
,      EVAL_CTRL_ATTR_12
,      EVAL_CTRL_ATTR_13
,      EVAL_CTRL_ATTR_14
,      EVAL_CTRL_ATTR_15
,      EVAL_CTRL_ATTR_16
,      EVAL_CTRL_ATTR_17
,      EVAL_CTRL_ATTR_18
,      EVAL_CTRL_ATTR_19
,      EVAL_CTRL_ATTR_20
,      EVAL_CTRL_ATTR_21
,      EVAL_CTRL_ATTR_22
,      EVAL_CTRL_ATTR_23
,      EVAL_CTRL_ATTR_24
,      EVAL_CTRL_ATTR_25
,      EVAL_CTRL_ATTR_26
,      EVAL_CTRL_ATTR_27
,      EVAL_CTRL_ATTR_28
,      EVAL_CTRL_ATTR_29
,      EVAL_CTRL_ATTR_30
,      CONTROLS_EXIST_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      INEFF_CTRL_PRCNT_1
,      INEFF_CTRL_PRCNT_2
,      INEFF_CTRL_PRCNT_3
,      INEFF_CTRL_PRCNT_4
,      INEFF_CTRL_PRCNT_5
,      INEFF_CTRL_PRCNT_6
,      INEFF_CTRL_PRCNT_7
,      INEFF_CTRL_PRCNT_8
,      INEFF_CTRL_PRCNT_9
,      INEFF_CTRL_PRCNT_10
,      INEFF_CTRL_PRCNT_11
,      INEFF_CTRL_PRCNT_12
,      INEFF_CTRL_PRCNT_13
,      INEFF_CTRL_PRCNT_14
,      INEFF_CTRL_PRCNT_15
,      INEFF_CTRL_PRCNT_16
,      INEFF_CTRL_PRCNT_17
,      INEFF_CTRL_PRCNT_18
,      INEFF_CTRL_PRCNT_19
,      INEFF_CTRL_PRCNT_20
,      INEFF_CTRL_PRCNT_21
,      INEFF_CTRL_PRCNT_22
,      INEFF_CTRL_PRCNT_23
,      INEFF_CTRL_PRCNT_24
,      INEFF_CTRL_PRCNT_25
,      INEFF_CTRL_PRCNT_26
,      INEFF_CTRL_PRCNT_27
,      INEFF_CTRL_PRCNT_28
,      INEFF_CTRL_PRCNT_29
,      INEFF_CTRL_PRCNT_30
,      INEFF_CTRL_ATTR_BYTOTAL_1
,      INEFF_CTRL_ATTR_BYTOTAL_2
,      INEFF_CTRL_ATTR_BYTOTAL_3
,      INEFF_CTRL_ATTR_BYTOTAL_4
,      INEFF_CTRL_ATTR_BYTOTAL_5
,      INEFF_CTRL_ATTR_BYTOTAL_6
,      INEFF_CTRL_ATTR_BYTOTAL_7
,      INEFF_CTRL_ATTR_BYTOTAL_8
,      INEFF_CTRL_ATTR_BYTOTAL_9
,      INEFF_CTRL_ATTR_BYTOTAL_10
,      INEFF_CTRL_ATTR_BYTOTAL_11
,      INEFF_CTRL_ATTR_BYTOTAL_12
,      INEFF_CTRL_ATTR_BYTOTAL_13
,      INEFF_CTRL_ATTR_BYTOTAL_14
,      INEFF_CTRL_ATTR_BYTOTAL_15
,      INEFF_CTRL_ATTR_BYTOTAL_16
,      INEFF_CTRL_ATTR_BYTOTAL_17
,      INEFF_CTRL_ATTR_BYTOTAL_18
,      INEFF_CTRL_ATTR_BYTOTAL_19
,      INEFF_CTRL_ATTR_BYTOTAL_20
,      INEFF_CTRL_ATTR_BYTOTAL_21
,      INEFF_CTRL_ATTR_BYTOTAL_22
,      INEFF_CTRL_ATTR_BYTOTAL_23
,      INEFF_CTRL_ATTR_BYTOTAL_24
,      INEFF_CTRL_ATTR_BYTOTAL_25
,      INEFF_CTRL_ATTR_BYTOTAL_26
,      INEFF_CTRL_ATTR_BYTOTAL_27
,      INEFF_CTRL_ATTR_BYTOTAL_28
,      INEFF_CTRL_ATTR_BYTOTAL_29
,      INEFF_CTRL_ATTR_BYTOTAL_30
FROM APPS.AMW_FIN_CERT_CTRL_SUM_V;

Dependencies

[top of page]

APPS.AMW_FIN_CERT_CTRL_SUM_V references the following:

SchemaAMW
TableAMW_FIN_CERT_CTRL_SUM
SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SchemaPUBLIC
SynonymDUAL

APPS.AMW_FIN_CERT_CTRL_SUM_V is not referenced by any database object