DBA Data[Home] [Help]

APPS.OEP_CMERGE_OEDIS dependencies on STANDARD

Line 97: last_updated_by = arp_standard.profile.user_id,

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

Line 98: last_update_login = arp_standard.profile.last_update_login

94: and m.process_flag = 'N'
95: and m.set_number = set_num),
96: last_update_date = sysdate,
97: last_updated_by = arp_standard.profile.user_id,
98: last_update_login = arp_standard.profile.last_update_login
99: where entity_value in (select to_char(m.duplicate_site_id)
100: from ra_customer_merges m
101: where m.process_flag = 'N'
102: and m.request_id = req_id

Line 125: last_updated_by = arp_standard.profile.user_id,

121: and m.request_id = req_id
122: and m.process_flag = 'N'
123: and m.set_number = set_num),
124: last_update_date = sysdate,
125: last_updated_by = arp_standard.profile.user_id,
126: last_update_login = arp_standard.profile.last_update_login
127: where entity_value in (select to_char(m.duplicate_site_id)
128: from ra_customer_merges m
129: where m.process_flag = 'N'

Line 126: last_update_login = arp_standard.profile.last_update_login

122: and m.process_flag = 'N'
123: and m.set_number = set_num),
124: last_update_date = sysdate,
125: last_updated_by = arp_standard.profile.user_id,
126: last_update_login = arp_standard.profile.last_update_login
127: where entity_value in (select to_char(m.duplicate_site_id)
128: from ra_customer_merges m
129: where m.process_flag = 'N'
130: and m.request_id = req_id

Line 153: last_updated_by = arp_standard.profile.user_id,

149: and m.request_id = req_id
150: and m.process_flag = 'N'
151: and m.set_number = set_num),
152: last_update_date = sysdate,
153: last_updated_by = arp_standard.profile.user_id,
154: last_update_login = arp_standard.profile.last_update_login
155: where entity_value in (select to_char(m.duplicate_site_id)
156: from ra_customer_merges m
157: where m.process_flag = 'N'

Line 154: last_update_login = arp_standard.profile.last_update_login

150: and m.process_flag = 'N'
151: and m.set_number = set_num),
152: last_update_date = sysdate,
153: last_updated_by = arp_standard.profile.user_id,
154: last_update_login = arp_standard.profile.last_update_login
155: where entity_value in (select to_char(m.duplicate_site_id)
156: from ra_customer_merges m
157: where m.process_flag = 'N'
158: and m.request_id = req_id

Line 181: last_updated_by = arp_standard.profile.user_id,

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

Line 182: last_update_login = arp_standard.profile.last_update_login

178: and m.request_id = req_id
179: and m.set_number = set_num),
180: last_update_date = sysdate,
181: last_updated_by = arp_standard.profile.user_id,
182: last_update_login = arp_standard.profile.last_update_login
183: where entity_value in (select to_char(m.duplicate_id)
184: from ra_customer_merges m
185: where m.process_flag = 'N'
186: and m.request_id = req_id

Line 272: last_updated_by = arp_standard.profile.user_id,

268: and m.request_id = req_id
269: and m.process_flag = 'N'
270: and m.set_number = set_num),
271: last_update_date = sysdate,
272: last_updated_by = arp_standard.profile.user_id,
273: last_update_login = arp_standard.profile.last_update_login
274: where site_use_id in (select m.duplicate_site_id
275: from ra_customer_merges m
276: where m.process_flag = 'N'

Line 273: last_update_login = arp_standard.profile.last_update_login

269: and m.process_flag = 'N'
270: and m.set_number = set_num),
271: last_update_date = sysdate,
272: last_updated_by = arp_standard.profile.user_id,
273: last_update_login = arp_standard.profile.last_update_login
274: where site_use_id in (select m.duplicate_site_id
275: from ra_customer_merges m
276: where m.process_flag = 'N'
277: and m.request_id = req_id

Line 298: last_updated_by = arp_standard.profile.user_id,

294: and m.process_flag = 'N'
295: and m.request_id = req_id
296: and m.set_number = set_num),
297: last_update_date = sysdate,
298: last_updated_by = arp_standard.profile.user_id,
299: last_update_login = arp_standard.profile.last_update_login
300: where customer_id in (select m.duplicate_id
301: from ra_customer_merges m
302: where m.process_flag = 'N'

Line 299: last_update_login = arp_standard.profile.last_update_login

295: and m.request_id = req_id
296: and m.set_number = set_num),
297: last_update_date = sysdate,
298: last_updated_by = arp_standard.profile.user_id,
299: last_update_login = arp_standard.profile.last_update_login
300: where customer_id in (select m.duplicate_id
301: from ra_customer_merges m
302: where m.process_flag = 'N'
303: and m.request_id = req_id