APPS.OEP_CMERGE_OEPIC dependencies on SO_PICKING_RULES

Line 15: from so_picking_rules

11: PROCEDURE oe_pr (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
12:
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

Line 25: from so_picking_rules

21: for update nowait;
22:
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

Line 38: | SO_PICKING_RULES |

34:
35: arp_message.set_line( 'OEP_CMERGE_OEPIC.OE_PR()+' );
36:
37: /*-----------------------------+
38: | SO_PICKING_RULES |
39: +-----------------------------*/
40: /* both customer and site level */
41:
42: IF( process_mode = 'LOCK' ) THEN

Line 45: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );

41:
42: IF( process_mode = 'LOCK' ) THEN
43:
44: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
45: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );
46:
47: open c1;
48: close c1;
49:

Line 58: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );

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

Line 60: UPDATE SO_PICKING_RULES a

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

Line 84: arp_message.set_token( 'TABLE_NAME', 'SO_PICKING_RULES', FALSE );

80: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
81:
82: /* customer level update */
83: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 86: UPDATE SO_PICKING_RULES a

82: /* customer level update */
83: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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