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.OEP_CMERGE_OEORD dependencies on RA_CUSTOMER_MERGES

Line 18: from ra_customer_merges m

14: CURSOR c1 is
15: select header_id
16: from so_headers
17: where ship_to_site_use_id in (select m.duplicate_site_id
18: from ra_customer_merges m
19: where m.process_flag = 'N'
20: and m.request_id = req_id
21: and m.set_number = set_num)
22: for update nowait;

Line 28: from ra_customer_merges m

24: CURSOR c2 is
25: select header_id
26: from so_headers
27: where invoice_to_site_use_id in (select m.duplicate_site_id
28: from ra_customer_merges m
29: where m.process_flag = 'N'
30: and m.request_id = req_id
31: and m.set_number = set_num)
32: for update nowait;

Line 38: from ra_customer_merges m

34: CURSOR c3 is
35: select header_id
36: from so_headers
37: where customer_id in (select m.duplicate_id
38: from ra_customer_merges m
39: where m.process_flag = 'N'
40: and m.request_id = req_id
41: and m.set_number = set_num)
42: for update nowait;

Line 76: from ra_customer_merges m

72: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
73:
74: UPDATE SO_HEADERS a
75: set (ship_to_site_use_id) = (select distinct m.customer_site_id
76: from ra_customer_merges m
77: where a.ship_to_site_use_id =
78: m.duplicate_site_id
79: and m.request_id = req_id
80: and m.process_flag = 'N'

Line 90: from ra_customer_merges m

86: program_application_id =arp_standard.profile.program_application_id,
87: program_id = arp_standard.profile.program_id,
88: program_update_date = sysdate
89: where ship_to_site_use_id in (select m.duplicate_site_id
90: from ra_customer_merges m
91: where m.process_flag = 'N'
92: and m.request_id = req_id
93: and m.set_number = set_num);
94:

Line 105: from ra_customer_merges m

101: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
102:
103: UPDATE SO_HEADERS a
104: set (invoice_to_site_use_id) = (select distinct m.customer_site_id
105: from ra_customer_merges m
106: where a.invoice_to_site_use_id =
107: m.duplicate_site_id
108: and m.request_id = req_id
109: and m.process_flag = 'N'

Line 119: from ra_customer_merges m

115: program_application_id =arp_standard.profile.program_application_id,
116: program_id = arp_standard.profile.program_id,
117: program_update_date = sysdate
118: where invoice_to_site_use_id in (select m.duplicate_site_id
119: from ra_customer_merges m
120: where m.process_flag = 'N'
121: and m.request_id = req_id
122: and m.set_number = set_num);
123:

Line 135: from ra_customer_merges m

131: arp_message.set_token( 'TABLE_NAME', 'SO_HEADERS', FALSE );
132:
133: UPDATE SO_HEADERS a
134: set customer_id = (select distinct m.customer_id
135: from ra_customer_merges m
136: where a.customer_id =
137: m.duplicate_id
138: and m.process_flag = 'N'
139: and m.request_id = req_id

Line 149: from ra_customer_merges m

145: program_application_id =arp_standard.profile.program_application_id,
146: program_id = arp_standard.profile.program_id,
147: program_update_date = sysdate
148: where customer_id in (select m.duplicate_id
149: from ra_customer_merges m
150: where m.process_flag = 'N'
151: and m.request_id = req_id
152: and m.set_number = set_num);
153:

Line 179: from ra_customer_merges m

175: CURSOR c1 is
176: select line_id
177: from so_lines
178: where ship_to_site_use_id in (select m.duplicate_site_id
179: from ra_customer_merges m
180: where m.process_flag = 'N'
181: and m.request_id = req_id
182: and m.set_number = set_num)
183: for update nowait;

Line 211: from ra_customer_merges m

207: arp_message.set_token( 'TABLE_NAME', 'SO_LINES', FALSE );
208:
209: UPDATE SO_LINES a
210: set (ship_to_site_use_id) = (select distinct m.customer_site_id
211: from ra_customer_merges m
212: where a.ship_to_site_use_id =
213: m.duplicate_site_id
214: and m.request_id = req_id
215: and m.process_flag = 'N'

Line 225: from ra_customer_merges m

221: program_application_id =arp_standard.profile.program_application_id,
222: program_id = arp_standard.profile.program_id,
223: program_update_date = sysdate
224: where ship_to_site_use_id in (select m.duplicate_site_id
225: from ra_customer_merges m
226: where m.process_flag = 'N'
227: and m.request_id = req_id
228: and m.set_number = set_num);
229:

Line 253: from ra_customer_merges m

249: CURSOR c1 is
250: select line_service_detail_id
251: from so_line_service_details
252: where installation_site_use_id in (select m.duplicate_site_id
253: from ra_customer_merges m
254: where m.process_flag = 'N'
255: and m.request_id = req_id
256: and m.set_number = set_num)
257: for update nowait;

Line 285: from ra_customer_merges m

281: arp_message.set_token( 'TABLE_NAME', 'SO_LINE_SERVICE_DETAILS', FALSE );
282:
283: UPDATE SO_LINE_SERVICE_DETAILS a
284: set (installation_site_use_id) = (select distinct m.customer_site_id
285: from ra_customer_merges m
286: where a.installation_site_use_id =
287: m.duplicate_site_id
288: and m.request_id = req_id
289: and m.process_flag = 'N'

Line 295: from ra_customer_merges m

291: last_update_date = sysdate,
292: last_updated_by = arp_standard.profile.user_id,
293: last_update_login = arp_standard.profile.last_update_login
294: where installation_site_use_id in (select m.duplicate_site_id
295: from ra_customer_merges m
296: where m.process_flag = 'N'
297: and m.request_id = req_id
298: and m.set_number = set_num);
299:

Line 324: from ra_customer_merges m

320: CURSOR c1 is
321: select order_approval_id
322: from so_order_approvals
323: where customer_id in (select m.duplicate_id
324: from ra_customer_merges m
325: where m.process_flag = 'N'
326: and m.request_id = req_id
327: and m.set_number = set_num)
328: for update nowait;

Line 355: from ra_customer_merges m

351: arp_message.set_token( 'TABLE_NAME', 'SO_ORDER_APPROVALS', FALSE );
352:
353: UPDATE SO_ORDER_APPROVALS a
354: set customer_id = (select distinct m.customer_id
355: from ra_customer_merges m
356: where a.customer_id =
357: m.duplicate_id
358: and m.process_flag = 'N'
359: and m.request_id = req_id

Line 365: from ra_customer_merges m

361: last_update_date = sysdate,
362: last_updated_by = arp_standard.profile.user_id,
363: last_update_login = arp_standard.profile.last_update_login
364: where customer_id in (select m.duplicate_id
365: from ra_customer_merges m
366: where m.process_flag = 'N'
367: and m.request_id = req_id
368: and m.set_number = set_num);
369:

Line 394: from ra_customer_merges m

390: CURSOR c1 is
391: select standard_value_rule_id
392: from so_standard_value_rules
393: where attribute_value in (select to_char(m.duplicate_site_id)
394: from ra_customer_merges m
395: where m.process_flag = 'N'
396: and m.request_id = req_id
397: and m.set_number = set_num)
398: and standard_value_source_id = 1

Line 406: from ra_customer_merges m

402: CURSOR c2 is
403: select standard_value_rule_id
404: from so_standard_value_rules
405: where attribute_value in (select to_char(m.duplicate_site_id)
406: from ra_customer_merges m
407: where m.process_flag = 'N'
408: and m.request_id = req_id
409: and m.set_number = set_num)
410: and standard_value_source_id = 1

Line 449: from ra_customer_merges m

445:
446:
447: UPDATE SO_STANDARD_VALUE_RULES a
448: set attribute_value = (select distinct to_char(m.customer_site_id)
449: from ra_customer_merges m
450: where a.attribute_value =
451: to_char(m.duplicate_site_id)
452: and m.request_id = req_id
453: and m.process_flag = 'N'

Line 459: from ra_customer_merges m

455: last_update_date = sysdate,
456: last_updated_by = arp_standard.profile.user_id,
457: last_update_login = arp_standard.profile.last_update_login
458: where attribute_value in (select to_char(m.duplicate_site_id)
459: from ra_customer_merges m
460: where m.process_flag = 'N'
461: and m.request_id = req_id
462: and m.set_number = set_num)
463: and standard_value_source_id = 1

Line 480: from ra_customer_merges m

476:
477:
478: UPDATE SO_STANDARD_VALUE_RULES a
479: set attribute_value = (select distinct to_char(m.customer_site_id)
480: from ra_customer_merges m
481: where a.attribute_value =
482: to_char(m.duplicate_site_id)
483: and m.request_id = req_id
484: and m.process_flag = 'N'

Line 490: from ra_customer_merges m

486: last_update_date = sysdate,
487: last_updated_by = arp_standard.profile.user_id,
488: last_update_login = arp_standard.profile.last_update_login
489: where attribute_value in (select to_char(m.duplicate_site_id)
490: from ra_customer_merges m
491: where m.process_flag = 'N'
492: and m.request_id = req_id
493: and m.set_number = set_num)
494: and standard_value_source_id = 1