1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need eTRM Documents for AP in R12 or a way to join ap_vendor_sites_all to banks r12

Discussion in 'Oracle Apps Technical' started by ibbster, Sep 6, 2011.

  1. ibbster

    ibbster Guest

    Hi

    Can someone provide eTRM Documents for AP in R12 or a way to join ap_vendor_sites_all to banks r12.
    I have checked the Oracle website but the link for R12 still only gives you 11i diagrams

    script below is the closest I've got but as there is no direct link between the sites and the banks I get a cartisian product

    select s.vendor_name, ss.vendor_site_code, eb.bank_name, ebb.bank_branch_name, ebb.branch_number, s.vendor_id, org_id,
    eba.BANK_ACCOUNT_NUM, eba.BANK_ACCOUNT_NAME
    from ap.ap_suppliers s, ap.ap_supplier_sites_all ss, apps.iby_ext_bank_accounts eba,
    apps.iby_account_owners ao, apps.iby_ext_banks_v eb, apps.iby_ext_bank_branches_v ebb
    where s.vendor_id = ss.vendor_id
    and ao.account_owner_party_id = s.party_id
    and eba.ext_bank_account_id = ao.ext_bank_account_id
    and eb.bank_party_id = ebb.bank_party_id
    and eba.branch_id = ebb.branch_party_id
    and eba.bank_id = eb.bank_party_id
     
  2. lesalazar

    lesalazar Guest

    Re: Need eTRM Documents for AP in R12 or a way to join ap_vendor_sites_all to banks r

    Hi
    When you define a external bank account in R12 you can select the level
    supllier, supplier site, Address - Operating Unit, etc..
    can you check please at wich level you define the bank accounts

    Regards
    Luis