Payables and Cash Management - EBS (MOSC)

MOSC Banner

Change in bank table structure in R12

edited Oct 21, 2009 7:16PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
hi,
I have created view which refers table iby_ext_bank_accounts. I want to select org_id in that view but org_id is not present in  iby_ext_bank_accounts table, so I tried to use iby_pmt_instr_uses_all and iby_external_payees_all (This table have Org_id) and the query is

     SELECT *
      FROM   iby_external_payees_all iep
      ,      iby_pmt_instr_uses_all ipi
      ,      iby_ext_bank_accounts ieb
      WHERE  iep.ext_payee_id        = ipi.ext_pmt_party_id
      AND    ipi.instrument_id       = ieb.ext_bank_account_id
but i do not know if these conditions are right. Can someone help me in identifying if these joins are right? If these are not the correct can someone help me writting new query.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center