gistfile1.txt

SELECT
                          [STOCKREF] as product_remote_id,
                          SUM([ONHAND]) as quantity,
                          INVENNO as remote_warehouse_id
                      FROM LV_006_02_STINVTOT
                      WHERE STOCKREF in ( 6518,147,148,150,151,156,744,745,746,747,748,751,760,761,762,764,766,776,777,778,779,780,786,787,788,789,790,791,792,793,795,798,800,801,802,803,805,806,807,808,810,811,812,814,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,834,836,837,838,839,843,845,846,847,848,849,850,851,852,853,854,855,857,859,860,862,866,867,868,869,1333,1337,1340,1341,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1373,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1374,1375,1376,1377,1378,6534,1380,1381,1382,1383,1384,1385,1386,1388,1390,1394,1396,1397,1398,1399,1400,1401,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1414,1415,1416,1417,1418,1419,1420,1421,870,871,872,880,882,884,885,889,890,891,894,895,896,897,898,901,905,906,907,912,914,915,916,1019,1020,1022,1036,1038,1047,1048,1049,1051,1052,1053,1054,1055,1056,1057,1058,1061,1064,1067,1069,1070,1073,1074,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1089,1091,1092,1094,1096,1097,1100,1101,1102,1104,1105,1106,1108,1109,1110,1111,1112,1113,4988,1116,1263,4633,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1492,1493,1494,1495,1496,1497,1498,1501,1502,1503,1505,1506,1509,1510,1119,1120,1121,1122,1123,1124,1125,1126,1129,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1191,1192,1194,1195,1196,1197,1198,1199,1511,1512,1513,1514,1515,1517,1518,1519,1524,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1543,1544,1545,1549,1551,1552,1553,1554,1557,1558,1559,1563,1564,1568,1571,3496,1573,1574,1578,1583,1586,1589,1597,1598,1601,1608,1609,1610,1611,1614,1617,1618,1620,1621,1622,1627,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1222,1223,1224,1225,1226,1227,1228,1229,1230,1232,1233,1234,1235,1236,1237,1238,1240,1241,1242,1243,1244,1246,1247,1248,1251,1255,1256,1259,1260,1261,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1275,1276,1278,1279,1281,1282,1283,1284,1286,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,4983,1680,1682,1683,1684,1685,1686,1688,1689,1690,1691,1692,1694,1696,1697,6523,1701,1704,1705,1708,1709,1711,1712,1713,1715,1717,1718,1724,1721,1722,1723,1725,1728,1729,1730,1731,1732,1733,1734,1735,1736,1287,1289,1306,1291,1294,1295,1296,1297,1298,1303,1304,1307,1308,1310,1313,1314,1315,1316,1317,1318,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1869,1871,1874,1875,1876,1877,1879,1882,1884,1886,1889,1890,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1911,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1806,1807,1808,1912,1913,1915,1916,1917,1918,1919,1926,1928,1929,1931,1933,1935,1937,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1980,1981,1983,1984,1985,1986,4559,1989,1994,1995,2000,2002,2004,2009,2011,2017,2018,2019,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1824,1825,1827,1828,1830,1836,1838,1839,1840,1841,1842,1843,1844,2379,2380,2381,2385,2386,2387,2388,2389,2390,2392,2393,2396,2398,2399,2400,2401,2402,2403,2408,2409,2410,2411,2412,2415,2416,2417,2418,2419,2420,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2437,2438,2439,2440,2441,2442,2443,2020,2027,2029,2030,2031,2034,2035,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,6493,2052,2054,2055,2056,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2124,2444,2445,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,2467,2468,2469,2470,2471,2493,2474,2476,2477,2478,2479,2480,2481,2482,2484,2485,2487,2488,2489,2492,2495,2496,2499,2498,2501,2516,2521,2525,2527,2530,2531,2532,2533,2535,2536,2537,2538,2539,2540,2542,2544,2545,2546,2547,2548,2549,2551,2554,2555,2556,2125,2126,2127,2128,2129,2130,2131,2132,2133,2134,2135,2136,2138,2139,2140,2141,2150,2153,2154,2155,2160,2161,2162,2164,2166,2167,2168,2169,2170,2171,2172,2173,2174,2175,2177,2178,2179,2188,2182,2184,2186,2187,2189,2191,2193,2195,2197,2200,2201,2202,2204,2207,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2560,2561,2562,2563,2564,2565,2567,2569,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2596,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2636,2637,2638,2639,2640,2641,2233,2234,2235,2236,2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2249,2250,2251,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,2291,2292,2293,2294,2295,2296,4982,2299,2300,2301,2302,2303,2305,2306,2307,2308,2314,2315,2643,2644,2646,2647,2648,2649,2650,2651,2653,2655,2656,2669,2670,3131,2672,2673,2675,2682,3326,2684,2685,2689,2695,2697,2699,2703,2705,2706,2707,2708,2713,6315,2715,2716,6432,2718,2719,2720,2721,2722,2723,2724,2725,2726,2727,2734,6354,6353,2738,6428,2740,2742,2743,2745,2746,6117,2748,2749,2751,2752,2753,2757,2762,2765,2767,2769,2772,2777,2778,2780,2782,2783,2784,2317,2318,2319,2321,2322,2323,2328,2329,2330,2331,2332,2333,2334,2335,2337,2338,2339,2340,2341,2342,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2356,2359,2360,2363,2364,2365,2366,2369,2370,2373,2374,2375,2376,2377,2917,2921,2922,2923,2924,2925,2926,2927,2929,2930,2932,2933,2936,2937,2939,2940,2943,2944,2946,2948,2951,2785,2786,2787,2791,2792,2793,2794,2795,2800,2803,2804,2807,2811,2813,2814,2816,2819,2820,2821,2824,2826,2828,2829,2830,2831,2832,2833,2834,2835,2837,2839,2840,2841,2842,2843,2845,2846,2847,2848,2849,2850,2851,2854,2855,2856,3229,2858,2859,2860,2861,2876,2863,2864,2867,2868,6247,2871,2873,2874,2875,6444,2878,2879,2880,2882,2883,2887,6327,2955,2956,2957,2958,2959,2960,2961,2962,2965,2966,2967,2995,2970,2971,2972,2973,2974,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2987,2988,2989,2990,2991,2992,2994,3031,6448,2998,2999,3000,3001,3002,3003,3004,3005,3007,3008,3009,3010,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3024,3025,3026,3027,3028,3029,6039,3032,2891,6451,2893,2894,2897,2899,2901,2902,2903,2905,6483,2908,2909,6604,2912,3505,3517,6107,3523,6535,3525,4895,3528,3532,3535,3536,3537,3538,3539,3540,3541,3547,3757,3740,3553,3552,3554,3557,3560,6222,4860,6440,3582,6467,3593,4768,3665,3602,3608,3611,3612,6185,3622,3629,3638,3692,3697,3033,3036,3037,3038,3039,3040,3042,3043,3044,3046,3047,3048,3049,3051,3052,3054,3055,3056,3058,3059,3062,3064,6536,3067,3068,6122,3070,3071,3075,3076,3077,3078,3079,3080,3083,3084,6351,3086,3090,3091,3094,3095,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3110,3111,6498,3113,6097,3115,3117,3118,3119,3120,3121,3122,3123,3124,3126,3127,3128,3129,3130,3132,3133,3135,3136,3138,3140,3142,3143,3144,3145,3147,6128,6501,3162,3165,3166,3168,3169,3170,3171,3173,3177,3180,3182,3184,3185,3187,3189,3191,3192,3195,3198,3199,3201,3202,3238,3204,6081,3206,3207,3208,3209,3210,3213,3214,3215,3216,3220,6497,3222,4632,3224,3226,3227,3228,3230,3237,3239,3242,3243,3244,3708,3709,6474,6392,3721,3731,6446,3736,3738,3741,3742,3743,3746,3747,3749,3750,3751,3752,3753,3754,3755,3758,3760,3762,6190,3768,3769,3777,3788,3789,3799,3804,3806,3810,6522,3819,3821,3822,3823,3824,3827,3828,3830,3831,3832,3833,3834,3835,3841,3843,3844,3845,3846,3847,3848,3849,3850,3851,3852,3854,3856,3857,3858,3859,3860,3861,3862,3863,3864,3865,3866,3867,3868,3869,3870,3871,3872,3873,3874,3875,3876,3877,3878,3879,3880,3881,3252,3253,3255,3257,3259,3262,3267,3268,3271,3272,3273,3276,3277,3278,3281,3286,3289,3295,3297,3298,3300,3304,3311,3312,3319,3320,3324,3325,3327,3333,3340,3342,3344,3346,3353,3354,3356,3358,3360,3361,3362,6355,3365,3368,3372,3373,3376,3378,3384,3385,3386,3388,3389,6494,3392,3393,3397,3398,3401,3405,3406,3408,3412,3413,3415,3417,3418,3882,3883,3884,3885,3886,3887,3888,3889,3892,3893,3894,3895,3896,3897,3898,3899,3901,3902,3903,3904,3905,3906,3907,3908,3909,3910,3911,3912,3913,3914,3915,3916,3917,3918,3919,3920,3921,3922,3923,3924,6193,3926,3927,3928,3933,3934,3935,3936,3937,3938,3939,3940,3941,3942,3943,3944,3945,3946,3947,3948,3949,3950,3951,3952,3953,3954,3955,3956,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,3975,3976,3977,3978,3979,3980,3981,3429,3430,3431,3432,3434,3436,3437,6183,3448,3450,3451,3454,6211,3457,3459,3460,3463,3469,3470,3472,3474,3476,3478,4035,4036,4037,4038,4039,4040,4041,4042,4043,4044,4045,4046,4047,4048,4049,4050,4051,4052,4053,4054,4055,4056,4057,4058,4059,4060,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4088,4089,4090,4091,4092,4093,4094,4095,4096,4097,4098,3982,3983,3984,3985,3986,3987,3988,3989,3990,3991,3992,3993,3994,3995,3996,3997,3998,3999,4000,4001,4002,4003,4004,4005,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4018,4019,4020,4021,4022,4023,4024,4025,4026,4027,4028,4029,4030,4031,4032,4033,4034,4497,4498,4500,4502,4504,4505,4506,4507,4508,4509,4510,4511,4512,4514,4515,4516,4517,4518,4519,4520,4521,4522,4523,4524,4525,4526,4527,4528,4529,4530,4531,4532,4533,4534,4535,4099,4100,4101,4102,4103,4104,4105,4106,4107,4108,4109,4110,4111,4112,4113,4114,4115,4116,4117,4118,4119,4120,4121,4122,4123,4124,4125,4126,4127,4128,4129,4130,4131,4132,4133,4134,4136,4137,4139,4140,4143,4145,4147,4149,4150,4151,4152,4153,4155,4156,4157,4158,4159,4160,4161,4162,4163,4164,4165,4166,4168,4169,4170,4171,4173,4174,4176,4177,4178,4179,4180,4181,4182,4183,4184,4185,4186,4187,4188,4189,4190,4191,4192,4193,4194,4195,4536,4537,4538,4539,4540,4541,4542,4543,4544,4545,4546,4547,4548,4549,4550,4551,4552,4553,4554,4555,4556,4558,4560,4561,4562,4563,4564,4565,4836,4567,4568,4493,4572,4574,4578,4579,4580,4581,4582,4583,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4596,4597,4598,4599,4600,4601,4602,4603,4604,4605,4606,4607,4610,4611,4612,4613,4614,4615,4616,4617,4196,4197,4198,4199,4200,4201,4202,4203,4204,4205,4206,4207,4208,4209,4210,4211,4212,4213,4214,4215,4216,4217,4218,4219,4220,4221,4222,4223,4224,4225,4226,4227,4228,4229,4230,4231,4232,4233,4234,4235,4236,4237,4238,4239,4240,4241,4242,4243,4244,4245,4246,4247,4248,4249,4250,4251,4252,4253,4255,4256,4257,4258,4259,4260,4261,4262,4263,4265,4266,4267,4268,4269,4270,4271,4272,4273,4274,4275,4276,4277,4278,4279,4280,4281,4282,4283,4284,4285,4286,4287,4288,4289,4290,4291,4292,4618,4619,4620,4621,4622,4623,4625,4626,4627,4628,4629,4630,4631,4635,4636,4637,4638,4639,4640,4641,4642,4643,4644,4645,4646,4647,4648,4649,4650,4651,4652,4653,4654,4655,4656,4657,4658,4659,4660,4661,4663,4664,4665,4666,4667,4668,4669,4670,4671,4672,4674,4675,4677,4678,4679,4680,4681,4682,4683,4684,4685,4686,4687,4691,6393,4695,4696,4697,4698,4699,4702,4703,4704,4708,4709,4710,4713,4714,4715,4717,4293,4294,4295,4296,4297,4298,4299,4300,4301,4302,4303,4304,4305,4306,4307,4308,4309,4310,4311,4312,4313,4314,4315,4316,4317,4318,4319,4320,4321,4322,4323,4324,4325,4326,4330,4331,4332,4333,4334,4335,4336,4337,4339,4340,4341,4342,4343,4344,4345,4346,4349,4350,4351,4352,4353,4354,4355,4356,4357,4358,4359,4360,4361,4362,4363,4364,4365,4366,4367,4368,4369,4370,4371,4372,4373,4374,4375,4376,4377,4378,4379,4380,4381,4382,4383,4384,4385,4386,4387,4388,4389,4390,4391,4392,4393,4718,4719,4720,4721,4722,4723,4725,4726,4727,4728,4731,4735,4742,4743,4744,4745,4746,4747,4748,4749,4750,4751,4752,4753,4754,4755,4756,4757,4758,4759,4760,4761,4762,4763,4764,4765,4766,4767,4769,4770,4771,4772,4773,4774,4775,4776,4777,4778,4779,4780,4781,4782,4783,4784,4785,4786,4787,4788,4789,4790,4791,4793,4794,4795,4796,4797,4798,4799,4800,4801,4802,4803,4804,4805,4806,4807,4827,4809,4810,4394,4395,4396,4397,4398,4399,4400,4401,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4418,4420,4421,4422,4423,4424,4425,4426,4427,4428,4429,4430,4431,4432,4433,4434,4435,4436,4437,4438,4439,4440,4441,4443,4444,4445,4446,4448,4449,4450,4451,4452,4453,4454,4455,4456,4457,4458,4459,4460,4461,4462,4463,4464,4465,4469,4471,4475,4476,4477,4478,4479,4480,4481,4482,4484,4485,4487,4488,4489,4490,4491,4494,4495,4496,6017,6018,4811,4812,4813,4814,4815,4816,4817,4818,4819,4820,4821,4822,4824,4825,4828,4829,4830,4831,4832,4833,4834,6133,4838,4839,4840,4841,4842,4843,4845,4846,4848,4849,4850,4857,4859,4863,4864,4865,4869,4870,4872,4873,4874,4876,6009,4882,4883,4884,4885,4889,4891,4892,4894,4896,4897,4898,4899,4900,4901,4902,4903,4904,4905,4906,4907,4908,4909,4910,4911,6019,6020,6021,6022,6023,6024,6028,6029,6030,6034,6429,6036,6037,6038,6041,6042,6043,6044,6045,6046,6047,6048,6049,6050,6052,6053,6054,6055,6056,6057,6059,6060,6062,6063,6064,6066,6067,6068,6069,6070,6071,6072,6073,6074,6075,6076,6078,6079,6082,6084,6085,6086,6088,6089,6090,6091,6092,6093,6094,6095,6096,6101,6102,6103,6105,4912,4913,4917,4918,4919,4920,4921,4923,4926,4931,4932,4933,4934,4935,4936,4937,4941,4942,4943,4944,4947,4950,4951,4952,4953,4955,4956,4957,4959,4961,4962,4963,4964,4965,4966,4967,4968,4972,4986,4987,4990,4991,4992,4993,4994,4995,4996,4997,4998,4999,6473,6001,6006,6106,6109,6110,6112,6113,6114,6115,6123,6426,6126,6129,6130,6131,6132,6135,6136,6138,6140,6141,6142,6143,6144,6145,6146,6147,6149,6150,6152,6156,6157,6227,6453,6160,6161,6162,6163,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,6176,6177,6178,6179,6180,6181,6182,6184,6187,6188,6189,6191,6194,6195,6196,6010,6011,6012,6013,6014,6015,6538,6539,6540,6541,6542,6543,6544,6545,6546,6547,6548,6549,6550,6551,6552,6553,6554,6555,6556,6557,6558,6559,6560,6561,6562,6563,6564,6489,6566,6567,6568,6569,6570,6571,6572,6573,6574,6575,6576,6577,6578,6579,6580,6581,6582,6583,6584,6585,6586,6587,6588,6589,6590,6591,6592,6593,6594,6595,6598,6599,6600,6601,6602,6603,6605,6606,6607,6608,6609,6610,6611,6613,6197,6198,6199,6200,6201,6202,6203,6204,6205,6206,6207,6208,6209,6212,6213,6214,6215,6216,6217,6218,6219,6220,6221,6223,6224,6225,6226,6230,6231,6232,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6248,6249,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6263,6264,6265,6266,6268,6269,6270,6271,6272,6273,6274,6275,6276,6277,6278,6279,6280,6281,6282,6283,6284,6285,6286,6287,6289,6290,6291,6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6305,6306,6308,6309,6310,6312,6314,6316,6318,6319,6321,6322,6324,6325,6326,6328,6329,6330,6331,6332,6334,6335,6336,6337,6342,6339,6340,6341,6343,6344,6345,6346,6347,6348,6349,6350,6352,6356,6357,6360,6361,6362,6363,6364,6365,6366,6367,6368,6369,6370,6371,6372,6373,6374,6375,6376,6377,6378,6379,6381,6382,6383,6384,6385,6386,6387,6394,6395,6396,6397,6398,6399,6400,6401,6402,6403,6404,6407,6408,6409,6411,6416,6447,6419,6420,6421,6422,6423,6424,6425,6427,6433,6434,6437,6441,6442,6449,6452,6454,6455,6456,6458,6459,6460,6461,6462,6463,6464,6465,6466,6468,6469,6470,6471,6472,6475,6476,6478,6479,6480,6481,6484,6485,6486,6487,6488,6499,6500,6502,6503,6504,6505,6509,6511,6512,6513,6514,6515,6516,6517,6519,6520,6532,6533)
                      AND INVENNO != -1
                      GROUP BY STOCKREF,INVENNO