Query For External Banks which are not transferred from 11i to R12.1.3

By
Advertisement
Query For External Banks which are not transferred from 11i to R12.1.3:



select * from AP_BANK_ACCOUNTS_all
where BANK_ACCOUNT_ID not in (
select EXTERNAL_BANK_ACCOUNT_ID from AP_BANK_ACCOUNT_USES_all)
and ACCOUNT_TYPE != 'INTERNAL'
and CREATION_DATE <= '05-jan-2013'