DBA Data[Home] [Help]

APPS.OEP_CMERGE_OEPIC dependencies on STANDARD

Line 69: last_updated_by = arp_standard.profile.user_id,

65: and m.request_id = req_id
66: and m.process_flag = 'N'
67: and m.set_number = set_num),
68: last_update_date = sysdate,
69: last_updated_by = arp_standard.profile.user_id,
70: last_update_login = arp_standard.profile.last_update_login
71: where site_use_id in (select m.duplicate_site_id
72: from ra_customer_merges m
73: where m.process_flag = 'N'

Line 70: last_update_login = arp_standard.profile.last_update_login

66: and m.process_flag = 'N'
67: and m.set_number = set_num),
68: last_update_date = sysdate,
69: last_updated_by = arp_standard.profile.user_id,
70: last_update_login = arp_standard.profile.last_update_login
71: where site_use_id in (select m.duplicate_site_id
72: from ra_customer_merges m
73: where m.process_flag = 'N'
74: and m.request_id = req_id

Line 95: last_updated_by = arp_standard.profile.user_id,

91: and m.process_flag = 'N'
92: and m.request_id = req_id
93: and m.set_number = set_num),
94: last_update_date = sysdate,
95: last_updated_by = arp_standard.profile.user_id,
96: last_update_login = arp_standard.profile.last_update_login
97: where customer_id in (select m.duplicate_id
98: from ra_customer_merges m
99: where m.process_flag = 'N'

Line 96: last_update_login = arp_standard.profile.last_update_login

92: and m.request_id = req_id
93: and m.set_number = set_num),
94: last_update_date = sysdate,
95: last_updated_by = arp_standard.profile.user_id,
96: last_update_login = arp_standard.profile.last_update_login
97: where customer_id in (select m.duplicate_id
98: from ra_customer_merges m
99: where m.process_flag = 'N'
100: and m.request_id = req_id

Line 179: last_updated_by = arp_standard.profile.user_id,

175: and m.request_id = req_id
176: and m.process_flag = 'N'
177: and m.set_number = set_num),
178: last_update_date = sysdate,
179: last_updated_by = arp_standard.profile.user_id,
180: last_update_login = arp_standard.profile.last_update_login
181: where site_use_id in (select m.duplicate_site_id
182: from ra_customer_merges m
183: where m.process_flag = 'N'

Line 180: last_update_login = arp_standard.profile.last_update_login

176: and m.process_flag = 'N'
177: and m.set_number = set_num),
178: last_update_date = sysdate,
179: last_updated_by = arp_standard.profile.user_id,
180: last_update_login = arp_standard.profile.last_update_login
181: where site_use_id in (select m.duplicate_site_id
182: from ra_customer_merges m
183: where m.process_flag = 'N'
184: and m.request_id = req_id

Line 205: last_updated_by = arp_standard.profile.user_id,

201: and m.process_flag = 'N'
202: and m.request_id = req_id
203: and m.set_number = set_num),
204: last_update_date = sysdate,
205: last_updated_by = arp_standard.profile.user_id,
206: last_update_login = arp_standard.profile.last_update_login
207: where customer_id in (select m.duplicate_id
208: from ra_customer_merges m
209: where m.process_flag = 'N'

Line 206: last_update_login = arp_standard.profile.last_update_login

202: and m.request_id = req_id
203: and m.set_number = set_num),
204: last_update_date = sysdate,
205: last_updated_by = arp_standard.profile.user_id,
206: last_update_login = arp_standard.profile.last_update_login
207: where customer_id in (select m.duplicate_id
208: from ra_customer_merges m
209: where m.process_flag = 'N'
210: and m.request_id = req_id

Line 277: last_updated_by = arp_standard.profile.user_id,

273: and m.request_id = req_id
274: and m.process_flag = 'N'
275: and m.set_number = set_num),
276: last_update_date = sysdate,
277: last_updated_by = arp_standard.profile.user_id,
278: last_update_login = arp_standard.profile.last_update_login
279: where ship_to_site_use_id in (select m.duplicate_site_id
280: from ra_customer_merges m
281: where m.process_flag = 'N'

Line 278: last_update_login = arp_standard.profile.last_update_login

274: and m.process_flag = 'N'
275: and m.set_number = set_num),
276: last_update_date = sysdate,
277: last_updated_by = arp_standard.profile.user_id,
278: last_update_login = arp_standard.profile.last_update_login
279: where ship_to_site_use_id in (select m.duplicate_site_id
280: from ra_customer_merges m
281: where m.process_flag = 'N'
282: and m.request_id = req_id

Line 348: last_updated_by = arp_standard.profile.user_id,

344: and m.request_id = req_id
345: and m.process_flag = 'N'
346: and m.set_number = set_num),
347: last_update_date = sysdate,
348: last_updated_by = arp_standard.profile.user_id,
349: last_update_login = arp_standard.profile.last_update_login
350: where ship_to_site_use_id in (select m.duplicate_site_id
351: from ra_customer_merges m
352: where m.process_flag = 'N'

Line 349: last_update_login = arp_standard.profile.last_update_login

345: and m.process_flag = 'N'
346: and m.set_number = set_num),
347: last_update_date = sysdate,
348: last_updated_by = arp_standard.profile.user_id,
349: last_update_login = arp_standard.profile.last_update_login
350: where ship_to_site_use_id in (select m.duplicate_site_id
351: from ra_customer_merges m
352: where m.process_flag = 'N'
353: and m.request_id = req_id