XML generating empty row
When I run the SQL, it produces one row.
SELECT
to_char(to_date(max(trx.trx_date),
'DD-MON-RRRR'), 'YYYY/MM/DD') ar_etd
, fnd_date.canonical_to_date(wsh.attribute7)
etd
,
fnd_date.canonical_to_date(wsh.attribute8) eta
, wsh.attribute9 container
, wsh.attribute2 vessel
, oolv.attribute10 meat_number
, oolv.header_id
FROM oe_order_lines_v oolv
, oe_ra_cust_trx_hdr_v trx
, wsh_new_deliveries wsh
, wsh_delivery_assignments wda
, wsh_delivery_details wdd
WHERE oolv.order_number = trx.order_number (+)
AND oolv.line_number = (select min(line_number)
from
oe_order_lines_v ov