View: AMW_FIN_CERT_CTRL_SUM_V

Product:	AMW - Internal Controls Manager
Description:	A View on top of AMW_FIN_CERT_CTRL_SUM to get all of control related information within a fiancial certification.
Implementation/DBA Data:	APPS.AMW_FIN_CERT_CTRL_SUM_V

View Text

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

Columns