APPS.OEP_CMERGE_OEORD dependencies on SO_LINES

Line 177: from so_lines

173: PROCEDURE oe_sl (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
174:
175: CURSOR c1 is
176: select line_id
177: from so_lines
178: where ship_to_site_use_id in (select m.duplicate_site_id
179: from ra_customer_merges m
180: where m.process_flag = 'N'
181: and m.request_id = req_id

Line 190: | SO_LINES |

186:
187: arp_message.set_line( 'OEP_CMERGE_OEORD.OE_SL()+' );
188:
189: /*-----------------------------+
190: | SO_LINES |
191: +-----------------------------*/
192: /* both customer and site level */
193:
194: IF( process_mode = 'LOCK' ) THEN

Line 197: arp_message.set_token( 'TABLE_NAME', 'SO_LINES', FALSE );

193:
194: IF( process_mode = 'LOCK' ) THEN
195:
196: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
197: arp_message.set_token( 'TABLE_NAME', 'SO_LINES', FALSE );
198:
199: open c1;
200: close c1;
201:

Line 207: arp_message.set_token( 'TABLE_NAME', 'SO_LINES', FALSE );

203:
204:
205: /* site level update */
206: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
207: arp_message.set_token( 'TABLE_NAME', 'SO_LINES', FALSE );
208:
209: UPDATE SO_LINES a
210: set (ship_to_site_use_id) = (select distinct m.customer_site_id
211: from ra_customer_merges m

Line 209: UPDATE SO_LINES a

205: /* site level update */
206: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
207: arp_message.set_token( 'TABLE_NAME', 'SO_LINES', FALSE );
208:
209: UPDATE SO_LINES a
210: set (ship_to_site_use_id) = (select distinct m.customer_site_id
211: from ra_customer_merges m
212: where a.ship_to_site_use_id =
213: m.duplicate_site_id