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 ARP_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 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 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