eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AMW_FIN_CERT_CTRL_SUM_V

Source

View Text - Preformatted


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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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

View Text - HTML Formatted

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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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_VERIFIED') 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