Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- solicantic0_.ID_SOLIC_ANTICIPO AS ID1_39_0_,
- monedasvo1_.ID_MONEDA AS ID1_24_1_,
- solicantic0_.CONCEPTO AS CONCEPTO39_0_,
- solicantic0_.ID_DELEGACION AS ID17_39_0_,
- solicantic0_.EJERCICIO AS EJERCICIO39_0_,
- solicantic0_.FECHA_CREACION AS FECHA4_39_0_,
- solicantic0_.ID_AREA_CONTABLE AS ID5_39_0_,
- solicantic0_.ID_SUBDIVISION AS ID6_39_0_,
- solicantic0_.IMPORTE_EUROS AS IMPORTE7_39_0_,
- solicantic0_.IMPORTE_MONEDA AS IMPORTE8_39_0_,
- solicantic0_.IND_AUTORIZADOR_PREDEF AS IND9_39_0_,
- solicantic0_.MATRICULA_AUTORIZADOR AS MATRICULA10_39_0_,
- solicantic0_.MATRICULA_CREADOR AS MATRICULA11_39_0_,
- solicantic0_.MATRICULA_EMPLEADO AS MATRICULA12_39_0_,
- solicantic0_.ID_MONEDA AS ID18_39_0_,
- solicantic0_.NOMBRE_AUTORIZADOR AS NOMBRE13_39_0_,
- solicantic0_.NOMBRE_CREADOR AS NOMBRE14_39_0_,
- solicantic0_.NOMBRE_EMPLEADO AS NOMBRE15_39_0_,
- solicantic0_.TIPO_FORMA_PAGO AS TIPO16_39_0_,
- monedasvo1_.COD_MONEDA AS COD2_24_1_,
- monedasvo1_.DES_MONEDA AS DES3_24_1_
- FROM
- ULIQUI.SOLIC_ANTICIPO solicantic0_
- LEFT OUTER JOIN
- ULIQUI.MONEDAS monedasvo1_
- ON
- solicantic0_.ID_MONEDA= monedasvo1_.ID_MONEDA
- LEFT OUTER JOIN
- ULIQUI.SOLIC_ANTICIPO_ENVIO solicantic2_
- ON
- solicantic0_.ID_SOLIC_ANTICIPO= solicantic2_.ID_SOLIC_ANTICIPO
- WHERE
- (
- solicantic0_.ID_SOLIC_ANTICIPO IS NOT NULL
- )
- AND
- (
- solicantic0_.ID_SOLIC_ANTICIPO IN (724 , 743 , 761 , 784 , 804 , 882 , 883 , 884 , 885 , 901 , 902 , 903 , 922 , 923 , 924 , 925 , 926 , 941 , 942 , 943 , 944 , 947 , 948 , 949 , 950 , 951 , 954 , 955 , 956 , 1021, 1041, 1042, 1062, 1081, 1082, 1101, 1103, 1104, 1121, 1122, 1123, 1164, 1181, 1223, 1224, 1242, 1243, 1262, 1264, 1281, 1282, 1283, 1284, 1301, 1302, 1322, 1323, 1324, 1325, 1326, 1328, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396)
- )
- AND
- (
- solicantic0_.MATRICULA_EMPLEADO = '22047576'
- OR solicantic0_.MATRICULA_CREADOR= '22047576'
- )
- ORDER BY
- solicantic0_.ID_SOLIC_ANTICIPO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement