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 66: from ra_customer_merges racm

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

Line 76: from ra_customer_merges racm

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

Line 109: FROM ra_customer_merges rcm

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

Line 115: FROM ra_customer_merges rcm

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

Line 126: FROM ra_customer_merges rcm

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

Line 132: FROM ra_customer_merges rcm

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

Line 178: FROM ra_customer_merges rcm

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

Line 186: FROM ra_customer_merges rcm

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

Line 192: FROM ra_customer_merges rcm

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

Line 216: FROM ra_customer_merges rcm

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

Line 224: FROM ra_customer_merges rcm

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

Line 230: FROM ra_customer_merges rcm

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