SELECT * FROM t_hu_master
WHERE hu_id LIKE 'BOX%'
AND hu_id NOT LIKE 'BOXPROV%'
AND regexp_like(SUBSTR(hu_id, 4, 20), '[[:alpha:]]');


https://www.google.com.br/search?q=regular+expression&oq=regular+expression&aqs=chrome..69i57&sourceid=chrome&ie=UTF-8#safe=active&q=oracle+regular+expression+contains+period+comma




SELECT "Armazém"
     , "PO"
     , "Item"
     , REGEXP_REPLACE("Descrição do Item", '[[:space:]]+', CHR(32)) AS "Descrição do Item"
     , "Data do Recebimento"
     , (SELECT SUM(qty_received) FROM t_receipt WHERE po_number = "PO" AND wh_id = "Armazém") AS "Quantidade Recebida"
     , (SELECT usf_get_sku_pack_qty("Item", "Armazém", (SELECT SUM(qty_received) FROM t_receipt WHERE po_number = "PO" AND wh_id = "Armazém")) FROM dual)  AS "Quantidade Recebida Pçs"
FROM (SELECT wh_id AS "Armazém"
     , po_number AS "PO"
     , item_number AS "Item"
     , INITCAP((SELECT DISTINCT description FROM t_item_master WHERE item_number = pod.item_number AND wh_id = pod.wh_id)) AS "Descrição do Item"
     , (SELECT MIN(receipt_date) FROM t_receipt WHERE po_number = pod.po_number AND wh_id = pod.wh_id) AS "Data do Recebimento"
FROM t_po_detail pod
WHERE po_number IN (SELECT po_number FROM t_po_master WHERE display_po_number IN ('2089637','2133265','2129873','2160005','2078462','2122481','2147249','2099452','2137511','2137020')))
ORDER BY "PO"