A QUery

/* Formatted on 2012/07/20 12:19 (Formatter Plus v4.8.8) */
SELECT transactiontype transtype,
       DECODE (transactiontype,
               'C', 'Cheque',
               'D', 'DD',
               'I', 'Internal transfer',
               'B', DECODE (vouchertype,
                            'P', 'Direct Debit',
                            'Direct Credit'
                           ),
              
--              (case when voucher.vouchertype='P' then voucher.transactiontype ='B' else
  --                  when voucher.vouchertype='P' then voucher.transactiontype ='B' end)
               --'B', 'Direct Credit',
               'S', 'Cash'
              ) transactiontype,
       NVL (voucher.voucherno, ' ') voucherno, voucher.accountno accountno,
       keyno, bankname, NVL (othermodulelink, 'N') othermodulelink, fyear,
       vouchertype vtype,
       DECODE (vouchertype,
               'P', 'Payment',
               'A', 'Adjustment',
               'R', 'Receipt',
               'C', 'Contra',
               'N', 'Recovery Note',
               ' '
              ) vouchertype,
       NVL (partytype, ' ') partytype, voucher.trusttype trusttype,
       (CASE
           WHEN partytype = 'E'
              THEN ecpfacno
           WHEN partytype = 'B'
              THEN (SELECT bankname
                      FROM cb_bank_info
                     WHERE accountno = emp_party_code)
           ELSE emp_party_code
        END
       ) emp_party_code,
       emp_party_code partydt, NVL (empno, ' ') empno,
       (CASE
           WHEN partytype = 'E' AND voucher.pfidflag = 'true'
              THEN employeename
           WHEN partytype = 'E'
              THEN (SELECT employeename
                      FROM episfin.employeeinfo
                     WHERE emplnumber = voucher.empno)
           WHEN partytype = 'R'
              THEN (SELECT employeename
                      FROM employee_personal_info
                     WHERE medicalno = voucher.medicalno)
           ELSE emp_party_code
        END
       ) partydetails,
       (CASE
           WHEN partytype = 'E'
              THEN (SELECT designationdesc
                      FROM episfin.employeeinfo employee,
                           episfin.staffdesignation desig
                     WHERE employee.designationcd = desig.designationcd
                       AND emplnumber = voucher.empno)
           WHEN partytype = 'R'
              THEN (SELECT desegnation
                      FROM employee_personal_info
                     WHERE medicalno = voucher.medicalno)
           ELSE '--'
        END
       ) designation,
       NVL (username, ' ') preparedby, NVL (voucherno, ' ') voucherno,
       NVL (checkedby, ' ') checkedby, NVL (approvedby, ' ') approvedby,
       NVL (details, ' ') details,
       NVL (TO_CHAR (voucher_dt, 'dd/Mon/YYYY'), ' ') voucher_dt, approval,
       TO_CHAR (preperation_dt, 'dd/Mon/YYYY') preperation_dt,
       NVL (stationname, '') stationname, NVL (unit_name, ' ') fullunitname,
       NVL (cancel_status, '--') cancel_status,
       NVL (TO_CHAR (cancel_voucher_date, 'dd/Mon/yyyy'),
            '--'
           ) cancel_voucher_date,
       NVL (cancel_remarks, '--') cancel_remarks,
       NVL (typeof_travel, '') typeof_travel
  FROM cb_voucher_info voucher,
       cb_bank_info bank,
       epis_user,
       epis_unitmaster unit
 WHERE userid(+) = preparedby
   AND voucher.stationname = unit.unitcode(+)
   AND bank.accountno = voucher.accountno
--AND UPPER (TRIM (keyno)) = UPPER (TRIM ('190712000009'))