Query : Bank Interface Tables

select

from IBY_TEMP_PMT_INSTR_USES a, IBY_TEMP_EXT_BANK_ACCTS b, IBY_TEMP_EXT_PAYEES c
where a.load_request_id = b.load_request_id
and b.load_request_id = c.load_request_id
and a.load_request_id = '869668'



select count(*) as IBY_TEMP_PMT_INSTR_USES from IBY_TEMP_PMT_INSTR_USES
union all
select count(*) as IBY_TEMP_EXT_BANK_ACCTS from IBY_TEMP_EXT_BANK_ACCTS
union all
select count(*) as IBY_TEMP_EXT_PAYEES from IBY_TEMP_EXT_PAYEES