[Home] [Help]
13: CURSOR c1 is
14: select picking_rule
15: from so_picking_rules
16: where site_use_id in (select m.duplicate_site_id
17: from ra_customer_merges m
18: where m.process_flag = 'N'
19: and m.request_id = req_id
20: and m.set_number = set_num)
21: for update nowait;
23: CURSOR c2 is
24: select picking_rule
25: from so_picking_rules
26: where customer_id in (select m.duplicate_id
27: from ra_customer_merges m
28: where m.process_flag = 'N'
29: and m.request_id = req_id
30: and m.set_number = set_num)
31: for update nowait;
58: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );
59:
60: UPDATE SO_PICKING_RULES a
61: set (site_use_id) = (select distinct m.customer_site_id
62: from ra_customer_merges m
63: where a.site_use_id =
64: m.duplicate_site_id
65: and m.request_id = req_id
66: and m.process_flag = 'N'
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
75: and m.set_number = set_num);
76:
84: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );
85:
86: UPDATE SO_PICKING_RULES a
87: set customer_id = (select distinct m.customer_id
88: from ra_customer_merges m
89: where a.customer_id =
90: m.duplicate_id
91: and m.process_flag = 'N'
92: and m.request_id = req_id
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
101: and m.set_number = set_num);
102:
123: CURSOR c1 is
124: select batch_id
125: from so_picking_batches
126: where site_use_id in (select m.duplicate_site_id
127: from ra_customer_merges m
128: where m.process_flag = 'N'
129: and m.request_id = req_id
130: and m.set_number = set_num)
131: for update nowait;
133: CURSOR c2 is
134: select batch_id
135: from so_picking_batches
136: where customer_id in (select m.duplicate_id
137: from ra_customer_merges m
138: where m.process_flag = 'N'
139: and m.request_id = req_id
140: and m.set_number = set_num)
141: for update nowait;
168: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
169:
170: UPDATE SO_PICKING_BATCHES a
171: set (site_use_id) = (select distinct m.customer_site_id
172: from ra_customer_merges m
173: where a.site_use_id =
174: m.duplicate_site_id
175: and m.request_id = req_id
176: and m.process_flag = 'N'
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
185: and m.set_number = set_num);
186:
194: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_BATCHES', FALSE );
195:
196: UPDATE SO_PICKING_BATCHES a
197: set customer_id = (select distinct m.customer_id
198: from ra_customer_merges m
199: where a.customer_id =
200: m.duplicate_id
201: and m.process_flag = 'N'
202: and m.request_id = req_id
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
211: and m.set_number = set_num);
212:
234: CURSOR c1 is
235: select picking_header_id
236: from so_picking_headers
237: where ship_to_site_use_id in (select m.duplicate_site_id
238: from ra_customer_merges m
239: where m.process_flag = 'N'
240: and m.request_id = req_id
241: and m.set_number = set_num)
242: for update nowait;
266: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_HEADERS', FALSE );
267:
268: UPDATE SO_PICKING_HEADERS a
269: set (ship_to_site_use_id) = (select distinct m.customer_site_id
270: from ra_customer_merges m
271: where a.ship_to_site_use_id =
272: m.duplicate_site_id
273: and m.request_id = req_id
274: and m.process_flag = 'N'
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
283: and m.set_number = set_num);
284:
305: CURSOR c1 is
306: select picking_line_id
307: from so_picking_lines
308: where ship_to_site_use_id in (select m.duplicate_site_id
309: from ra_customer_merges m
310: where m.process_flag = 'N'
311: and m.request_id = req_id
312: and m.set_number = set_num)
313: for update nowait;
337: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );
338:
339: UPDATE SO_PICKING_LINES a
340: set (ship_to_site_use_id) = (select distinct m.customer_site_id
341: from ra_customer_merges m
342: where a.ship_to_site_use_id =
343: m.duplicate_site_id
344: and m.request_id = req_id
345: and m.process_flag = 'N'
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
354: and m.set_number = set_num);
355: