APPS.OEP_CMERGE_OEPIC dependencies on SO_PICKING_LINES

Line 307: from so_picking_lines

303: PROCEDURE oe_pl (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
304:
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

Line 320: | SO_PICKING_LINES |

316:
317: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PL()+' );
318:
319: /*-----------------------------+
320: | SO_PICKING_LINES |
321: +-----------------------------*/
322: /* both customer and site level */
323:
324: IF( process_mode = 'LOCK' ) THEN

Line 327: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );

323:
324: IF( process_mode = 'LOCK' ) THEN
325:
326: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
327: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );
328:
329: open c1;
330: close c1;
331:

Line 337: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_LINES', FALSE );

333:
334:
335: /* site level update */
336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 339: UPDATE SO_PICKING_LINES a

335: /* site level update */
336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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