eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_MERGE dependencies on IBY_EXT_BANK_ACCOUNTS

Line 247: iby_ext_bank_accounts from_accounts,

243: (
244: SELECT To_uses.instrument_payment_use_id FROM
245: iby_pmt_instr_uses_all from_uses,
246: iby_pmt_instr_uses_all to_uses,
247: iby_ext_bank_accounts from_accounts,
248: iby_ext_bank_accounts to_accounts
249: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id
250: AND from_uses.instrument_type = 'BANKACCOUNT'
251: AND from_uses.instrument_id = from_accounts.ext_bank_account_id

Line 248: iby_ext_bank_accounts to_accounts

244: SELECT To_uses.instrument_payment_use_id FROM
245: iby_pmt_instr_uses_all from_uses,
246: iby_pmt_instr_uses_all to_uses,
247: iby_ext_bank_accounts from_accounts,
248: iby_ext_bank_accounts to_accounts
249: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id
250: AND from_uses.instrument_type = 'BANKACCOUNT'
251: AND from_uses.instrument_id = from_accounts.ext_bank_account_id
252: AND to_accounts.iban_hash1 = from_accounts.iban_hash1

Line 268: iby_ext_bank_accounts from_accounts,

264: (
265: SELECT To_uses.instrument_payment_use_id FROM
266: iby_pmt_instr_uses_all from_uses,
267: iby_pmt_instr_uses_all to_uses,
268: iby_ext_bank_accounts from_accounts,
269: iby_ext_bank_accounts to_accounts
270: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id
271: AND from_uses.instrument_type = 'BANKACCOUNT'
272: AND from_uses.instrument_id = from_accounts.ext_bank_account_id

Line 269: iby_ext_bank_accounts to_accounts

265: SELECT To_uses.instrument_payment_use_id FROM
266: iby_pmt_instr_uses_all from_uses,
267: iby_pmt_instr_uses_all to_uses,
268: iby_ext_bank_accounts from_accounts,
269: iby_ext_bank_accounts to_accounts
270: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id
271: AND from_uses.instrument_type = 'BANKACCOUNT'
272: AND from_uses.instrument_id = from_accounts.ext_bank_account_id
273: AND to_accounts.iban_hash1 = from_accounts.iban_hash1

Line 430: iby_ext_bank_accounts from_accounts,

426: SET instr_assignment_id =
427: (SELECT to_uses.instrument_payment_use_id FROM
428: iby_pmt_instr_uses_all from_uses,
429: iby_pmt_instr_uses_all to_uses,
430: iby_ext_bank_accounts from_accounts,
431: iby_ext_bank_accounts to_accounts
432: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id
433: AND from_uses.instrument_type = 'BANKACCOUNT'
434: AND from_uses.instrument_id = from_accounts.ext_bank_account_id

Line 431: iby_ext_bank_accounts to_accounts

427: (SELECT to_uses.instrument_payment_use_id FROM
428: iby_pmt_instr_uses_all from_uses,
429: iby_pmt_instr_uses_all to_uses,
430: iby_ext_bank_accounts from_accounts,
431: iby_ext_bank_accounts to_accounts
432: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id
433: AND from_uses.instrument_type = 'BANKACCOUNT'
434: AND from_uses.instrument_id = from_accounts.ext_bank_account_id
435: AND to_accounts.iban_hash1 = from_accounts.iban_hash1

Line 463: iby_ext_bank_accounts from_accounts,

459:
460: SELECT to_uses.instrument_payment_use_id FROM
461: iby_pmt_instr_uses_all from_uses,
462: iby_pmt_instr_uses_all to_uses,
463: iby_ext_bank_accounts from_accounts,
464: iby_ext_bank_accounts to_accounts
465: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id
466: AND from_uses.instrument_type = 'BANKACCOUNT'
467: AND from_uses.instrument_id = from_accounts.ext_bank_account_id

Line 464: iby_ext_bank_accounts to_accounts

460: SELECT to_uses.instrument_payment_use_id FROM
461: iby_pmt_instr_uses_all from_uses,
462: iby_pmt_instr_uses_all to_uses,
463: iby_ext_bank_accounts from_accounts,
464: iby_ext_bank_accounts to_accounts
465: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id
466: AND from_uses.instrument_type = 'BANKACCOUNT'
467: AND from_uses.instrument_id = from_accounts.ext_bank_account_id
468: AND to_accounts.iban_hash1 = from_accounts.iban_hash1

Line 662: iby_ext_bank_accounts from_account,

658: AND payment_function = 'CUSTOMER_PAYMENT'
659: AND NOT EXISTS
660: (
661: SELECT 1 FROM
662: iby_ext_bank_accounts from_account,
663: iby_ext_bank_accounts to_account,
664: iby_pmt_instr_uses_all uses
665: WHERE from_account.ext_bank_account_id = dup.instrument_id
666: AND to_account.iban_hash1 = from_account.iban_hash1

Line 663: iby_ext_bank_accounts to_account,

659: AND NOT EXISTS
660: (
661: SELECT 1 FROM
662: iby_ext_bank_accounts from_account,
663: iby_ext_bank_accounts to_account,
664: iby_pmt_instr_uses_all uses
665: WHERE from_account.ext_bank_account_id = dup.instrument_id
666: AND to_account.iban_hash1 = from_account.iban_hash1
667: AND to_account.iban_hash2 = from_account.iban_hash2

Line 740: iby_ext_bank_accounts from_account,

736: AND dup.instrument_type = 'BANKACCOUNT'
737: AND EXISTS
738: (
739: SELECT 1 FROM
740: iby_ext_bank_accounts from_account,
741: iby_ext_bank_accounts to_account,
742: iby_pmt_instr_uses_all uses
743: WHERE from_account.ext_bank_account_id = dup.instrument_id
744: AND to_account.iban_hash1 = from_account.iban_hash1

Line 741: iby_ext_bank_accounts to_account,

737: AND EXISTS
738: (
739: SELECT 1 FROM
740: iby_ext_bank_accounts from_account,
741: iby_ext_bank_accounts to_account,
742: iby_pmt_instr_uses_all uses
743: WHERE from_account.ext_bank_account_id = dup.instrument_id
744: AND to_account.iban_hash1 = from_account.iban_hash1
745: AND to_account.iban_hash2 = from_account.iban_hash2