Banks Accounts

Dear All,

im trying to build a query to get all bank details :

but still need the cash clearing account

my query:

--select owner, object_type ,object_name from all_objects where object_name like UPPER( '%combinations%') and object_type like 'TAB%'

SELECT  distinct 

         HOU.NAME OPERATING_UNIT ,

         BRNCH.BANK_NAME,                                

         BRNCH.BANK_BRANCH_NAME BRANCH_NAME,    

         BNK.BANK_ACCOUNT_NUM ACCOUNT_NUM,

         BNK.BANK_ACCOUNT_NAME_ALT ,

         BNK.ACCOUNT_SUFFIX,

         BNK.ACCOUNT_CLASSIFICATION TYPE,

         BNK.CURRENCY_CODE,

         gcf.CONCATENATED_SEGMENTS cash_gl_Account

 

  FROM   CE_BANK_ACCOUNTS BNK,

         CE_BANK_ACCT_USES_ALL SITE,

         CEFV_BANK_BRANCHES BRNCH,