Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT LOG.wh_id Armazém
- , LOG.tran_type AS "Tipo transação"
- , NVL(LOG.description, (SELECT description
- FROM t_transaction
- WHERE tran_type = LOG.tran_type
- AND ROWNUM = 1)) Descrição
- , LOG.start_tran_date AS "Data início"
- , TO_CHAR(LOG.start_tran_time, 'HH24:MI:SS') AS "Hora início"
- , TO_CHAR(LOG.end_tran_date, 'DD/MM/YYYY') AS "Data final"
- , LOG.end_tran_time AS "Hora final"
- , LOG.employee_id AS "Funcionário"
- , LOG.control_number
- , LOG.control_number_2
- , LOG.line_number AS "Linha"
- , LOG.item_number
- , LOG.tran_qty AS "Quantidade"
- , USF_GET_SKU_PACK_QTY(LOG.item_number, LOG.wh_id, LOG.tran_qty) AS "QtdPeças"
- , (SELECT u.uom
- FROM t_item_uom u
- WHERE u.wh_id = LOG.wh_id
- AND u.item_number = LOG.item_number
- AND ROWNUM = 1) AS "UOM"
- , LOG.location_id
- , LOG.location_id_2
- , LOG.hu_id
- , LOG.hu_id_2
- , LOG.parent_hu_id
- , LOG.parent_hu_id_2
- , LOG.routing_code AS "Placa Veículo"
- , LOG.elapsed_time AS "Tempo decorrido"
- , LOG.outside_id AS "Referência"
- , LOG.generic_attribute_11 AS "Ajuste observação"
- FROM t_tran_log LOG
- WHERE TRUNC(LOG.start_tran_date) = TRUNC(SYSDATE - 1)
- AND LOG.tran_type IN ('121','123','125','127','129','131','133','135','137','139','143','145','326','327')
- AND LOG.wh_id = '324'
- ORDER BY LOG.tran_log_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement