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_CREDITCARD

Line 205: iby_creditcard from_cards,

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
209: AND to_cards.cc_number_hash1 = from_cards.cc_number_hash1

Line 206: iby_creditcard to_cards

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
209: AND to_cards.cc_number_hash1 = from_cards.cc_number_hash1
210: AND to_cards.cc_number_hash2 = from_cards.cc_number_hash2

Line 224: iby_creditcard from_cards,

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'
228: AND from_uses.instrument_id = from_cards.instrid

Line 225: iby_creditcard to_cards

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'
228: AND from_uses.instrument_id = from_cards.instrid
229: AND to_cards.cc_number_hash1 = from_cards.cc_number_hash1

Line 378: iby_creditcard from_cards,

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
382: AND to_cards.cc_number_hash1 = from_cards.cc_number_hash1

Line 379: iby_creditcard to_cards

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
382: AND to_cards.cc_number_hash1 = from_cards.cc_number_hash1
383: AND to_cards.cc_number_hash2 = from_cards.cc_number_hash2

Line 410: iby_creditcard from_cards,

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'
414: AND from_uses.instrument_id = from_cards.instrid

Line 411: iby_creditcard to_cards

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'
414: AND from_uses.instrument_id = from_cards.instrid
415: AND to_cards.cc_number_hash1 = from_cards.cc_number_hash1

Line 631: iby_creditcard from_card,

627: AND payment_function = 'CUSTOMER_PAYMENT'
628: AND NOT EXISTS
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

Line 632: iby_creditcard to_card,

628: AND NOT EXISTS
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

Line 714: iby_creditcard from_card,

710: AND dup.instrument_type = 'CREDITCARD'
711: AND EXISTS
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

Line 715: iby_creditcard to_card,

711: AND EXISTS
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