Advertisement
Guest User

Untitled

a guest
Nov 21st, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.54 KB | None | 0 0
  1. SELECT DISTINCT
  2.     solicantic0_.ID_SOLIC_ANTICIPO      AS ID1_39_0_,
  3.     monedasvo1_.ID_MONEDA               AS ID1_24_1_,
  4.     solicantic0_.CONCEPTO               AS CONCEPTO39_0_,
  5.     solicantic0_.ID_DELEGACION          AS ID17_39_0_,
  6.     solicantic0_.EJERCICIO              AS EJERCICIO39_0_,
  7.     solicantic0_.FECHA_CREACION         AS FECHA4_39_0_,
  8.     solicantic0_.ID_AREA_CONTABLE       AS ID5_39_0_,
  9.     solicantic0_.ID_SUBDIVISION         AS ID6_39_0_,
  10.     solicantic0_.IMPORTE_EUROS          AS IMPORTE7_39_0_,
  11.     solicantic0_.IMPORTE_MONEDA         AS IMPORTE8_39_0_,
  12.     solicantic0_.IND_AUTORIZADOR_PREDEF AS IND9_39_0_,
  13.     solicantic0_.MATRICULA_AUTORIZADOR  AS MATRICULA10_39_0_,
  14.     solicantic0_.MATRICULA_CREADOR      AS MATRICULA11_39_0_,
  15.     solicantic0_.MATRICULA_EMPLEADO     AS MATRICULA12_39_0_,
  16.     solicantic0_.ID_MONEDA              AS ID18_39_0_,
  17.     solicantic0_.NOMBRE_AUTORIZADOR     AS NOMBRE13_39_0_,
  18.     solicantic0_.NOMBRE_CREADOR         AS NOMBRE14_39_0_,
  19.     solicantic0_.NOMBRE_EMPLEADO        AS NOMBRE15_39_0_,
  20.     solicantic0_.TIPO_FORMA_PAGO        AS TIPO16_39_0_,
  21.     monedasvo1_.COD_MONEDA              AS COD2_24_1_,
  22.     monedasvo1_.DES_MONEDA              AS DES3_24_1_
  23. FROM
  24.     ULIQUI.SOLIC_ANTICIPO solicantic0_
  25. LEFT OUTER JOIN
  26.     ULIQUI.MONEDAS monedasvo1_
  27.     ON
  28.     solicantic0_.ID_MONEDA= monedasvo1_.ID_MONEDA
  29. LEFT OUTER JOIN
  30.     ULIQUI.SOLIC_ANTICIPO_ENVIO solicantic2_
  31.     ON
  32.     solicantic0_.ID_SOLIC_ANTICIPO= solicantic2_.ID_SOLIC_ANTICIPO
  33. WHERE
  34.     (
  35.         solicantic0_.ID_SOLIC_ANTICIPO IS NOT NULL
  36.     )
  37.     AND
  38.     (
  39.         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)
  40.     )
  41.     AND
  42.     (
  43.         solicantic0_.MATRICULA_EMPLEADO  = '22047576'
  44.         OR solicantic0_.MATRICULA_CREADOR= '22047576'
  45.     )
  46. ORDER BY
  47.     solicantic0_.ID_SOLIC_ANTICIPO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement