Links Between bank_Tables oracle apps r12

Links Between bank_Tables oracle apps r12 

CE_statment_headers and ce_statment_lines 

Banks and banks_branches 

Status of statement lines 

select  CBA.bank_account_num ,CSL.Statment_line_id        

FROM       ce_statement_headers CSH

          ,ce_statement_lines CSL

          ,ce_bank_branches_v CBB

          ,ce_bank_accounts CBA

          ,ce_lookups CL

          ,ce_transaction_codes CTC

WHERE CSH.statement_header_id=CSL.statement_header_id

AND CSH.bank_account_id=CBA.bank_account_id

AND CBB.BRANCH_PARTY_ID(+)         = CBA.BANK_BRANCH_ID

AND CTC.trx_code = CSL.trx_code                             

AND CTC.bank_account_id = CBA.bank_account_id  

AND CSL.status  ='UNRECONCILED'

AND CSL.trx_date BETWEEN '01-JAN-20' AND '07-MAY-20'

AND CL.lookup_code = CSL.trx_type

AND CL.lookup_type  = 'BANK_TRX_TYPE'

AND upper (cba.bank_account_name) LIKE '*********'

and CBB.bank_branch_name='********';