DBA Data[Home] [Help]

APPS.INVP_CMERGE_TXHI dependencies on ARP_STANDARD

Line 73: last_updated_by = arp_standard.profile.user_id,

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

Line 74: last_update_login = arp_standard.profile.last_update_login

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

Line 182: last_updated_by = arp_standard.profile.user_id,

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

Line 183: last_update_login = arp_standard.profile.last_update_login

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

Line 220: last_updated_by = arp_standard.profile.user_id,

216: FROM ra_customer_merges rcm
217: WHERE mtl.ship_to_site_use_id = rcm.duplicate_site_id
218: OR mtl.bill_to_site_use_id = rcm.duplicate_site_id),
219: last_update_date = sysdate,
220: last_updated_by = arp_standard.profile.user_id,
221: last_update_login = arp_standard.profile.last_update_login
222: WHERE ship_to_site_use_id IN (
223: SELECT rcm.duplicate_site_id
224: FROM ra_customer_merges rcm

Line 221: last_update_login = arp_standard.profile.last_update_login

217: WHERE mtl.ship_to_site_use_id = rcm.duplicate_site_id
218: OR mtl.bill_to_site_use_id = rcm.duplicate_site_id),
219: last_update_date = sysdate,
220: last_updated_by = arp_standard.profile.user_id,
221: last_update_login = arp_standard.profile.last_update_login
222: WHERE ship_to_site_use_id IN (
223: SELECT rcm.duplicate_site_id
224: FROM ra_customer_merges rcm
225: WHERE rcm.process_flag = 'N'