Change in bank table structure in R12
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.
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.
Tagged:
0