How can I nested select in the where to compare two fields from the same table? Something like the following code.
where ORGANIZATION_ID = 18
and CREATION_DATE between to_date('15-Oct-2015', 'DD-MON-YYYY') and to_date('15-Nov-2015', 'DD-MON-YYYY')
and TRANSACTION_TYPE = 'RECEIVE'
and TRANSACTION_ID not in (select PARENT_TRANSACTION_ID from transactions)
order by SHIPMENT_HEADER_ID