Try the following query to reteive Original Date (promised_date before revision happened):

SELECT promised_date, line_location_id
FROM po_line_locations_archive_all
WHERE (revision_num,...