APPS.INVP_CMERGE_TXHI dependencies on RA_CUSTOMER_MERGES

Line 17: from ra_customer_merges racm

13: CURSOR C1 IS
14: SELECT NULL
15: FROM MTL_UNIT_TRANSACTIONS
16: WHERE customer_id in (select racm.duplicate_id
17: from ra_customer_merges racm
18: where racm.process_flag = 'N'
19: and racm.request_id = req_id
20: and racm.set_number = set_num)
21: FOR UPDATE NOWAIT;

Line 64: from ra_customer_merges racm

60: arp_message.set_line('customer level : customer_id');
61:
62: UPDATE MTL_UNIT_TRANSACTIONS yt
63: set customer_id = (select distinct racm.customer_id
64: from ra_customer_merges racm
65: where yt.customer_id =
66: racm.duplicate_id
67: and racm.process_flag = 'N'
68: and racm.request_id = req_id

Line 74: from ra_customer_merges racm

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
77: and racm.set_number = set_num);
78:

Line 107: FROM ra_customer_merges rcm

103: SELECT movement_id
104: FROM mtl_movement_statistics
105: WHERE ship_to_customer_id IN (
106: SELECT rcm.duplicate_id
107: FROM ra_customer_merges rcm
108: WHERE rcm.process_flag = 'N'
109: AND rcm.request_id = req_id
110: AND rcm.set_number = set_num)
111: OR bill_to_customer_id IN (

Line 113: FROM ra_customer_merges rcm

109: AND rcm.request_id = req_id
110: AND rcm.set_number = set_num)
111: OR bill_to_customer_id IN (
112: SELECT rcm.duplicate_id
113: FROM ra_customer_merges rcm
114: WHERE rcm.process_flag = 'N'
115: AND rcm.request_id = req_id
116: AND rcm.set_number = set_num)
117: FOR UPDATE NOWAIT;

Line 124: FROM ra_customer_merges rcm

120: SELECT movement_id
121: FROM mtl_movement_statistics
122: WHERE ship_to_site_use_id IN (
123: SELECT rcm.duplicate_site_id
124: FROM ra_customer_merges rcm
125: WHERE rcm.process_flag = 'N'
126: AND rcm.request_id = req_id
127: AND rcm.set_number = set_num)
128: OR bill_to_site_use_id IN (

Line 130: FROM ra_customer_merges rcm

126: AND rcm.request_id = req_id
127: AND rcm.set_number = set_num)
128: OR bill_to_site_use_id IN (
129: SELECT rcm.duplicate_site_id
130: FROM ra_customer_merges rcm
131: WHERE rcm.process_flag = 'N'
132: AND rcm.request_id = req_id
133: AND rcm.set_number = set_num)
134: FOR UPDATE NOWAIT;

Line 176: FROM ra_customer_merges rcm

172: decode(mtl.ship_to_customer_id, rcm.duplicate_id,
173: rcm.customer_id, mtl.ship_to_customer_id),
174: decode(mtl.bill_to_customer_id, rcm.duplicate_id,
175: rcm.customer_id, mtl.bill_to_customer_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,

Line 184: FROM ra_customer_merges rcm

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'
186: AND rcm.request_id = req_id
187: AND rcm.set_number = set_num)
188: OR bill_to_customer_id IN (

Line 190: FROM ra_customer_merges rcm

186: AND rcm.request_id = req_id
187: AND rcm.set_number = set_num)
188: OR bill_to_customer_id IN (
189: SELECT rcm.duplicate_id
190: FROM ra_customer_merges rcm
191: WHERE rcm.process_flag = 'N'
192: AND rcm.request_id = req_id
193: AND rcm.set_number = set_num);
194:

Line 214: FROM ra_customer_merges rcm

210: decode(mtl.ship_to_site_use_id, rcm.duplicate_site_id,
211: rcm.customer_site_id, mtl.ship_to_site_use_id),
212: decode(mtl.bill_to_site_use_id, rcm.duplicate_site_id,
213: rcm.customer_site_id, mtl.bill_to_site_use_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,

Line 222: FROM ra_customer_merges rcm

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'
224: AND rcm.request_id = req_id
225: AND rcm.set_number = set_num)
226: OR bill_to_site_use_id IN (

Line 228: FROM ra_customer_merges rcm

224: AND rcm.request_id = req_id
225: AND rcm.set_number = set_num)
226: OR bill_to_site_use_id IN (
227: SELECT rcm.duplicate_site_id
228: FROM ra_customer_merges rcm
229: WHERE rcm.process_flag = 'N'
230: AND rcm.request_id = req_id
231: AND rcm.set_number = set_num);
232: