DBA Data[Home] [Help]

APPS.INVP_CMERGE_TXHI dependencies on STANDARD

Line 71: last_updated_by = arp_standard.profile.user_id,

67: and racm.process_flag = 'N'
68: and racm.request_id = req_id
69: and racm.set_number = set_num),
70: last_update_date = sysdate,
71: last_updated_by = arp_standard.profile.user_id,
72: last_update_login = arp_standard.profile.last_update_login
73: where customer_id in (select racm.duplicate_id
74: from ra_customer_merges racm
75: where racm.process_flag = 'N'

Line 72: last_update_login = arp_standard.profile.last_update_login

68: and racm.request_id = req_id
69: and racm.set_number = set_num),
70: last_update_date = sysdate,
71: last_updated_by = arp_standard.profile.user_id,
72: last_update_login = arp_standard.profile.last_update_login
73: where customer_id in (select racm.duplicate_id
74: from ra_customer_merges racm
75: where racm.process_flag = 'N'
76: and racm.request_id = req_id

Line 180: last_updated_by = arp_standard.profile.user_id,

176: FROM ra_customer_merges rcm
177: WHERE mtl.ship_to_customer_id = rcm.duplicate_id
178: OR mtl.bill_to_customer_id = rcm.duplicate_id),
179: last_update_date = sysdate,
180: last_updated_by = arp_standard.profile.user_id,
181: last_update_login = arp_standard.profile.last_update_login
182: WHERE ship_to_customer_id IN (
183: SELECT rcm.duplicate_id
184: FROM ra_customer_merges rcm

Line 181: last_update_login = arp_standard.profile.last_update_login

177: WHERE mtl.ship_to_customer_id = rcm.duplicate_id
178: OR mtl.bill_to_customer_id = rcm.duplicate_id),
179: last_update_date = sysdate,
180: last_updated_by = arp_standard.profile.user_id,
181: last_update_login = arp_standard.profile.last_update_login
182: WHERE ship_to_customer_id IN (
183: SELECT rcm.duplicate_id
184: FROM ra_customer_merges rcm
185: WHERE rcm.process_flag = 'N'

Line 218: last_updated_by = arp_standard.profile.user_id,

214: FROM ra_customer_merges rcm
215: WHERE mtl.ship_to_site_use_id = rcm.duplicate_site_id
216: OR mtl.bill_to_site_use_id = rcm.duplicate_site_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: WHERE ship_to_site_use_id IN (
221: SELECT rcm.duplicate_site_id
222: FROM ra_customer_merges rcm

Line 219: last_update_login = arp_standard.profile.last_update_login

215: WHERE mtl.ship_to_site_use_id = rcm.duplicate_site_id
216: OR mtl.bill_to_site_use_id = rcm.duplicate_site_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: WHERE ship_to_site_use_id IN (
221: SELECT rcm.duplicate_site_id
222: FROM ra_customer_merges rcm
223: WHERE rcm.process_flag = 'N'