DBA Data[Home] [Help]

APPS.INVP_CMERGE_SPDM dependencies on STANDARD

Line 100: last_updated_by = arp_standard.profile.user_id,

96: and racm.process_flag = 'N'
97: and racm.request_id = req_id
98: and racm.set_number = set_num),
99: last_update_date = sysdate,
100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,

Line 101: last_update_login = arp_standard.profile.last_update_login,

97: and racm.request_id = req_id
98: and racm.set_number = set_num),
99: last_update_date = sysdate,
100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,
105: program_update_date = sysdate

Line 103: program_application_id = arp_standard.profile.program_application_id,

99: last_update_date = sysdate,
100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,
105: program_update_date = sysdate
106: where ship_to_site_use_id in (select racm.duplicate_site_id
107: from ra_customer_merges racm

Line 104: program_id = arp_standard.profile.program_id,

100: last_updated_by = arp_standard.profile.user_id,
101: last_update_login = arp_standard.profile.last_update_login,
102: request_id = req_id,
103: program_application_id = arp_standard.profile.program_application_id,
104: program_id = arp_standard.profile.program_id,
105: program_update_date = sysdate
106: where ship_to_site_use_id in (select racm.duplicate_site_id
107: from ra_customer_merges racm
108: where racm.process_flag = 'N'

Line 141: last_updated_by = arp_standard.profile.user_id,

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

Line 142: last_update_login = arp_standard.profile.last_update_login,

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

Line 144: program_application_id =arp_standard.profile.program_application_id,

140: last_update_date = sysdate,
141: last_updated_by = arp_standard.profile.user_id,
142: last_update_login = arp_standard.profile.last_update_login,
143: request_id = req_id,
144: program_application_id =arp_standard.profile.program_application_id,
145: program_id = arp_standard.profile.program_id,
146: program_update_date = sysdate
147: where bill_to_site_use_id in (select racm.duplicate_site_id
148: from ra_customer_merges racm

Line 145: program_id = arp_standard.profile.program_id,

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

Line 184: last_updated_by = arp_standard.profile.user_id,

180: and racm.process_flag = 'N'
181: and racm.request_id = req_id
182: and racm.set_number = set_num),
183: last_update_date = sysdate,
184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,

Line 185: last_update_login = arp_standard.profile.last_update_login,

181: and racm.request_id = req_id
182: and racm.set_number = set_num),
183: last_update_date = sysdate,
184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,
189: program_update_date = sysdate

Line 187: program_application_id =arp_standard.profile.program_application_id,

183: last_update_date = sysdate,
184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,
189: program_update_date = sysdate
190: where ship_to_site_use_id in (select racm.duplicate_site_id
191: from ra_customer_merges racm

Line 188: program_id = arp_standard.profile.program_id,

184: last_updated_by = arp_standard.profile.user_id,
185: last_update_login = arp_standard.profile.last_update_login,
186: request_id = req_id,
187: program_application_id =arp_standard.profile.program_application_id,
188: program_id = arp_standard.profile.program_id,
189: program_update_date = sysdate
190: where ship_to_site_use_id in (select racm.duplicate_site_id
191: from ra_customer_merges racm
192: where racm.process_flag = 'N'

Line 223: last_updated_by = arp_standard.profile.user_id,

219: and racm.process_flag = 'N'
220: and racm.request_id = req_id
221: and racm.set_number = set_num),
222: last_update_date = sysdate,
223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,

Line 224: last_update_login = arp_standard.profile.last_update_login,

220: and racm.request_id = req_id
221: and racm.set_number = set_num),
222: last_update_date = sysdate,
223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,
228: program_update_date = sysdate

Line 226: program_application_id =arp_standard.profile.program_application_id,

222: last_update_date = sysdate,
223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,
228: program_update_date = sysdate
229: where customer_id in (select racm.duplicate_id
230: from ra_customer_merges racm

Line 227: program_id = arp_standard.profile.program_id,

223: last_updated_by = arp_standard.profile.user_id,
224: last_update_login = arp_standard.profile.last_update_login,
225: request_id = req_id,
226: program_application_id =arp_standard.profile.program_application_id,
227: program_id = arp_standard.profile.program_id,
228: program_update_date = sysdate
229: where customer_id in (select racm.duplicate_id
230: from ra_customer_merges racm
231: where racm.process_flag = 'N'