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_OEORD dependencies on STANDARD

Line 83: last_updated_by = arp_standard.profile.user_id,

79: and m.request_id = req_id
80: and m.process_flag = 'N'
81: and m.set_number = set_num),
82: last_update_date = sysdate,
83: last_updated_by = arp_standard.profile.user_id,
84: last_update_login = arp_standard.profile.last_update_login,
85: request_id = req_id,
86: program_application_id =arp_standard.profile.program_application_id,
87: program_id = arp_standard.profile.program_id,

Line 84: last_update_login = arp_standard.profile.last_update_login,

80: and m.process_flag = 'N'
81: and m.set_number = set_num),
82: last_update_date = sysdate,
83: last_updated_by = arp_standard.profile.user_id,
84: last_update_login = arp_standard.profile.last_update_login,
85: request_id = req_id,
86: program_application_id =arp_standard.profile.program_application_id,
87: program_id = arp_standard.profile.program_id,
88: program_update_date = sysdate

Line 86: program_application_id =arp_standard.profile.program_application_id,

82: last_update_date = sysdate,
83: last_updated_by = arp_standard.profile.user_id,
84: last_update_login = arp_standard.profile.last_update_login,
85: request_id = req_id,
86: program_application_id =arp_standard.profile.program_application_id,
87: program_id = arp_standard.profile.program_id,
88: program_update_date = sysdate
89: where ship_to_site_use_id in (select m.duplicate_site_id
90: from ra_customer_merges m

Line 87: program_id = arp_standard.profile.program_id,

83: last_updated_by = arp_standard.profile.user_id,
84: last_update_login = arp_standard.profile.last_update_login,
85: request_id = req_id,
86: program_application_id =arp_standard.profile.program_application_id,
87: program_id = arp_standard.profile.program_id,
88: program_update_date = sysdate
89: where ship_to_site_use_id in (select m.duplicate_site_id
90: from ra_customer_merges m
91: where m.process_flag = 'N'

Line 112: last_updated_by = arp_standard.profile.user_id,

108: and m.request_id = req_id
109: and m.process_flag = 'N'
110: and m.set_number = set_num),
111: last_update_date = sysdate,
112: last_updated_by = arp_standard.profile.user_id,
113: last_update_login = arp_standard.profile.last_update_login,
114: request_id = req_id,
115: program_application_id =arp_standard.profile.program_application_id,
116: program_id = arp_standard.profile.program_id,

Line 113: last_update_login = arp_standard.profile.last_update_login,

109: and m.process_flag = 'N'
110: and m.set_number = set_num),
111: last_update_date = sysdate,
112: last_updated_by = arp_standard.profile.user_id,
113: last_update_login = arp_standard.profile.last_update_login,
114: request_id = req_id,
115: program_application_id =arp_standard.profile.program_application_id,
116: program_id = arp_standard.profile.program_id,
117: program_update_date = sysdate

Line 115: program_application_id =arp_standard.profile.program_application_id,

111: last_update_date = sysdate,
112: last_updated_by = arp_standard.profile.user_id,
113: last_update_login = arp_standard.profile.last_update_login,
114: request_id = req_id,
115: program_application_id =arp_standard.profile.program_application_id,
116: program_id = arp_standard.profile.program_id,
117: program_update_date = sysdate
118: where invoice_to_site_use_id in (select m.duplicate_site_id
119: from ra_customer_merges m

Line 116: program_id = arp_standard.profile.program_id,

112: last_updated_by = arp_standard.profile.user_id,
113: last_update_login = arp_standard.profile.last_update_login,
114: request_id = req_id,
115: program_application_id =arp_standard.profile.program_application_id,
116: program_id = arp_standard.profile.program_id,
117: program_update_date = sysdate
118: where invoice_to_site_use_id in (select m.duplicate_site_id
119: from ra_customer_merges m
120: where m.process_flag = 'N'

Line 142: last_updated_by = arp_standard.profile.user_id,

138: and m.process_flag = 'N'
139: and m.request_id = req_id
140: and m.set_number = set_num),
141: last_update_date = sysdate,
142: last_updated_by = arp_standard.profile.user_id,
143: last_update_login = arp_standard.profile.last_update_login,
144: request_id = req_id,
145: program_application_id =arp_standard.profile.program_application_id,
146: program_id = arp_standard.profile.program_id,

Line 143: last_update_login = arp_standard.profile.last_update_login,

139: and m.request_id = req_id
140: and m.set_number = set_num),
141: last_update_date = sysdate,
142: last_updated_by = arp_standard.profile.user_id,
143: last_update_login = arp_standard.profile.last_update_login,
144: request_id = req_id,
145: program_application_id =arp_standard.profile.program_application_id,
146: program_id = arp_standard.profile.program_id,
147: program_update_date = sysdate

Line 145: program_application_id =arp_standard.profile.program_application_id,

