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'
0 comments:
Post a Comment