Oracle EBS 12.2.13: Querying specific purchase orders and their line numbers

Hi there,

Please help me specify line numbers in the following query:

select distinct pha.SEGMENT1 "PO Number",pla.LINE_NUM, pla.CLOSED_CODE, PHA.Creation_Date
from
PO.PO_LINES_ALL pla,
PO_headers_all pha
where pla.PO_HEADER_ID = pha.PO_HEADER_ID
and pha.segment1 in
('12345','56789')
--and pla.CLOSED_CODE = 'FINALLY CLOSED'
order by pha.SEGMENT1 asc
;

This is a query for as many as 1000 PO lines, thanks.