141: last_update_date = sysdate,
142: last_updated_by = arp_standard.profile.user_id,
143: last_update_login = arp_standard.profile.last_update_login,
144: request_id = req_id,
145: program_application_id =arp_standard.profile.program_application_id,
146: program_id = arp_standard.profile.program_id,
147: program_update_date = sysdate
148: where customer_id in (select m.duplicate_id
149: from ra_customer_merges m

Line 146: program_id = arp_standard.profile.program_id,

142: last_updated_by = arp_standard.profile.user_id,
143: last_update_login = arp_standard.profile.last_update_login,
144: request_id = req_id,
145: program_application_id =arp_standard.profile.program_application_id,
146: program_id = arp_standard.profile.program_id,
147: program_update_date = sysdate
148: where customer_id in (select m.duplicate_id
149: from ra_customer_merges m
150: where m.process_flag = 'N'

Line 218: last_updated_by = arp_standard.profile.user_id,

214: and m.request_id = req_id
215: and m.process_flag = 'N'
216: and m.set_number = set_num),
217: last_update_date = sysdate,
218: last_updated_by = arp_standard.profile.user_id,
219: last_update_login = arp_standard.profile.last_update_login,
220: request_id = req_id,
221: program_application_id =arp_standard.profile.program_application_id,
222: program_id = arp_standard.profile.program_id,

Line 219: last_update_login = arp_standard.profile.last_update_login,

215: and m.process_flag = 'N'
216: and m.set_number = set_num),
217: last_update_date = sysdate,
218: last_updated_by = arp_standard.profile.user_id,
219: last_update_login = arp_standard.profile.last_update_login,
220: request_id = req_id,
221: program_application_id =arp_standard.profile.program_application_id,
222: program_id = arp_standard.profile.program_id,
223: program_update_date = sysdate

Line 221: program_application_id =arp_standard.profile.program_application_id,

