SELECT CBBV_SUR.BANK_NAME SOURCE_BANK,CBBV_DES.BANK_NAME DEST_BANK,CBBV_SUR.BANK_BRANCH_NAME SOURCE_BANK_BR,CBBV_DES.BANK_BRANCH_NAME DEST_BANK_BR,
       BB_SUR.BANK_ACCOUNT_NUM SUR_ACC,BB_DES.BANK_ACCOUNT_NUM DES_ACC,
     BB_SUR.BANK_ACCOUNT_Name SUR_ACC_nm,BB_DES.BANK_ACCOUNT_Name DES_ACC_nm,
       TRXN_REFERENCE_NUMBER,DECODE(TRANSACTION_TYPE,'BAT','BANK ACCOUNT TRANSFER') TRANSACTION_TYPE, 
       TRANSACTION_DATE, TRANSACTION_DESCRIPTION, PAYMENT_CURRENCY_CODE, PAYMENT_AMOUNT, 
       SOURCE_BANK_ACCOUNT_ID, DESTINATION_BANK_ACCOUNT_ID, DESTINATION_PARTY_SITE_ID,TRXN_STATUS_CODE, PAYMENT_METHOD_CODE, 
       AUTHORIZE_FLAG, BANK_CHARGE_BEARER, PAYMENT_REASON_CODE, PAYMENT_REASON_COMMENTS, REMITTANCE_MESSAGE1, REMITTANCE_MESSAGE2, 
       REMITTANCE_MESSAGE3, CREATED_FROM_DIR, CREATE_FROM_STMTLINE_ID, BANK_TRXN_NUMBER, PAYMENT_REQUEST_NUMBER, PAPER_DOCUMENT_NUMBER, 
       DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE, DOC_CATEGORY_CODE, PAYMENT_OFFSET_CCID, RECEIPT_OFFSET_CCID, CASHPOOL_ID, EXT_BANK_ACCOUNT_ID, 
	    BAT.ATTRIBUTE1
FROM CE_PAYMENT_TRANSACTIONS BAT,ce_bank_accounts BB_SUR,CE_BANK_BRANCHES_V CBBV_SUR,
      ce_bank_accounts BB_DES,CE_BANK_BRANCHES_V CBBV_DES
WHERE BAT.SOURCE_BANK_ACCOUNT_ID = BB_SUR.BANK_ACCOUNT_ID AND
      bb_SUR.BANK_BRANCH_ID=cbbv_SUR.BRANCH_PARTY_ID AND
	  BAT.DESTINATION_BANK_ACCOUNT_ID = BB_DES.BANK_ACCOUNT_ID AND
      bb_DES.BANK_BRANCH_ID=cbbv_DES.BRANCH_PARTY_ID AND
 TRUNC(TRANSACTION_DATE) BETWEEN NVL(:P_FROM_TRN_DATE,TRUNC(TRANSACTION_DATE)) AND NVL(:P_TO_TRN_DATE,TRUNC(TRANSACTION_DATE))
 AND NVL(BAT.ATTRIBUTE1,0) BETWEEN nvl(:P_FROM_VOUCHER_NO,NVL(BAT.ATTRIBUTE1,0)) AND NVL(:P_TO_VOUCHER_NO,NVL(BAT.ATTRIBUTE1,0))