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_TRXN_SUMMARIES_ALL

Line 44: iby_trxn_summaries_all.trxnmid%TYPE

40: INDEX BY BINARY_INTEGER;
41: merge_header_id_list merge_header_id_list_type;
42:
43: TYPE trxnmid_list_type IS TABLE OF
44: iby_trxn_summaries_all.trxnmid%TYPE
45: INDEX BY BINARY_INTEGER;
46: primary_key_id_list trxnmid_list_type;
47:
48: TYPE cust_account_id_list_type IS TABLE OF

Line 49: iby_trxn_summaries_all.cust_account_id%TYPE

45: INDEX BY BINARY_INTEGER;
46: primary_key_id_list trxnmid_list_type;
47:
48: TYPE cust_account_id_list_type IS TABLE OF
49: iby_trxn_summaries_all.cust_account_id%TYPE
50: INDEX BY BINARY_INTEGER;
51: num_col1_orig_list cust_account_id_list_type;
52: num_col1_new_list cust_account_id_list_type;
53:

Line 55: iby_trxn_summaries_all.acct_site_id%TYPE

51: num_col1_orig_list cust_account_id_list_type;
52: num_col1_new_list cust_account_id_list_type;
53:
54: TYPE acct_site_id_list_type IS TABLE OF
55: iby_trxn_summaries_all.acct_site_id%TYPE
56: INDEX BY BINARY_INTEGER;
57: num_col2_orig_list acct_site_id_list_type;
58: num_col2_new_list acct_site_id_list_type;
59:

Line 61: iby_trxn_summaries_all.acct_site_use_id%TYPE

57: num_col2_orig_list acct_site_id_list_type;
58: num_col2_new_list acct_site_id_list_type;
59:
60: TYPE acct_site_use_id_list_type IS TABLE OF
61: iby_trxn_summaries_all.acct_site_use_id%TYPE
62: INDEX BY BINARY_INTEGER;
63: num_col3_orig_list acct_site_use_id_list_type;
64: num_col3_new_list acct_site_use_id_list_type;
65:

Line 76: FROM iby_trxn_summaries_all yt, ra_customer_merges m

72: ,trxnmid
73: ,cust_account_id
74: ,acct_site_id
75: ,acct_site_use_id
76: FROM iby_trxn_summaries_all yt, ra_customer_merges m
77: WHERE (
78: yt.cust_account_id = m.duplicate_id
79: OR yt.acct_site_id = m.duplicate_address_id
80: OR yt.acct_site_use_id = m.duplicate_site_id

Line 91: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBY_TRXN_SUMMARIES_ALL',FALSE);

87: IF process_mode='LOCK' THEN
88: NULL;
89: ELSE
90: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
91: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IBY_TRXN_SUMMARIES_ALL',FALSE);
92: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
93: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
94:
95: open merged_records;

Line 142: 'IBY_TRXN_SUMMARIES_ALL',

138: last_update_login,
139: last_update_date,
140: last_updated_by
141: ) VALUES ( hz_customer_merge_log_s.nextval,
142: 'IBY_TRXN_SUMMARIES_ALL',
143: merge_header_id_list(i),
144: primary_key_id_list(i),
145: num_col1_orig_list(i),
146: num_col1_new_list(i),

Line 168: UPDATE iby_trxn_summaries_all DUP

164: Check if the same instrument id exists for the payer of the
165: target account.If exists, update the record with the new Payment Instrument Use Id
166: */
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

Line 200: UPDATE iby_trxn_summaries_all dup

196: payers are having creditcards with similar hashcode1 and hashcode2
197: If exists, update the record with the new Payment Instrument Use Id
198: */
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,

Line 241: UPDATE iby_trxn_summaries_all dup

237: payers are having same hash values.
238: If exists, update the record with the new Payment Instrument Use Id
239: */
240: FORALL i in 1..ext_payer_from_list.COUNT
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,

Line 283: UPDATE iby_trxn_summaries_all yt SET

279: /*
280: Update the Cust Account and Site Use with the new values
281: */
282: FORALL i in 1..merge_header_id_list.COUNT
283: UPDATE iby_trxn_summaries_all yt SET
284: cust_account_id=num_col1_new_list(i)
285: ,acct_site_id=num_col2_new_list(i)
286: ,acct_site_use_id=num_col3_new_list(i)
287: , last_update_date=SYSDATE

Line 345: FROM iby_trxn_summaries_all s

341: AND ext_payer_to_list(i) IS NOT NULL
342: AND instr_assignment_id IS NOT NULL
343: AND ( EXISTS (
344: SELECT 1
345: FROM iby_trxn_summaries_all s
346: ,iby_fndcpt_tx_operations o
347: WHERE o.trxn_extension_id = dup.trxn_extension_id
348: AND s.transactionid = o.transactionid
349: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')

Line 392: FROM iby_trxn_summaries_all s

388: AND ext_payer_to_list(i) IS NOT NULL
389: AND instr_assignment_id IS NOT NULL
390: AND ( EXISTS (
391: SELECT 1
392: FROM iby_trxn_summaries_all s
393: ,iby_fndcpt_tx_operations o
394: WHERE o.trxn_extension_id = dup.trxn_extension_id
395: AND s.transactionid = o.transactionid
396: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')

Line 445: FROM iby_trxn_summaries_all s

441: AND ext_payer_to_list(i) IS NOT NULL
442: AND instr_assignment_id IS NOT NULL
443: AND ( EXISTS (
444: SELECT 1
445: FROM iby_trxn_summaries_all s
446: ,iby_fndcpt_tx_operations o
447: WHERE o.trxn_extension_id = dup.trxn_extension_id
448: AND s.transactionid = o.transactionid
449: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')

Line 485: FROM iby_trxn_summaries_all s

481: AND ext_payer_to_list(i) IS NOT NULL
482: AND
483: ( EXISTS (
484: SELECT 1
485: FROM iby_trxn_summaries_all s
486: ,iby_fndcpt_tx_operations o
487: WHERE o.trxn_extension_id = dup.trxn_extension_id
488: AND s.transactionid = o.transactionid
489: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')