PO Receiving Interface Errors

select poi.column_name column_name2,poi.error_message,
	rti.interface_transaction_id,
	rti.vendor_name,
	rti.vendor_num,
	rti.shipment_num,
	rti.transaction_type,
	to_char(rti.transaction_date,'DD-MON-YYYY HH24:MI:SS') transaction_date,
	to_char(rti.creation_date,'DD-MON-YYYY HH24:MI:SS') creation_date,
	rti.created_by,
	rti.to_organization_code,
	rti.ship_to_location_code,
	rti.document_num,
	rti.release_num,
	rti.document_line_num,
	rti.document_shipment_line_num,
	rti.vendor_item_num,
	rti.item_num,
                rti.job_id,
                rti.timecard_id,
                rti.timecard_ovn,
	rti.substitute_item_num,
	rti.item_description,
	to_char(rti.expected_receipt_date,'DD-MON-YYYY HH24:MI:SS') expected_receipt_date,
	rti.quantity,
                rti.amount,
	rti.unit_of_measure,
	rti.quantity_invoiced
from po_interface_errors poi,rcv_transactions_interface rti
     where 
          ((poi.interface_line_id = rti.interface_transaction_id and
          poi.interface_type='RCV-856') or
          (poi.interface_transaction_id = rti.interface_transaction_id and
          poi.interface_type in ('RECEIVE','DELIVER'))) and 
                    ((trunc(to_date(to_char(poi.creation_date,'DD-MON-YYYY'),'DD-MON-YYYY')) between 
 nvl(:p_start_date,poi.creation_date) and 
 nvl(:p_end_date,sysdate) and
(:p_start_date is not null or :p_end_date is not null)) OR
        (:p_start_date is null and :p_end_date is null and rti.processing_status_code NOT IN ('PENDING')))
           order by rti.interface_transaction_id,rti.vendor_name