Find the transactions interface Pending Transactions in Oracle EBS r12

 select a.transaction_status_code, a.PROCESSING_STATUS_CODE,a.PROCESSING_MODE_CODE, a.FROM_ORGANIZATION_ID, a.TRANSACTION_DATE, a.SUBINVENTORY,b.ORGANIZATION_CODE, b.ORGANIZATION_NAME,

a.TO_ORGANIZATION_ID,p.ORGANIZATION_CODE From_ORG_Code,p.ORGANIZATION_NAME From_ORG,  a.* 

from rcv_transactions_interface a , Org_organization_definitions b, Org_organization_definitions p

where  a.TO_ORGANIZATION_ID = b.ORGANIZATION_ID

and a.FROM_ORGANIZATION_ID = p.ORGANIZATION_ID(+)

--and a.PROCESSING_STATUS_CODE ='PENDING'

and a.transaction_status_code in('ERROR','PENDING')

select * from  rcv_transactions_interface a 

where a.transaction_status_code = 'ERROR' 

and a.PROCESSING_STATUS_CODE='COMPLETED'

and a.PROCESSING_MODE_CODE ='IMMEDIATE' 

--and a.TRANSACTION_DATE <= '29-JUN-2021'

and a.TO_ORGANIZATION_ID in (select b.ORGANIZATION_ID from Org_organization_definitions b where b.ORGANIZATION_NAME like '%-XX-%')