3 Replies Latest reply: Jan 13, 2014 1:26 AM by Octopus Rex RSS

r12 Upgrade - Code Retrofit - CE_BANK_ACCOUNTS map with vendor_id

SUChandra Newbie
Currently Being Moderated



We have a SQl to retrofit to R12. AP_BANKS tables are replaced with CE_BANKS but I don't see vendor_id and vendor_site_id in CE tables.


Here is the SQL for your reference and please share some inputs on mappings between CE_BANKS and AP_SUPPLIERS tables;


This SQL is from 11.5.10 environment: need to change specific to 12.


select distinct abb.bank_number, abb.bank_num, replace(substr(abaa.bank_account_num,1,11),'-',null)

  from ap_bank_account_uses_all abaua,

            ap_bank_accounts_all abaa,

            ap_bank_branches abb

where abaua.external_bank_account_id = abaa.bank_account_id

   and abaa.bank_branch_id = abb.bank_branch_id

   and abaua.vendor_id = check_r.vendor_id

   and abaua.vendor_site_id = v_vendor_site_id

   and abaua.external_bank_account_id = check_r.external_bank_account_id 

   and abaa.currency_code = check_r.currency_code

   and abaua.primary_flag='Y'

   and abaua.org_id = fnd_profile.value('org_id');


  • Correct Answers - 10 points
  • Helpful Answers - 5 points