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='********';

Post a Comment