Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CABECERA,
- IDTAREA,
- CANTIDAD_R AS CANTIDAD,
- FECHA_R AS FECHA,
- TALLER,
- NUMERO,
- OBSERVACIONES,
- USUARIO
- FROM
- (
- SELECT
- ID_CAB AS CABECERA,
- ID_CAB,
- ID_ARTICULO AS IDTAREA,
- SUM(CANTIDAD) AS CANTIDAD_R
- FROM
- MASEFER.TALLER_REMITO_ITEM
- GROUP BY
- ID_ARTICULO,
- ID_CAB
- ) A
- LEFT JOIN (
- SELECT
- FECHA AS FECHA_R,
- DEPOSITO_DESTINO AS TALLER,
- ID_CAB,
- NUMERO AS NUMERO,
- OBSERVACIONES,
- USUARIO
- FROM
- MASEFER.TALLER_REMITO_CAB
- ) B ON A.ID_CAB = B.ID_CAB
- WHERE
- IDTAREA = ${tareaId}
- AND TALLER = ${tallerId}
- UNION
- SELECT
- CABECERA,
- IDTAREA,
- CANTIDAD_R,
- FECHA_R,
- TALLER,
- NUMERO,
- OBSERVACIONES,
- USUARIO
- FROM
- (
- SELECT
- ID_CAB AS CABECERA,
- ID_CAB,
- ID_ARTICULO AS IDTAREA,
- - SUM(CANTIDAD) AS CANTIDAD_R
- FROM
- MASEFER.TALLER_REMITO_ITEM
- GROUP BY
- ID_ARTICULO,
- ID_CAB
- ) A
- LEFT JOIN (
- SELECT
- FECHA AS FECHA_R,
- DEPOSITO_ORIGEN AS TALLER,
- ID_CAB,
- NUMERO AS NUMERO,
- OBSERVACIONES,
- USUARIO
- FROM
- MASEFER.TALLER_REMITO_CAB
- ) B ON A.ID_CAB = B.ID_CAB
- WHERE
- IDTAREA = ${tareaId}
- AND TALLER = '${tallerId}'
- ORDER BY FECHA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement