eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OEP_CMERGE_OEDIS dependencies on SO_DISCOUNT_CUSTOMERS

Line 218: from so_discount_customers

214: PROCEDURE oe_dc (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
215:
216: CURSOR c1 is
217: select discount_customer_id
218: from so_discount_customers
219: where site_use_id in (select m.duplicate_site_id
220: from ra_customer_merges m
221: where m.process_flag = 'N'
222: and m.request_id = req_id

Line 228: from so_discount_customers

224: for update nowait;
225:
226: CURSOR c2 is
227: select discount_customer_id
228: from so_discount_customers
229: where customer_id in (select m.duplicate_id
230: from ra_customer_merges m
231: where m.process_flag = 'N'
232: and m.request_id = req_id

Line 241: | SO_DISCOUNT_CUSTOMERS |

237:
238: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DC()+' );
239:
240: /*-----------------------------+
241: | SO_DISCOUNT_CUSTOMERS |
242: +-----------------------------*/
243: /* both customer and site level */
244:
245: IF( process_mode = 'LOCK' ) THEN

Line 248: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );

244:
245: IF( process_mode = 'LOCK' ) THEN
246:
247: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
248: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
249:
250: open c1;
251: close c1;
252:

Line 261: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );

257:
258:
259: /* site level update */
260: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
261: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
262:
263: UPDATE SO_DISCOUNT_CUSTOMERS a
264: set (site_use_id) = (select distinct m.customer_site_id
265: from ra_customer_merges m

Line 263: UPDATE SO_DISCOUNT_CUSTOMERS a

259: /* site level update */
260: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
261: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
262:
263: UPDATE SO_DISCOUNT_CUSTOMERS a
264: set (site_use_id) = (select distinct m.customer_site_id
265: from ra_customer_merges m
266: where a.site_use_id =
267: m.duplicate_site_id

Line 287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );

283: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
284:
285: /* customer level update */
286: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
288:
289: UPDATE SO_DISCOUNT_CUSTOMERS a
290: set customer_id = (select distinct m.customer_id
291: from ra_customer_merges m

Line 289: UPDATE SO_DISCOUNT_CUSTOMERS a

285: /* customer level update */
286: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
288:
289: UPDATE SO_DISCOUNT_CUSTOMERS a
290: set customer_id = (select distinct m.customer_id
291: from ra_customer_merges m
292: where a.customer_id =
293: m.duplicate_id