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_PMT_INSTR_USES_ALL

Line 171: iby_pmt_instr_uses_all from_inst,

167: FORALL i in 1..ext_payer_from_list.COUNT
168: UPDATE iby_trxn_summaries_all DUP
169: SET payer_instr_assignment_id =
170: (SELECT to_instr.instrument_payment_use_id FROM
171: iby_pmt_instr_uses_all from_inst,
172: iby_pmt_instr_uses_all to_instr
173: WHERE from_inst.instrument_payment_use_id = dup.payer_instr_assignment_id
174: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
175: AND to_instr.instrument_id = from_inst.instrument_id

Line 172: iby_pmt_instr_uses_all to_instr

168: UPDATE iby_trxn_summaries_all DUP
169: SET payer_instr_assignment_id =
170: (SELECT to_instr.instrument_payment_use_id FROM
171: iby_pmt_instr_uses_all from_inst,
172: iby_pmt_instr_uses_all to_instr
173: WHERE from_inst.instrument_payment_use_id = dup.payer_instr_assignment_id
174: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
175: AND to_instr.instrument_id = from_inst.instrument_id
176: AND from_inst.ext_pmt_party_id = ext_payer_from_list(i)

Line 186: iby_pmt_instr_uses_all from_inst,

182: AND status <> 0
183: AND EXISTS
184: (
185: SELECT to_instr.instrument_payment_use_id FROM
186: iby_pmt_instr_uses_all from_inst,
187: iby_pmt_instr_uses_all to_instr
188: WHERE from_inst.instrument_payment_use_id = dup.payer_instr_assignment_id
189: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
190: AND to_instr.instrument_id = from_inst.instrument_id

Line 187: iby_pmt_instr_uses_all to_instr

183: AND EXISTS
184: (
185: SELECT to_instr.instrument_payment_use_id FROM
186: iby_pmt_instr_uses_all from_inst,
187: iby_pmt_instr_uses_all to_instr
188: WHERE from_inst.instrument_payment_use_id = dup.payer_instr_assignment_id
189: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
190: AND to_instr.instrument_id = from_inst.instrument_id
191: AND from_inst.ext_pmt_party_id = ext_payer_from_list(i)

Line 203: iby_pmt_instr_uses_all from_uses,

199: FORALL i in 1..ext_payer_from_list.COUNT
200: UPDATE iby_trxn_summaries_all dup
201: SET payer_instr_assignment_id =
202: (SELECT to_uses.instrument_payment_use_id FROM
203: iby_pmt_instr_uses_all from_uses,
204: iby_pmt_instr_uses_all to_uses,
205: iby_creditcard from_cards,
206: iby_creditcard to_cards
207: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id

Line 204: iby_pmt_instr_uses_all to_uses,

200: UPDATE iby_trxn_summaries_all dup
201: SET payer_instr_assignment_id =
202: (SELECT to_uses.instrument_payment_use_id FROM
203: iby_pmt_instr_uses_all from_uses,
204: iby_pmt_instr_uses_all to_uses,
205: iby_creditcard from_cards,
206: iby_creditcard to_cards
207: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id
208: AND from_uses.instrument_id = from_cards.instrid

Line 222: iby_pmt_instr_uses_all from_uses,

218: AND ext_payer_to_list(i) is not null
219: AND EXISTS
220: (
221: SELECT To_uses.instrument_payment_use_id FROM
222: iby_pmt_instr_uses_all from_uses,
223: iby_pmt_instr_uses_all to_uses,
224: iby_creditcard from_cards,
225: iby_creditcard to_cards
226: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id

Line 223: iby_pmt_instr_uses_all to_uses,

219: AND EXISTS
220: (
221: SELECT To_uses.instrument_payment_use_id FROM
222: iby_pmt_instr_uses_all from_uses,
223: iby_pmt_instr_uses_all to_uses,
224: iby_creditcard from_cards,
225: iby_creditcard to_cards
226: WHERE from_uses.instrument_payment_use_id = dup.payer_instr_assignment_id
227: AND from_uses.instrument_type = 'CREDITCARD'

Line 245: iby_pmt_instr_uses_all from_uses,

241: UPDATE iby_trxn_summaries_all dup
242: SET payer_instr_assignment_id =
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

Line 246: iby_pmt_instr_uses_all to_uses,

242: SET payer_instr_assignment_id =
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'

Line 266: iby_pmt_instr_uses_all from_uses,

262: AND ext_payer_to_list(i) is not null
263: AND EXISTS
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

Line 267: iby_pmt_instr_uses_all to_uses,

263: AND EXISTS
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'

Line 333: iby_pmt_instr_uses_all from_inst,

329: FORALL i in 1..ext_payer_from_list.COUNT
330: UPDATE IBY_FNDCPT_TX_EXTENSIONS DUP
331: SET instr_assignment_id =
332: (SELECT to_instr.instrument_payment_use_id FROM
333: iby_pmt_instr_uses_all from_inst,
334: iby_pmt_instr_uses_all to_instr
335: WHERE from_inst.instrument_payment_use_id = dup.instr_assignment_id
336: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
337: AND to_instr.instrument_id = from_inst.instrument_id

Line 334: iby_pmt_instr_uses_all to_instr

330: UPDATE IBY_FNDCPT_TX_EXTENSIONS DUP
331: SET instr_assignment_id =
332: (SELECT to_instr.instrument_payment_use_id FROM
333: iby_pmt_instr_uses_all from_inst,
334: iby_pmt_instr_uses_all to_instr
335: WHERE from_inst.instrument_payment_use_id = dup.instr_assignment_id
336: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
337: AND to_instr.instrument_id = from_inst.instrument_id
338: AND to_instr.end_date > sysdate)

Line 360: iby_pmt_instr_uses_all from_inst,

356: )
357: AND EXISTS
358: (
359: SELECT to_instr.instrument_payment_use_id FROM
360: iby_pmt_instr_uses_all from_inst,
361: iby_pmt_instr_uses_all to_instr
362: WHERE from_inst.instrument_payment_use_id = dup.instr_assignment_id
363: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
364: AND to_instr.instrument_id = from_inst.instrument_id

Line 361: iby_pmt_instr_uses_all to_instr

357: AND EXISTS
358: (
359: SELECT to_instr.instrument_payment_use_id FROM
360: iby_pmt_instr_uses_all from_inst,
361: iby_pmt_instr_uses_all to_instr
362: WHERE from_inst.instrument_payment_use_id = dup.instr_assignment_id
363: AND to_instr.ext_pmt_party_id = ext_payer_to_list(i)
364: AND to_instr.instrument_id = from_inst.instrument_id
365: AND to_instr.end_date > sysdate

Line 376: iby_pmt_instr_uses_all from_uses,

372: FORALL i in 1..ext_payer_from_list.COUNT
373: UPDATE iby_fndcpt_tx_extensions dup
374: SET instr_assignment_id =
375: (SELECT to_uses.instrument_payment_use_id FROM
376: iby_pmt_instr_uses_all from_uses,
377: iby_pmt_instr_uses_all to_uses,
378: iby_creditcard from_cards,
379: iby_creditcard to_cards
380: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id

Line 377: iby_pmt_instr_uses_all to_uses,

373: UPDATE iby_fndcpt_tx_extensions dup
374: SET instr_assignment_id =
375: (SELECT to_uses.instrument_payment_use_id FROM
376: iby_pmt_instr_uses_all from_uses,
377: iby_pmt_instr_uses_all to_uses,
378: iby_creditcard from_cards,
379: iby_creditcard to_cards
380: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id
381: AND from_uses.instrument_id = from_cards.instrid

Line 408: iby_pmt_instr_uses_all from_uses,

404: AND EXISTS
405: (
406:
407: SELECT to_uses.instrument_payment_use_id FROM
408: iby_pmt_instr_uses_all from_uses,
409: iby_pmt_instr_uses_all to_uses,
410: iby_creditcard from_cards,
411: iby_creditcard to_cards
412: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id

Line 409: iby_pmt_instr_uses_all to_uses,

405: (
406:
407: SELECT to_uses.instrument_payment_use_id FROM
408: iby_pmt_instr_uses_all from_uses,
409: iby_pmt_instr_uses_all to_uses,
410: iby_creditcard from_cards,
411: iby_creditcard to_cards
412: WHERE from_uses.instrument_payment_use_id = dup.instr_assignment_id
413: AND from_uses.instrument_type = 'CREDITCARD'

Line 428: iby_pmt_instr_uses_all from_uses,

424: FORALL i in 1..ext_payer_from_list.COUNT
425: UPDATE iby_fndcpt_tx_extensions dup
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

Line 429: iby_pmt_instr_uses_all to_uses,

425: UPDATE iby_fndcpt_tx_extensions dup
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'

Line 461: iby_pmt_instr_uses_all from_uses,

457: AND EXISTS
458: (
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

Line 462: iby_pmt_instr_uses_all to_uses,

458: (
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'

Line 577: | Account merge procedure for the table, IBY_PMT_INSTR_USES_ALL

Line 591: UPDATE iby_pmt_instr_uses_all dup

587: inactivate the payment method for the target account, else transfer the same
588: */
589: iby_debug_pub.Add('Transferring the Instruments');
590: FORALL i in 1..ext_payer_from_list.COUNT
591: UPDATE iby_pmt_instr_uses_all dup
592: SET ext_pmt_party_id = ext_payer_to_list(i),
593: last_update_date = SYSDATE,
594: last_updated_by = arp_standard.profile.user_id,
595: last_update_login = arp_standard.profile.last_update_login

Line 604: FROM iby_pmt_instr_uses_all mto

600: AND payment_function = 'CUSTOMER_PAYMENT'
601: AND NOT EXISTS
602: (
603: SELECT instrument_id
604: FROM iby_pmt_instr_uses_all mto
605: WHERE mto.ext_pmt_party_id = ext_payer_to_list(i)
606: AND mto.instrument_id = dup.instrument_id
607: AND mto.payment_flow = dup.payment_flow
608: AND mto.payment_function = dup.payment_function

Line 617: UPDATE iby_pmt_instr_uses_all dup

613: exists a single instrument., in which case, we need to transfer
614: */
615: iby_debug_pub.Add('Transferring the Credit Cards');
616: FORALL i in 1..ext_payer_from_list.COUNT
617: UPDATE iby_pmt_instr_uses_all dup
618: SET ext_pmt_party_id = ext_payer_to_list(i),
619: last_update_date = SYSDATE,
620: last_updated_by = arp_standard.profile.user_id,
621: last_update_login = arp_standard.profile.last_update_login

Line 633: iby_pmt_instr_uses_all uses

629: (
630: SELECT 1 FROM
631: iby_creditcard from_card,
632: iby_creditcard to_card,
633: iby_pmt_instr_uses_all uses
634: WHERE from_card.instrid = dup.instrument_id
635: AND to_card.cc_number_hash1 = from_card.cc_number_hash1
636: AND to_card.cc_number_hash2 = from_card.cc_number_hash2
637: AND to_card.instrid = uses.instrument_id

Line 648: UPDATE iby_pmt_instr_uses_all dup

644: exists a single instrument., in which case, we need to transfer
645: */
646: iby_debug_pub.Add('Transferring the bank accounts');
647: FORALL i in 1..ext_payer_from_list.COUNT
648: UPDATE iby_pmt_instr_uses_all dup
649: SET ext_pmt_party_id = ext_payer_to_list(i),
650: last_update_date = SYSDATE,
651: last_updated_by = arp_standard.profile.user_id,
652: last_update_login = arp_standard.profile.last_update_login

Line 664: iby_pmt_instr_uses_all uses

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
668: AND to_account.ext_bank_account_id = uses.instrument_id

Line 677: UPDATE iby_pmt_instr_uses_all dup

673:
674:
675: iby_debug_pub.Add('Inactivating the Instruments for duplicat account');
676: FORALL i in 1..ext_payer_from_list.COUNT
677: UPDATE iby_pmt_instr_uses_all dup
678: SET end_date = SYSDATE,
679: last_update_date = SYSDATE,
680: last_updated_by = arp_standard.profile.user_id,
681: last_update_login = arp_standard.profile.last_update_login

Line 690: FROM iby_pmt_instr_uses_all mto

686: AND payment_function = 'CUSTOMER_PAYMENT'
687: AND EXISTS
688: (
689: SELECT instrument_id
690: FROM iby_pmt_instr_uses_all mto
691: WHERE mto.ext_pmt_party_id = ext_payer_to_list(i)
692: AND mto.instrument_id = dup.instrument_id
693: AND mto.payment_flow = dup.payment_flow
694: AND mto.payment_function = dup.payment_function

Line 700: UPDATE iby_pmt_instr_uses_all dup

696: );
697:
698: iby_debug_pub.Add('Inactivating the Credit cards for dupliacte account');
699: FORALL i in 1..ext_payer_from_list.COUNT
700: UPDATE iby_pmt_instr_uses_all dup
701: SET end_date = SYSDATE,
702: last_update_date = SYSDATE,
703: last_updated_by = arp_standard.profile.user_id,
704: last_update_login = arp_standard.profile.last_update_login

Line 716: iby_pmt_instr_uses_all uses

712: (
713: SELECT 1 FROM
714: iby_creditcard from_card,
715: iby_creditcard to_card,
716: iby_pmt_instr_uses_all uses
717: WHERE from_card.instrid = dup.instrument_id
718: AND to_card.cc_number_hash1 = from_card.cc_number_hash1
719: AND to_card.cc_number_hash2 = from_card.cc_number_hash2
720: AND to_card.instrid = uses.instrument_id

Line 726: UPDATE iby_pmt_instr_uses_all dup

722: );
723:
724: iby_debug_pub.Add('Inactivating the Bank Accounts for dupliacte account');
725: FORALL i in 1..ext_payer_from_list.COUNT
726: UPDATE iby_pmt_instr_uses_all dup
727: SET end_date = SYSDATE,
728: last_update_date = SYSDATE,
729: last_updated_by = arp_standard.profile.user_id,
730: last_update_login = arp_standard.profile.last_update_login

Line 742: iby_pmt_instr_uses_all uses

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
746: AND to_account.ext_bank_account_id = uses.instrument_id