217: last_update_date = sysdate,
218: last_updated_by = arp_standard.profile.user_id,
219: last_update_login = arp_standard.profile.last_update_login,
220: request_id = req_id,
221: program_application_id =arp_standard.profile.program_application_id,
222: program_id = arp_standard.profile.program_id,
223: program_update_date = sysdate
224: where ship_to_site_use_id in (select m.duplicate_site_id
225: from ra_customer_merges m

Line 222: program_id = arp_standard.profile.program_id,

218: last_updated_by = arp_standard.profile.user_id,
219: last_update_login = arp_standard.profile.last_update_login,
220: request_id = req_id,
221: program_application_id =arp_standard.profile.program_application_id,
222: program_id = arp_standard.profile.program_id,
223: program_update_date = sysdate
224: where ship_to_site_use_id in (select m.duplicate_site_id
225: from ra_customer_merges m
226: where m.process_flag = 'N'

Line 292: last_updated_by = arp_standard.profile.user_id,

288: and m.request_id = req_id
289: and m.process_flag = 'N'
290: and m.set_number = set_num),
291: last_update_date = sysdate,
292: last_updated_by = arp_standard.profile.user_id,
293: last_update_login = arp_standard.profile.last_update_login
294: where installation_site_use_id in (select m.duplicate_site_id
295: from ra_customer_merges m
296: where m.process_flag = 'N'

Line 293: last_update_login = arp_standard.profile.last_update_login

289: and m.process_flag = 'N'
290: and m.set_number = set_num),
291: last_update_date = sysdate,
292: last_updated_by = arp_standard.profile.user_id,
293: last_update_login = arp_standard.profile.last_update_login
294: where installation_site_use_id in (select m.duplicate_site_id
295: from ra_customer_merges m
296: where m.process_flag = 'N'
297: and m.request_id = req_id

Line 362: last_updated_by = arp_standard.profile.user_id,

358: and m.process_flag = 'N'
359: and m.request_id = req_id
360: and m.set_number = set_num),
361: last_update_date = sysdate,
362: last_updated_by = arp_standard.profile.user_id,
363: last_update_login = arp_standard.profile.last_update_login
364: where customer_id in (select m.duplicate_id
365: from ra_customer_merges m
366: where m.process_flag = 'N'

Line 363: last_update_login = arp_standard.profile.last_update_login

359: and m.request_id = req_id
360: and m.set_number = set_num),
361: last_update_date = sysdate,
362: last_updated_by = arp_standard.profile.user_id,
363: last_update_login = arp_standard.profile.last_update_login
364: where customer_id in (select m.duplicate_id
365: from ra_customer_merges m
366: where m.process_flag = 'N'
367: and m.request_id = req_id

Line 391: select standard_value_rule_id

387:
388: PROCEDURE oe_vr (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
389:
390: CURSOR c1 is
391: select standard_value_rule_id
392: from so_standard_value_rules
393: where attribute_value in (select to_char(m.duplicate_site_id)
394: from ra_customer_merges m
395: where m.process_flag = 'N'

Line 392: from so_standard_value_rules

388: PROCEDURE oe_vr (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
389:
390: CURSOR c1 is
391: select standard_value_rule_id
392: from so_standard_value_rules
393: where attribute_value in (select to_char(m.duplicate_site_id)
394: from ra_customer_merges m
395: where m.process_flag = 'N'
396: and m.request_id = req_id

Line 398: and standard_value_source_id = 1

394: from ra_customer_merges m
395: where m.process_flag = 'N'
396: and m.request_id = req_id
397: and m.set_number = set_num)
398: and standard_value_source_id = 1
399: and attribute_id = 10026
400: for update nowait;
401:
402: CURSOR c2 is

Line 403: select standard_value_rule_id

399: and attribute_id = 10026
400: for update nowait;
401:
402: CURSOR c2 is
403: select standard_value_rule_id
404: from so_standard_value_rules
405: where attribute_value in (select to_char(m.duplicate_site_id)
406: from ra_customer_merges m
407: where m.process_flag = 'N'

Line 404: from so_standard_value_rules

400: for update nowait;
401:
402: CURSOR c2 is
403: select standard_value_rule_id
404: from so_standard_value_rules
405: where attribute_value in (select to_char(m.duplicate_site_id)
406: from ra_customer_merges m
407: where m.process_flag = 'N'
408: and m.request_id = req_id

Line 410: and standard_value_source_id = 1

406: from ra_customer_merges m
407: where m.process_flag = 'N'
408: and m.request_id = req_id
409: and m.set_number = set_num)
410: and standard_value_source_id = 1
411: and attribute_id = 10028
412: for update nowait;
413:
414:

Line 422: | SO_STANDARD_VALUE_RULES |

418:
419:
420:
421: /*-----------------------------+
422: | SO_STANDARD_VALUE_RULES |
423: +-----------------------------*/
424: /* both customer and site level */
425:
426: IF( process_mode = 'LOCK' ) THEN

Line 429: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );

425:
426: IF( process_mode = 'LOCK' ) THEN
427:
428: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
429: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
430:
431: open c1;
432: close c1;
433:

Line 443: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );

439:
440:
441: /* site level update */
442: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
443: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
444:
445:
446:
447: UPDATE SO_STANDARD_VALUE_RULES a

Line 447: UPDATE SO_STANDARD_VALUE_RULES a

443: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
444:
445:
446:
447: UPDATE SO_STANDARD_VALUE_RULES a
448: set attribute_value = (select distinct to_char(m.customer_site_id)
449: from ra_customer_merges m
450: where a.attribute_value =
451: to_char(m.duplicate_site_id)

Line 456: last_updated_by = arp_standard.profile.user_id,

452: and m.request_id = req_id
453: and m.process_flag = 'N'
454: and m.set_number = set_num),
455: last_update_date = sysdate,
456: last_updated_by = arp_standard.profile.user_id,
457: last_update_login = arp_standard.profile.last_update_login
458: where attribute_value in (select to_char(m.duplicate_site_id)
459: from ra_customer_merges m
460: where m.process_flag = 'N'

Line 457: last_update_login = arp_standard.profile.last_update_login

453: and m.process_flag = 'N'
454: and m.set_number = set_num),
455: last_update_date = sysdate,
456: last_updated_by = arp_standard.profile.user_id,
457: last_update_login = arp_standard.profile.last_update_login
458: where attribute_value in (select to_char(m.duplicate_site_id)
459: from ra_customer_merges m
460: where m.process_flag = 'N'
461: and m.request_id = req_id

Line 463: and standard_value_source_id = 1

459: from ra_customer_merges m
460: where m.process_flag = 'N'
461: and m.request_id = req_id
462: and m.set_number = set_num)
463: and standard_value_source_id = 1
464: and attribute_id = 10026;
465:
466: g_count := sql%rowcount;
467:

Line 474: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );

470:
471:
472: /* site level update */
473: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
474: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
475:
476:
477:
478: UPDATE SO_STANDARD_VALUE_RULES a

Line 478: UPDATE SO_STANDARD_VALUE_RULES a

474: arp_message.set_token( 'TABLE_NAME', 'SO_STANDARD_VALUE_RULES', FALSE );
475:
476:
477:
478: UPDATE SO_STANDARD_VALUE_RULES a
479: set attribute_value = (select distinct to_char(m.customer_site_id)
480: from ra_customer_merges m
481: where a.attribute_value =
482: to_char(m.duplicate_site_id)

Line 487: last_updated_by = arp_standard.profile.user_id,

483: and m.request_id = req_id
484: and m.process_flag = 'N'
485: and m.set_number = set_num),
486: last_update_date = sysdate,
487: last_updated_by = arp_standard.profile.user_id,
488: last_update_login = arp_standard.profile.last_update_login
489: where attribute_value in (select to_char(m.duplicate_site_id)
490: from ra_customer_merges m
491: where m.process_flag = 'N'

Line 488: last_update_login = arp_standard.profile.last_update_login

484: and m.process_flag = 'N'
485: and m.set_number = set_num),
486: last_update_date = sysdate,
487: last_updated_by = arp_standard.profile.user_id,
488: last_update_login = arp_standard.profile.last_update_login
489: where attribute_value in (select to_char(m.duplicate_site_id)
490: from ra_customer_merges m
491: where m.process_flag = 'N'
492: and m.request_id = req_id

Line 494: and standard_value_source_id = 1

490: from ra_customer_merges m
491: where m.process_flag = 'N'
492: and m.request_id = req_id
493: and m.set_number = set_num)
494: and standard_value_source_id = 1
495: and attribute_id = 10028;
496:
497: g_count := sql%rowcount;
498: