SELECT DISTINCT TRX.REQUEST_ID , TRX.CREATED_FROM , TRX.BATCH_SOURCE_ID FROM RA_CUSTOMER_TRX TRX , RA_CUST_TRX_TYPES_ALL TRXT WHERE TRX.COMPLETE_FLAG = 'Y' AND EXISTS ( SELECT 1 FROM JE_PT_RA_CUST_TRX_EXTS EXT WHERE EXT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID AND EXT.SIGNATURE IS NULL) AND TRX.CUST_TRX_TYPE_ID = TRXT.CUST_TRX_TYPE_ID AND TRXT.TYPE NOT IN ('PMT' , 'BR') AND TRX.ORG_ID = TRXT.ORG_ID AND TRX.CREATED_FROM IN ('ARXREC' , 'RAXTRX') AND EXISTS ( SELECT 1 FROM FND_DOCUMENT_SEQUENCES WHERE DOC_SEQUENCE_ID = TRX.DOC_SEQUENCE_ID AND TYPE <> 'M')