Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT LOG.wh_id Armazém
  2. , LOG.tran_type AS "Tipo transação"
  3. , NVL(LOG.description, (SELECT description
  4. FROM t_transaction
  5. WHERE tran_type = LOG.tran_type
  6. AND ROWNUM = 1)) Descrição
  7. , LOG.start_tran_date AS "Data início"
  8. , TO_CHAR(LOG.start_tran_time, 'HH24:MI:SS') AS "Hora início"
  9. , TO_CHAR(LOG.end_tran_date, 'DD/MM/YYYY') AS "Data final"
  10. , LOG.end_tran_time AS "Hora final"
  11. , LOG.employee_id AS "Funcionário"
  12. , LOG.control_number
  13. , LOG.control_number_2
  14. , LOG.line_number AS "Linha"
  15. , LOG.item_number
  16. , LOG.tran_qty AS "Quantidade"
  17. , USF_GET_SKU_PACK_QTY(LOG.item_number, LOG.wh_id, LOG.tran_qty) AS "QtdPeças"
  18. , (SELECT u.uom
  19. FROM t_item_uom u
  20. WHERE u.wh_id = LOG.wh_id
  21. AND u.item_number = LOG.item_number
  22. AND ROWNUM = 1) AS "UOM"
  23. , LOG.location_id
  24. , LOG.location_id_2
  25. , LOG.hu_id
  26. , LOG.hu_id_2
  27. , LOG.parent_hu_id
  28. , LOG.parent_hu_id_2
  29. , LOG.routing_code AS "Placa Veículo"
  30. , LOG.elapsed_time AS "Tempo decorrido"
  31. , LOG.outside_id AS "Referência"
  32. , LOG.generic_attribute_11 AS "Ajuste observação"
  33. FROM t_tran_log LOG
  34. WHERE TRUNC(LOG.start_tran_date) = TRUNC(SYSDATE - 1)
  35. AND LOG.tran_type IN ('121','123','125','127','129','131','133','135','137','139','143','145','326','327')
  36. AND LOG.wh_id = '324'
  37. ORDER BY LOG.tran_log_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement