| Description | When a module with too many new tables and columns is installed, the Linked items in the User screen fails to load, giving the following message:
@CODE=1795@ORA-01795: maximum number of expressions in a list is 1000
openbravo.log lists this:
1151813 [http-8180-7] ERROR org.openbravo.erpCommon.utility.UsedByLinkData - SQL error in query: SELECT AD_PARENT_MENU_ELEMENT(M.AD_MENU_ID, ?, ?) AS ELEMENT_NAME, ((case when Wt.NAME IS NULL then W.NAME else Wt.NAME end) || ' - ' || (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end)) AS NAME, a.referenced_column_id, T.TABLENAME, C.COLUMNNAME, TB.AD_TAB_ID, '' AS HASTREE, '' AS ID, '' AS WHERECLAUSE, 0 AS TOTAL, (case when Wt.NAME IS NULL then W.NAME else Wt.NAME end) AS WINDOWNAME, (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end) AS TABNAME, (CASE WHEN (SELECT COUNT(*) FROM AD_WINDOW_ACCESS WA WHERE W.AD_WINDOW_ID = WA.AD_WINDOW_ID AND WA.AD_ROLE_ID = ?)=0 THEN 'N' ELSE 'Y' END) AS ACCESSIBLE, W.AD_WINDOW_ID as AD_WINDOW_ID, '' as AD_MENU_NAME FROM ( SELECT AD_COLUMN_ID, ? as referenced_column_id FROM AD_COLUMN WHERE UPPER(COLUMNNAME) = UPPER(?) AND (ISPARENT='Y' OR AD_REFERENCE_ID IN ('19', '35')) UNION SELECT AD_COLUMN.AD_COLUMN_ID, ? as referenced_column_id FROM AD_COLUMN, AD_ELEMENT WHERE AD_COLUMN.AD_ELEMENT_ID = AD_ELEMENT.AD_ELEMENT_ID AND UPPER(REPLACE(REPLACE(REPLACE(AD_ELEMENT.columnname, 'Substitute_ID', 'M_Product_ID'),'BOM_ID', '_ID'), 'M_LocatorTo_ID', 'M_Locator_ID')) = UPPER(?) AND AD_REFERENCE_ID IN ('30', '31') AND AD_REFERENCE_VALUE_ID IS NULL UNION SELECT C.AD_COLUMN_ID, s.ad_column_id as referenced_column_id FROM AD_COLUMN C, AD_REF_SEARCH S WHERE C.AD_REFERENCE_ID = '30' AND S.AD_TABLE_ID = ? AND C.AD_REFERENCE_VALUE_ID = S.AD_REFERENCE_ID UNION SELECT C.AD_COLUMN_ID, r.ad_key as referenced_column_id FROM AD_COLUMN C, AD_REF_TABLE R WHERE C.AD_REFERENCE_ID = '18' AND C.AD_REFERENCE_VALUE_ID = R.AD_REFERENCE_ID AND R.AD_TABLE_ID = ? UNION SELECT AD_COLUMN_ID, ? as referenced_column_id FROM AD_COLUMN WHERE AD_REFERENCE_ID = '21' AND UPPER(?) = 'C_LOCATION_ID' UNION SELECT AD_COLUMN_ID, AD_COLUMN_ID as referenced_column_id FROM AD_COLUMN WHERE
AD_COLUMN_ID IN ('03E0E77862F94320AF0A043A52B9D473', 'F9AFAE3531384151BCC1008E5160108E', '803828', '803830', '803837', '803841', '803846', '803848', '803816', '803818', '803858', '803860', '800533', '800535', '800025', '800017', '802527', '802529', '619', '621', 'A742EEB6EBD211DDBAE60016D4EE9DB3', 'A74DB3B4EBD211DD8AA10016D4EE9DB3', '550', '552', '6F387D3737CF3635E040007F01002312', '6F387D3737D13635E040007F01002312', '2599', '2601', '2643', '2645', '10CAC0D710AB4E14B4129E739B032BCC', '9C56850497CE409C9C48FBB4C2A0F7C1', '6F61A8993BC75E52E040007F01005AF5', '6F61A8993BC95E52E040007F01005AF5', '580', '582', '47A925222BF44DED8FC19F413BD5821B', 'D0029DD2D6314D83BFE6141C3DBAA8E1', '5381', '5383', '5391', '5393', '673', '675', '800813', '800815', '4601', '4603', '4629', '4631', '4614', '4616', '1005400242', '1005400244', '915561E66D2E1638E040007F01001C17', '915561E66D301638E040007F01001C17', '9155635C578298D2E040007F01001C13', '9155635C578498D2E040007F01001C13', '6292', '6294', '614', '616', '565', '567', '708', '710', '600', '602', '638', '640', '590', '592', '610', '612', '802450', '802452', '802462', '802464', '565E56DF64DE9042E040007F01002829', '565E56DF64E09042E040007F01002829', '682633A6E6AE9D31E040007F010061E4', '682633A6E6B09D31E040007F010061E4', '682633A6E6BA9D31E040007F010061E4', '682633A6E6BC9D31E040007F010061E4', '682633A6E68C9D31E040007F010061E4', '682633A6E68E9D31E040007F010061E4', '9382FCA58F53AF36E040A8C021013A93', '9382FCA58F55AF36E040A8C021013A93', '800853', '800855', '5C315336D8D8F72DE040007F01013754', '5C315336D8DAF72DE040007F01013754', '5D5E01C8EBD211DD8F740016D4EE9DB3', '5D6B2100EBD211DD92520016D4EE9DB3', '8227', '8230', '1271', '1273', '1471', '2806', '2808', '1292', '1294', '5951', '8224', '8222', '2819', '2821', '2837', '2839', '800704', '800706', '2849', '2851', '555', '557', '668', '670', '560', '562', '1005400270', '1005400272', '718', '720', '5512', '5514', '802700', '802702', '802711', '802713', '628', '630', '8577', '8581', '5C7FEB5FDD3A1EA1E040007F01002676', '5C7FEB5FDD3C1EA1E040007F01002676', '9178CF053CDDBEEDE040007F01002B8B', '9178CF053CDFBEEDE040007F01002B8B', '7809', '7805', '1005400220', '1005400222', '575', '577', '62DD925A901F41099D962DFEFE9CC84F', '9FA500579F424EAC8C1FD05AAFA4F2FA', '653', '655', '545', '547', '8567', '8569', '800688', '800690', '802429', '802431', '802439', '802441', '2860', '2862', '2872', '2874', '624', '626', '5397', '971', '723', '725', '585', '587', '570', '572', '1335', '1337', '698', '700', '77237543C377C8DCE040007F0101413D', '1724F76E1EC411DE85BF8FAF68F519DE', '173056541EC411DEBFB28F44D4806F33', '26E3702BD6F345FB802CD410C12FC6EE', 'AB67B03AC4A84D3F8CF236A16709D908', 'A37C6F84AA243F50E040007F01006E35', 'A37C6F84AA263F50E040007F01006E35', 'BDFC6B326633430292F1C59CEF831534', '046498C716474A6EAAEA0CA26E09C69D', '8BBA8047E1892A2FE040007F010030DC', '8BBA8047E18B2A2FE040007F010030DC', '9DE9E45A80994A969AC623FA97A3C0E8', 'BB2A987CBD534A18B91D77B7D43AF879', '82EFB8E4044019C9E040007F01003778', '82EFB8E4044219C9E040007F01003778', '1007400006', '1007400008', '800481', '2314', '2316', '8515', '8514', '8502', '8524', '8495', '8496', '8478', '8480', '8528', '8533', '8461', '8462', '3036', '3038', '3069', '3071', '4896', '4898', '2898', '2900', '3100', '3101', '5224', '4966', '4968', '4979', '4981', '800800', '800802', '2955', '2957', '800179', '800181', '803229', '803231', '3119', '3121', '40D8FCC5F0774A108328E8ADD47C7D5B', 'D651E163B279486F8F399DC05B63D426', '1111', '1113', '1987', '1989', '1000500050', '1000500052', '1000500054', '946', '948', '9609', '9601', '793', '795', '783', '785', '93FBE8C7C3884D2BA4C194E780B65267', 'E2D4BAECEDD04EE1ADDC4AA88B2DE55B', '9623', '9630', '2415', '2417', '7E4EC834996311DD819F001D09C4A2FE', '7E58D482996311DD9B45001D09C4A2FE', '57A0D4EA68DE7E16E040007F01004841', '57A0D4EA68E07E16E040007F01004841', '57A0D4EA68F87E16E040007F01004841', '57A0D4EA68FA7E16E040007F01004841', '57A0D4EA68EC7E16E040007F01004841', '57A0D4EA68EE7E16E040007F01004841', '8413', '8363', '1000500021', '1000500023', '1506', '1508', '3131', '3133', '1000500033', '1000500035', '1000500007', '1000500009', '1000500061', '1000500063', '2425', '2427', '1005100005', '1005100007', '6908', '6910', '803053', '803055', '803063', '803082', '803084', '803072', '803074', '8189F49FFEA56E56E040007F01003E83', '8189F49FFEA76E56E040007F01003E83', '8189F49FFEBD6E56E040007F01003E83', '8189F49FFEBF6E56E040007F01003E83', '7891269C8412655DE040007F010155CE', '7891269C8414655DE040007F010155CE', '7891269C8404655DE040007F010155CE', '7891269C8406655DE040007F010155CE', '804880D7B0F11126E040007F01004F9E', '804880D7B0F31126E040007F01004F9E', '7891269C83D4655DE040007F010155CE', '7891269C83D6655DE040007F010155CE', '7DC33C42755D3636E040007F01001C0B', '7DC33C42755F3636E040007F01001C0B', '7891269C83F6655DE040007F010155CE', '7891269C83F8655DE040007F010155CE', '78D16B5B178C661EE040007F010152F7', '78D16B5B178E661EE040007F010152F7', '3762A04F00E04B1298FB53AC436B47BF', '001DD60EF52E442C85374BBCB4CABEC6', '0F1394CAD68C4E1EBEC90416205E521B', '0CC9E53ACEFA4F678C718071C423E931', '80E839B16923298FE040007F01005AAF', '80E839B16925298FE040007F01005AAF', '1E02E4686375485595D2EC09B32DCFD5', 'B9336FB7C2B0400EB495358FAB55E17F', '78D10D5CC28EA0ADE040007F010152E6', '78D10D5CC290A0ADE040007F010152E6', '802DBB308CFBC960E040007F01001D1B', '802DBB308CFDC960E040007F01001D1B', '78903669795C2CEFE040007F01013334', '78903669795E2CEFE040007F01013334', '7FF2BE0C55FE41FDE040007F010060C1', '7FF2BE0C560041FDE040007F010060C1', '8189F49FFED86E56E040007F01003E83', '8189F49FFEDA6E56E040007F01003E83', '2EB409FE29174F31AD2C5AF5C3694DE5', 'EFEAAF057602425299AF5E2723FDC786', 'B7ED22A39C674AA0B00C1E8440C0A980', '149DBC9F632549EDB94CE1FE07A37553', '1019', '1021', '5852', '5854', '803765', '803767', '802993', '802995', '1000600018', '1000600020', '803789', '803791', '803776', '803778', '2468', '2470', '3440', '3442', '2660', '2662', '2487', '2489', '800516', '800518', '801074', '801076', '801095', '801097', '8045', '8063', '8039', '802793', '802795', '8109', '8116', '802808', '802810', '828EE0AE7FDC5FA1E040007F010067C7', '828EE0AE7FDE5FA1E040007F010067C7', '4914', '4916', '4931', '4933', '802838', '802840', '802850', '802852', '775', '777', '5265', '5267', '5276', '5278', '5246', '5248', '802928', '802930', '802957', '802959', '800304', '800306', '800724', '800726', '800463', '800465', '800352', '800354', '800377', '800379', '800864', '800866', '803', '805', '1132', '1134', '800269', '800271', '3160', '3162', '828EE0AE7FEE5FA1E040007F010067C7', '828EE0AE7FF05FA1E040007F010067C7', '1646', '1648', '1535', '1537', '3338', '3340', '5009', '5011', '800442', '800444', '800453', '800455', '1622', '1624', '1664', '1666', '800121', '800123', '5288', '5290', '828EE0AE7FD15FA1E040007F010067C7', '828EE0AE7FD35FA1E040007F010067C7', '831', '833', '7B51E0A4E08D4FC6B5C342557B9BD2AF', 'E83170858DE8441C94B64CDA46BC91FF', '876D244AC9DC81F3E040007F010077EB', '876D244AC9DE81F3E040007F010077EB', '876D355A747812B0E040007F01007860', '876D355A747A12B0E040007F01007860', '876D70C14FA50860E040007F0100787B', '876D70C14FA70860E040007F0100787B', '876CE05E802988E4E040007F0100789B', '876CE05E802B88E4E040007F0100789B', '876CE05E803D88E4E040007F0100789B', '876CE05E803F88E4E040007F0100789B', '2032', '2034', '801024', '801026', '3171', '3173', '842', '844', '1817', '1819', '60FCCD631EA7EDF8E040007F01013AD4', '60FCCD631EA9EDF8E040007F01013AD4', '802536', '802538', '803013', '803015', '803032', '803034', '803092', '803094', '800824', '800826', '800330', '800332', '2071', '2073', '4100', '4102', '1002100040', '1002100042', '2245', '2277', '5081', '5083', '1002100022', '1002100024', '1002100079', '1002100081', '1002100093', '1002100095', '1002100062', '1002100064', '803800', '803802', '8207', '8200', '802474', '802476', '3182', '3184', '5095', '5097', '1035', '1037', '4075', '4077', '4088', '4090', '3489', '3491', '3512', '3513', '800788', '800790', '3833', '3835', '801047', '801049', '803126', '803128', '7E595A11D61A446FE040007F010052E9', '7E595A11D61C446FE040007F010052E9', '5574', '2141', '2143', '3856', '3858', '5527', '5529', '5545', '5551', '813', '815', '1394', '1396', '8457', '8449', '8432', '8434', '803499', '803501', '803564', '803566', '803574', '803576', '803606', '803608', '803628', '803630', '803649', '803651', '803671', '803673', '803511', '803513', '803522', '803524', '801239', '801241', '801349', '801351', '802344', '802346', '802223', '802225', '802212', '802214', '802494', '802496', '802071', '802073', '803309', '803311', '803166', '803168', '803214', '803216', '803285', '803287', '802385', '802387', '801481', '801483', '803181', '803183', '803192', '803194', '801205', '801207', '803320', '803322', '801229', '801231', '802578', '802580', '802676', '802678', '802598', '802600', '802628', '802630', '802642', '802644', '802588', '802590', '802688', '802690', '802237', '802239', '802305', '802307', '802379', '802248', '802250', '802258', '802260', '801524', '801526', '803466', '803468', '803488', '803490', '803477', '803479', '801541', '801543', '802322', '802324', '801513', '801515', '3616', '3618', '803332', '803334', '803344', '803346', '803274', '803276', '803354', '803356', '801647', '801649', '801185', '801187', '802332', '802334', '801336', '801338', '801325', '801327', '802357', '802359', '802110', '802112', '801217', '801219', '801610', '801612', '801620', '801622', '801554', '801556', '801569', '801571', '801585', '801587', '2575', '2577', '2589', '2591', '3462', '3464', '800752', '800754', '802753', '802755', '802767', '802769', '3574', '3575', '3587', '3589', '3547', '3549', '3560', '3562', '3663', '3665', '4759', '4761', '3601', '3603', '3526', '3528', '3797', '8771', '3534', '3536', '800647', '800649', '800664', '800666', '1E0F1FC0A13111DD8C2607AC7CEDF203', '1E1DC5C0A13111DDB99E3B8DB28EF9C2', '58E839A0929E0D3BE040007F01015CDF', '58E839A092A00D3BE040007F01015CDF', '56EBD77E6C007067E040007F0100331E', '56EBD77E6C027067E040007F0100331E', '59212C15A6FBF425E040007F01003D5C', '59212C15A6FDF425E040007F01003D5C', '57C8E0FB1412DE03E040007F01001B6B', '57C8E0FB1414DE03E040007F01001B6B', '467F96E0F2BE11DDABCF001D09C4A2FE', '46880B36F2BE11DDAF37001D09C4A2FE', 'FF6EFE0861064F48BF0B0A54C0E8328C', 'B589A2A84FDE4A25966D23BFCDF4F27F', '5506EF5A70A840CF8C8AA08B2E505CBA', '3078E5FF2ED3461796F183DE05D28AED', 'CAFD7AEE08DF4BE1990582203F1B9760', '966A942FA0784F879453553A3A8CA358', '95CC63FD04C021F2E040007F010075C1', '95CC63FD04C221F2E040007F010075C1', '96FCF4C1EF9DAE63E040007F01002B87', '96FCF4C1EF9FAE63E040007F01002B87', '95CC5757ECB7E5B8E040007F010076A5', '95CC5757ECB9E5B8E040007F010076A5', '927D0D118B87EF36E040A8C0CF071CF5', '927D0D118B89EF36E040A8C0CF071CF5', '927D156047B86E92E040A8C0CF071D3D', '927D156047BA6E92E040A8C0CF071D3D', 'F312B5DACFC948D88C060AA5A84F5902', 'E76F59F7E8DE4AE6881DB269A26A0E4E', 'B4ADF38C791A48928DEF50057A6C6412', '104E9E1221184AFBB3BFBA2A80149A95', '927D156047C46E92E040A8C0CF071D3D', '927D156047C66E92E040A8C0CF071D3D', '927D156047A66E92E040A8C0CF071D3D', '927D156047A86E92E040A8C0CF071D3D', '927D156047B06E92E040A8C0CF071D3D', '927DA01A83533AFAE040A8C0CF072B85', '927DA01A83553AFAE040A8C0CF072B85', '7EE03BC0EF044133B80147985FDC69D9', '23C2C64A20BF45E38EF29F98A47B4EDF', '927DA01A835D3AFAE040A8C0CF072B85', '927DA01A835F3AFAE040A8C0CF072B85', '2CE601D3765C4E93A7A754B9EE4819AD', '77EBA5E29565415A9F26C56FA285908F', 'B6DBF915A950414DB1613EAEF2D4EAD1', '55D1966F036543D1A63B16B60A02BB15', '50E6C69E2DBA4C87A4B4F54677644486', '25C39503BBF34AA1BFE3DEB34B457FE8', '5E4F5ECE51A34B969AB3B4483F393CE2', '369AB06834A643D0A737EB8082D9E21D', 'A8FD2025FA244939B687F49907BE94C5', '264214655D654262848E2AB4442322CA', 'E275477B5DC7474AA9490AC2980F9225', 'E8D215F7042A4209BE321D7B83AA163A', '71E68BDB26FF4885B56A3C32A1B3CB78', 'D5ADE9C71E914B68A176C32825772F27', 'F122D4D6438447B9BBBCB52B2F49FBDE', 'AE6A4E222AFC4431A26E7C35B693C498', '5F6CA4435F8E4097B085D4391510CDF7', '927DA01A832F3AFAE040A8C0CF072B85', '927DA01A83313AFAE040A8C0CF072B85', '927DA01A83463AFAE040A8C0CF072B85', '927DA01A83483AFAE040A8C0CF072B85', '927FD1CA753D6901E040A8C0CF073D3E', '927FD1CA753F6901E040A8C0CF073D3E', 'E5831C3A7FB243B78D6C6446D63CAF89', '01D197C1A5A74518AFC6C77F50B7D14C', 'B4FD9EC573F94B9096FF3A41284F338F', '398D12F96DA24398ABD22A7062130761', '182023ADC5294B6C87123A6AF98F567D', 'A03032C18765408EB1F0EF608CDF37D0', 'B0F4DF9FB5024E8484C813D17537FD05', 'B15A61113BD546F989D720AC3A6F236E', 'F9AFC432E4724671909604558790F37C', 'EE79308CC7934527B4E965BBD94B5096', 'F456EE44F0DF47B09107AD51E7D352C1', '816D1C6AE7FA4E789FC1CB73521ECE6F', '10898EB4BCB34C178ED6790431BBFFB1', '2166', '2168', '2186', '2763', '8763', '938BD9AC20C9E2ADE040007F02000462', '1011100005', '1011100007', '2210', '2212', '803113', '803115', '7E562C34A0506EB2E040007F01001D67', '7E562C34A0526EB2E040007F01001D67', '3352', '3354', '713', '715', '581C573C99CA693BE040007F010135E1', '581C573C99CC693BE040007F010135E1', '5BE6AE18BFFB1D56E040007F010148F2', '5BE6AE18BFFD1D56E040007F010148F2', '1997', '1999', 'A908EA6CF218F9C9E040007F01011582', '49438452B86C4672AE4246B40804B601', 'C523906F9ACC461A9C95D7DEB111D566', '92F840D280D411DD83E7FFC78829B539', '92F8940680D411DD82E0AB3620E5EE68', '58D503FCDD99D53FE040007F01016BBB', '58D503FCDD9BD53FE040007F01016BBB', '801109', '801111', '801128', '801130', '801138', '801140', '803258', '803260', '801148', '801150', '801158', '801160', '800774', '800776', '2105', '2107', '6586', '6588', '6617', '6619', '2992', '2994', '2060', '2062', '800215', '800217', '800236', '800238', '800250', '800252', '802724', '802726', '800225', '800227', '802736', '802738', '57B98D87940DA967E040007F01013153', '57B98D87940FA967E040007F01013153', '588907857EA1E0C2E040007F010120BD', '573D452F04D1243FE040007F01012792', '573D452F04D3243FE040007F01012792', '58866B56AA0CDDF4E040007F01014048', '6162397BD0F24953E040007F0101559D', '6162397BD0F44953E040007F0101559D', '6518', '6520', '6502', '6504', '803534', '803536', '1004400029', '803547', '803549', '1004400034', '1004400010', '1004400012', '1407', '1409', '3391', '2562', '2564', '4718', '4720', '9BAEEE4845E738D8E040007F01002420', '9BAEEE4845E938D8E040007F01002420', '1773', '1775', '5116', '5118', '800738', '800740', '803456', '803458', '9C8C523F49E7BD9DE040007F0100646F', '9C8C523F49E9BD9DE040007F0100646F', '1440', '1442', '3327', '3329', '800008', '800011', '1354', '1357', '5797', '5752', '2299', '2301', '9838', '9851', '5763', '5765', '8719', '8710', '800110', '800112', '800114', '800068', '800070', '800075', '800097', '800099', '8739', '8738', '8874', '8877', '8893', '8895', '8707', '8704', '800082', '800084', '87F060C29C5211DDB3CF001D09C4A2FE', '87F7F2389C5211DD8B8A001D09C4A2FE', '861', '863', '6857', '6855', '8839', '6829', '6827', '6894', '6896', '6783', '6781', '7399CFDCF5B72DD0E040007F0101239A', '7399CFDCF5B92DD0E040007F0101239A', '04A44B86E981420381BEF976DF13B3A7', '67CE6AB656E344709AD049E70CE73054', 'F923F1A4C7DC41D58A643E7F2D8294C7', 'A8E9D840B0FE4ACA9E686F96FA26BE39', 'C0D594AEAB0643AFAFCC9362680C3B27', '620CB554320943D0B1CFED7D02E96B2E', '24BC7027AD7D4833A48F1433E59B4AF4', '263C7AB3511940D180A2FF42047B506B', '83D00F01983B40C693967513C4034535', '46B52920215E4094928F34019B54BDB9', 'B69714676FCB43FC80FABFBB6898354D', '2493BA115F494234807CB52B44A0B2DA', '045268C9634D44D8AD2EB80281843F10', '99CDDE1BE7634B0FAB8A7F63013A5B84', '7AC8FF0784D0496FB96A046D0103683F', '5B68F92E550E4827B37CF5D97DC2C488', '9A60ABC9538B984FE040A8C054012F31', '9A60ABC95389984FE040A8C054012F31', '9E263C9DA393F8B9E040007F02005037', '9E263C9DA395F8B9E040007F02005037', '9FC9DBBCA04C8CB2E040A8C054012878', '9FC9DBBCA04E8CB2E040A8C054012878', '9E1C0D274C924C05B1FA4B533DF51131', 'EAECDC93E0BC4C0182416FEE41806274', '0D504D7534F64E979272E0E5DF17F03C', 'A7CE36B8B7F4405CB4E9343D4B2DB205', 'E47190960F754B73B4652B8E3D7BE6C4', '66212E7CDADB45B58EC92C204A9AABB5', '9C6B24FA9EFDEA7AE040007F02005226', '9C6B24FA9EFFEA7AE040007F02005226', '9C81A3830852DAD6E040007F02003345', '9C81A3830854DAD6E040007F02003345', '7ED9426DCBB345C1A3381DE079376A77', '4CB83116C2B848ADA53A1574F7D9A250', '042DC405FED941849701DBE0258BC08D', '2CEC644A54294875AE2A73E7AA253AF9', '81D04E100F10408499416F768DCEAF6A', '8E8FCA82AFD74CB1B4EE86001ACD6C95', 'F0330EF7CF1848598D1243E989864AE6', '844F448A3289434DB369606B894E83B7', 'C08E1CDBC40C4C7A958317589240CEB4', 'EF1F7916E5104451827FADAD9058F063', '078C0FABB9E64297A2539583E58A757D', '69C049B2625C4BE684C247EF9A35CCB2', '6FCD394DA82140BDBB39A38038EF95A7', '84B54AF172BD40539DCC5D93AEFEDC85', '10E3BE3299264BDE93F34C776CCBB446', '01F058F66B1444E299BA53CCF8327493', '3683EB0FEE404779B2FB4BB212F8E3F5', 'E13EC90DA1084089824641994A2AEC50', '3B371F648B154FF5A98799E48D18EB4D', '32B8E38B303947138A2C45A72B70FFEF', '3131DEAF117C490DAEC8D20FE3E6A37F', 'B0C76975F22A41239651F2035AC3C45B', '9CD0221154724463E040007F02001351', '9CD0221154744463E040007F02001351', '9CD02211547F4463E040007F02001351', '9CD0221154814463E040007F02001351', '09D6BC66A430459CAEFEB04A45F6A889', '659905BE6DC64A4CB0CD248B2C09DE03', '9FB5C6F1F16BD7C6E040A8C080CE1D4E', '9FB5C6F1F16DD7C6E040A8C080CE1D4E', '9F8D7D3011B03025E040A8C0813A24B7', '9F8D7D3011B23025E040A8C0813A24B7', '9CD0BC152B1D437AE040290A518804D0', '9CD0BC152B29437AE040290A518804D0', '362321E4DBDF4F4786217681AC0957ED', 'D9A8D21F7E0E48328869261138495519', '80235DC587CA46E086E722D836AD626A', 'DE9AE3258A0D4179B7FEF0F6BCBDF8D9', '218DB593148446548B547EB4CEA1A8EC', '4166355FF7FB4B30AD55BE1EB2A8C2A5', 'FF1A54344CD64F5E8F1A90506CA9D8CD', '9987AB01121048F2A8937B95C6A8654E', '0C23178F2D3849E3B8CE0AE5B73F2956', '2F2AEA48E5884E1FA4A40174488EFEA4', '33CDA91829FF410EAFAF545ACEFC15BD', '0B6B69A008FC416FBB73E7E3DD5BD01C', 'C99AD59ADE634FE69E0FBE65BBCE7254', '7231BAB16E884526A03673BD555E1EAE', 'FE421B8AB59845228493C7F5B4B3DA90', '5E7C68B7BF6E446DA055995904FE23E0', '92EB0211DC796D4AE040007F02003A89', '92EB0211DC7B6D4AE040007F02003A89', 'D20FBD06327F459C8CD4E464D7C6CBE2', '071A31872E4E4C9A802262A3BA3D80BA', '95D015DE46845A79E040A8C0540171EA', '641D62981CF3451B998B1502028D1BB9', '02EDBBAAA3E049CDAE6AF888FDBA27BD', '054EE4EB55B5431AB21D6EB2E5B72C62', '039895156F7C49D49441E24F82833771', 'BBC97D66A40444D8A51DD8732B36FEEB', '62FBA94A10984D0EB9928599278DA5F3', '8802179F29C014F4E040290A6E8830DE', '8802179F29C214F4E040290A6E8830DE', '8802179F29C514F4E040290A6E8830DE', 'A69F7D75639F48D0B637CA278BDF7C0D', 'E0EED41D5D7744BEA521F1EDB1C828F4', '976DBAA78BF54A759FFEFD1317CB46CA', 'AFF58B615F4C4F3197B03C689BC24181', '87FA997D34F1ED10E040290A6E886E0E', '87FA997D34F3ED10E040290A6E886E0E', '7C305C8C5C764A5098A804A65E68371A', '0DFEAB8BE524493D9A186716C8402FCC', 'A605A4527C71491882B3C350CCD9B334', '0F9DEF3BC7574E65A1CE3D4A73E4E81C', 'BFDC3F8D80BD4065ADA010452AC137D9', '4B4B32BB1A7F4E2A97367C94FDA77F04', '6876E6D1800A41A893396068A0BEB8F5', '9CD5CB3E550F4B99869721B4B85F92EE', '93CA1BB6A42E4FE49316B7F6872A72B6', 'B81473E9E4CF4780A902D53BAEF6DEBA', '8C75FD2550982B31E040007F02000165', '8C75FD2550A12B31E040007F02000165', '7BF2755AE8C40438E040007F020016EC', '7BF2755AE8C60438E040007F020016EC', 'D81E55E086EB441D949D68A4905C91A1', 'C20D1BC8ED544F86BFB7D6137DFAC327', '2659E99F258F44FEA2B9BBED7684F7CF', '8C0F945C46F22CCEE040007F020002CC', '8C0F945C46F42CCEE040007F020002CC', '8C0F945C46F52CCEE040007F020002CC', '8C0F945C46E72CCEE040007F020002CC', '8C0F945C46E92CCEE040007F020002CC', '8C0F945C46EA2CCEE040007F020002CC', 'A9365E5F08D3441782A3221488692389', '445FDB4DCF1B44149047758B417C3A25', '8C103784C0739EADE040007F020002C2', '8C103784C0759EADE040007F020002C2', '8C103784C08D9EADE040007F020002C2', '8C103784C08F9EADE040007F020002C2', '25176297F91A4E71931F0BBE42347808', '50C363EE807F4359BB206E65DCB16491', 'D204B56536DB4512B6874C2B33372383', '3270B8B6822147F1BC4863559449AB78', '880E671A1368D0D5E040290A6E8828AE', '880E671A136AD0D5E040290A6E8828AE', '8C0F945C46DB2CCEE040007F020002CC', '8C0F945C46DD2CCEE040007F020002CC', '8C0F945C46DF2CCEE040007F020002CC', '8C0F945C46E02CCEE040007F020002CC', '87FA997D3501ED10E040290A6E886E0E', '87FA997D3503ED10E040290A6E886E0E', '00FC9E415F4F46FD9BFA46AA26B27C6A', '1902FFD144424E3DB1429FFAE0AD37FB', '69A8F59B910F403A806FD24B3BE0D0F7', '6D9559D2147E4EA1B1FECCDE202882E4', 'B410A49F6BB449C38F1D47F68D6CB2F0', '2D2FB2CA684C4615BD4ED72E34F659BA', '85BA7CEA76A84C9C9B4C21B59956EA0F', '8529104725AE4201B4CFBFA8214BCBD2', '8DA95227FBE14F468DBB6B98A00ACC58', '3DD0AB7F96944BBA924DE896D30ACD13', 'F2AD246BE5EA46BA8E01E2A9549F9BD1', 'B737202D077F4FF78C8E3A052C42A602', 'FB1AEDF6B37742ABB85D8F31D6ECB1E3', '4D1CA5776F904B4884B6847F5AAE462F', '8C75FD25508F2B31E040007F02000165', '8C739566170A1353E040007F02000167', '8C7A90CFF0FF9FC1E040007F02000169', '8C7A90CFF1019FC1E040007F02000169', '1F3D5A3FF6774D79BAA7C49459A8E9B6', '931FEA2139A54DE3BAC70B4610BD6563', '6F0916A8C8B94FC3B8CC42A1E3313113', 'CAE8A7A3FAE0441788B04F2F1F84B87F', '8C7A90CFF0EF9FC1E040007F02000169', '8C7A90CFF0F19FC1E040007F02000169', '8A6464BF2E4F4A36AEF1852E4FBA375E', 'EDF8EBADDA854A7E8AC4074CF094C10E', '9F530A4E07E7DC88E040A8C0813A46DA', '9F530A4E07E9DC88E040A8C0813A46DA', '803144', '803146', '803155', '803157', '5672', '5674', '5689', '5691', '5832', '5834', '5705', '5707', '5807', '5809', '1828', '1830', '3395', '8419', '8523', '9084', '9089', '2082', '2084', '9098', '9100', 'B9F3EA403E4049FCBA20C129E5582919', 'C476E0E12AB54B9C9BFADB8D65AE57FB', 'D96682AB088E4B7E8F0E78B23B7CEF61', '007809594C4547ECA877F9B7265AA339', '02FBE256EE1C4279837233AD4563308B', '02D2BC59DCF04D9FA0DDA92B3E062712', '6843', '6841', '6883', '6881', '803422', '803424', '8848', '8847', '852', '854', '1007', '1009', '3964', '3966', '2435', '2437', '1251', '1253', '2447', '2449', '800201', '800203', '2DDCB67302B645219733425DA5964925', 'C4D1537CF8DC4388AEA47EF0D73D5E8B') ) A, AD_TABLE T, AD_COLUMN C, AD_MENU M, AD_WINDOW W left join AD_WINDOW_TRL Wt on W.AD_WINDOW_ID = Wt.AD_WINDOW_ID AND Wt.AD_LANGUAGE = ?, AD_TAB TB left join AD_TAB_TRL TBt on TB.AD_TAB_ID = TBt.AD_TAB_ID AND TBt.AD_LANGUAGE = ?, AD_FIELD F left join AD_FIELD_TRL Ft on F.AD_FIELD_ID = Ft.AD_FIELD_ID AND Ft.AD_LANGUAGE = ? WHERE W.AD_WINDOW_ID = TB.AD_WINDOW_ID AND TB.AD_TABLE_ID = T.AD_TABLE_ID AND T.AD_TABLE_ID = C.AD_TABLE_ID AND C.AD_COLUMN_ID = A.AD_COLUMN_ID AND C.AD_COLUMN_ID = F.AD_COLUMN_ID AND W.AD_WINDOW_ID = M.AD_WINDOW_ID AND TB.ISACTIVE = 'Y' AND W.ISACTIVE = 'Y' AND (TB.WHERECLAUSE IS NULL OR TB.WHERECLAUSE NOT LIKE '%@%') GROUP BY M.AD_MENU_ID, (case when Wt.NAME IS NULL then W.NAME else Wt.NAME end), (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end), a.referenced_column_id, T.TABLENAME, C.COLUMNNAME, TB.AD_TAB_ID, W.AD_WINDOW_ID ORDER BY 1, (case when Wt.NAME IS NULL then W.NAME else Wt.NAME end), (case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end), T.TABLENAME, C.COLUMNNAME, TB.AD_TAB_IDException:java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
|