Query to fetch bank and branch details

Query to fetch bank and branch details


-- Bank details

SELECT cbv.*

  FROM apps.ce_banks_v cbv

 WHERE cbv.bank_number IN ('81') AND cbv.home_country = 'AU';

-- Branch details

  SELECT *

    FROM apps.ce_bank_branches_v cbbv

   WHERE 1 = 1 --and cbbv.branch_number =                '00'

               --AND cbbv.bank_number =      '01'

               AND cbbv.bank_home_country = 'NZ';