ACN_IDEA_VL

Details

• Schema: FUSION

• Object owner: ACN

• Object type: VIEW

Columns

Name

IDEA_ID OBJECT_VERSION_NUMBER TYPE STATUS IDEA_NUMBER ALLOW_ACCESSTO_EVERYONE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION CURRENCY_CODE CORP_CURRENCY_CODE CURCY_CONV_RATE_TYPE EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB005 EXTN_ATTRIBUTE_CLOB006 EXTN_ATTRIBUTE_CLOB007 EXTN_ATTRIBUTE_CLOB008 EXTN_ATTRIBUTE_CLOB009 EXTN_ATTRIBUTE_CLOB010 EXTN_ATTRIBUTE_CLOB011 EXTN_ATTRIBUTE_CLOB012 EXTN_ATTRIBUTE_CLOB013 EXTN_ATTRIBUTE_CLOB014 EXTN_ATTRIBUTE_CLOB015 EXTN_ATTRIBUTE_CLOB016 EXTN_ATTRIBUTE_CLOB017 EXTN_ATTRIBUTE_CLOB018 EXTN_ATTRIBUTE_CLOB019 EXTN_ATTRIBUTE_CLOB020 EXTN_ATTRIBUTE_CLOB021 EXTN_ATTRIBUTE_CLOB022 EXTN_ATTRIBUTE_CLOB023 EXTN_ATTRIBUTE_CLOB024 EXTN_ATTRIBUTE_CLOB025 EXTN_ATTRIBUTE_NUMBER201 EXTN_ATTRIBUTE_NUMBER202 EXTN_ATTRIBUTE_NUMBER203 EXTN_ATTRIBUTE_NUMBER204 EXTN_ATTRIBUTE_NUMBER205

Query

SQL_Statement

SELECT ACN_IDEA_B.IDEA_ID IDEA_ID, ACN_IDEA_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACN_IDEA_B.TYPE TYPE, ACN_IDEA_B.STATUS STATUS, ACN_IDEA_B.IDEA_NUMBER IDEA_NUMBER, ACN_IDEA_B.ALLOW_ACCESSTO_EVERYONE ALLOW_ACCESSTO_EVERYONE, ACN_IDEA_B.CREATED_BY CREATED_BY, ACN_IDEA_B.CREATION_DATE CREATION_DATE, ACN_IDEA_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACN_IDEA_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACN_IDEA_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACN_IDEA_TL.NAME NAME, ACN_IDEA_TL.DESCRIPTION DESCRIPTION, ACN_IDEA_B.CURRENCY_CODE CURRENCY_CODE, ACN_IDEA_B.CORP_CURRENCY_CODE CORP_CURRENCY_CODE, ACN_IDEA_B.CURCY_CONV_RATE_TYPE CURCY_CONV_RATE_TYPE, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP011, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_TIMESTAMP012, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP013, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP014, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_TIMESTAMP015, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP016, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP017, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_TIMESTAMP018, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP019, ACN_IDEA_B.EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_TIMESTAMP020, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099, ACN_IDEA_B.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB001, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB002, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB003, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB004, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB005 EXTN_ATTRIBUTE_CLOB005, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB006 EXTN_ATTRIBUTE_CLOB006, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB007 EXTN_ATTRIBUTE_CLOB007, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB008 EXTN_ATTRIBUTE_CLOB008, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB009 EXTN_ATTRIBUTE_CLOB009, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB010 EXTN_ATTRIBUTE_CLOB010, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB011 EXTN_ATTRIBUTE_CLOB011, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB012 EXTN_ATTRIBUTE_CLOB012, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB013 EXTN_ATTRIBUTE_CLOB013, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB014 EXTN_ATTRIBUTE_CLOB014, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB015 EXTN_ATTRIBUTE_CLOB015, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB016 EXTN_ATTRIBUTE_CLOB016, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB017 EXTN_ATTRIBUTE_CLOB017, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB018 EXTN_ATTRIBUTE_CLOB018, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB019 EXTN_ATTRIBUTE_CLOB019, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB020 EXTN_ATTRIBUTE_CLOB020, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB021 EXTN_ATTRIBUTE_CLOB021, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB022 EXTN_ATTRIBUTE_CLOB022, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB023 EXTN_ATTRIBUTE_CLOB023, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB024 EXTN_ATTRIBUTE_CLOB024, ACN_IDEA_B.EXTN_ATTRIBUTE_CLOB025 EXTN_ATTRIBUTE_CLOB025, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER201 EXTN_ATTRIBUTE_NUMBER201, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER202 EXTN_ATTRIBUTE_NUMBER202, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER203 EXTN_ATTRIBUTE_NUMBER203, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER204 EXTN_ATTRIBUTE_NUMBER204, ACN_IDEA_B.EXTN_ATTRIBUTE_NUMBER205 EXTN_ATTRIBUTE_NUMBER205 FROM ACN_IDEA_B, ACN_IDEA_TL WHERE ACN_IDEA_B.IDEA_ID = ACN_IDEA_TL.IDEA_ID AND ACN_IDEA_TL.LANGUAGE = USERENV('LANG')