SELECT PLLA.*
FROM PO_HEADERS_ARCHIVE_ALL PHA
,PO_LINES_ARCHIVE_ALL PLA
,PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
WHERE PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
AND PLA.PO_LINE_ID = PLLA.PO_LINE_ID
AND PHA.ORG_ID = 49
AND PHA.CREATION_DATE >= TO_DATE('2010-04'
,'YYYY-MM')
AND PHA.CREATION_DATE < TO_DATE('2012-05'
,'YYYY-MM')
AND PHA.PO_HEADER_ID = 674726
FROM PO_HEADERS_ARCHIVE_ALL PHA
,PO_LINES_ARCHIVE_ALL PLA
,PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
WHERE PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
AND PLA.PO_LINE_ID = PLLA.PO_LINE_ID
AND PHA.ORG_ID = 49
AND PHA.CREATION_DATE >= TO_DATE('2010-04'
,'YYYY-MM')
AND PHA.CREATION_DATE < TO_DATE('2012-05'
,'YYYY-MM')
AND PHA.PO_HEADER_ID = 674726