-- LPNs de caixaria com Pai associado
SELECT * FROM t_hu_master
WHERE parent_hu_id LIKE 'LPN%'
AND container_type = 'CX';

SELECT * FROM t_tran_log LOG
WHERE LOG.tran_type = '402'
AND EXISTS (SELECT 1 FROM t_hu_master hum
            WHERE hum.parent_hu_id LIKE 'LPN%'
            AND hum.container_type = 'CX'
            AND hum.hu_id = LOG.hu_id
            AND hum.wh_id = LOG.wh_id);

-- LPN's com parent_hu_id zoado
SELECT * FROM t_hu_master
WHERE parent_hu_id NOT LIKE 'LPN%'
AND regexp_like(parent_hu_id, '[[:alpha:]]')
AND location_id <> 'RETENCAO';

-- LPN avô
SELECT * FROM t_hu_master
WHERE SUBTYPE = 'P'
AND parent_hu_id LIKE 'LPN%';