eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVP_CMERGE_SPDM dependencies on RA_CUSTOMER_MERGES

Line 19: from ra_customer_merges racm

15: CURSOR C1 IS
16: SELECT NULL
17: FROM MTL_DEMAND
18: WHERE bill_to_site_use_id in (select racm.duplicate_site_id
19: from ra_customer_merges racm
20: where racm.process_flag = 'N'
21: and racm.request_id = req_id
22: and racm.set_number = set_num)
23: FOR UPDATE NOWAIT;

Line 29: from ra_customer_merges racm

25: CURSOR C2 IS
26: SELECT NULL
27: FROM MTL_DEMAND
28: WHERE ship_to_site_use_id in (select racm.duplicate_site_id
29: from ra_customer_merges racm
30: where racm.process_flag = 'N'
31: and racm.request_id = req_id
32: and racm.set_number = set_num)
33: FOR UPDATE NOWAIT;

Line 39: from ra_customer_merges racm

35: CURSOR C3 IS
36: SELECT NULL
37: FROM MTL_DEMAND
38: WHERE customer_id in (select racm.duplicate_id
39: from ra_customer_merges racm
40: where racm.process_flag = 'N'
41: and racm.request_id = req_id
42: and racm.set_number = set_num)
43: and ship_to_site_use_id is NULL

Line 78: from ra_customer_merges racm

74: arp_message.set_line('site level update : ship to and bill to site use id');
75:
76: UPDATE MTL_DEMAND yt
77: set customer_id = (select distinct racm.customer_id
78: from ra_customer_merges racm
79: where yt.customer_id = racm.duplicate_id
80: and (yt.ship_to_site_use_id = racm.duplicate_site_id
81: or yt.bill_to_site_use_id = racm.duplicate_site_id)
82: and racm.process_flag= 'N'

Line 86: from ra_customer_merges racm

82: and racm.process_flag= 'N'
83: and racm.request_id = req_id
84: and racm.set_number = set_num),
85: ship_to_site_use_id = (select distinct racm.customer_site_id
86: from ra_customer_merges racm
87: where yt.customer_id = racm.duplicate_id
88: and yt.ship_to_site_use_id = racm.duplicate_site_id
89: and racm.process_flag = 'N'
90: and racm.request_id = req_id

Line 93: from ra_customer_merges racm

89: and racm.process_flag = 'N'
90: and racm.request_id = req_id
91: and racm.set_number = set_num),
92: bill_to_site_use_id = (select distinct racm.customer_site_id
93: from ra_customer_merges racm
94: where yt.customer_id = racm.duplicate_id
95: and yt.bill_to_site_use_id = racm.duplicate_site_id
96: and racm.process_flag = 'N'
97: and racm.request_id = req_id

Line 107: from ra_customer_merges racm

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'
109: and racm.request_id = req_id
110: and racm.set_number = set_num)
111: and bill_to_site_use_id in (select racm.duplicate_site_id

Line 112: from ra_customer_merges racm

108: where racm.process_flag = 'N'
109: and racm.request_id = req_id
110: and racm.set_number = set_num)
111: and bill_to_site_use_id in (select racm.duplicate_site_id
112: from ra_customer_merges racm
113: where racm.process_flag = 'N'
114: and racm.request_id = req_id
115: and racm.set_number = set_num);
116:

Line 134: from ra_customer_merges racm

130: UPDATE MTL_DEMAND yt
131: set (customer_id,
132: bill_to_site_use_id) = (select distinct racm.customer_id,
133: racm.customer_site_id
134: from ra_customer_merges racm
135: where yt.customer_id = racm.duplicate_id
136: and yt.bill_to_site_use_id = racm.duplicate_site_id
137: and racm.process_flag = 'N'
138: and racm.request_id = req_id

Line 148: from ra_customer_merges racm

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'
150: and racm.request_id = req_id
151: and racm.set_number = set_num)
152: and (ship_to_site_use_id is NULL

Line 154: from ra_customer_merges racm

150: and racm.request_id = req_id
151: and racm.set_number = set_num)
152: and (ship_to_site_use_id is NULL
153: or ship_to_site_use_id not in (select racm.duplicate_site_id
154: from ra_customer_merges racm
155: where racm.process_flag = 'N'
156: and racm.request_id = req_id
157: and racm.set_number = set_num));
158:

Line 177: from ra_customer_merges racm

173: UPDATE MTL_DEMAND yt
174: set (customer_id,
175: ship_to_site_use_id) = (select distinct racm.customer_id,
176: racm.customer_site_id
177: from ra_customer_merges racm
178: where yt.customer_id = racm.duplicate_id
179: and yt.ship_to_site_use_id = racm.duplicate_site_id
180: and racm.process_flag = 'N'
181: and racm.request_id = req_id

Line 191: from ra_customer_merges racm

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'
193: and racm.request_id = req_id
194: and racm.set_number = set_num)
195: and (bill_to_site_use_id is NULL

Line 197: from ra_customer_merges racm

193: and racm.request_id = req_id
194: and racm.set_number = set_num)
195: and (bill_to_site_use_id is NULL
196: or bill_to_site_use_id not in (select racm.duplicate_site_id
197: from ra_customer_merges racm
198: where racm.process_flag = 'N'
199: and racm.request_id = req_id
200: and racm.set_number = set_num));
201:

Line 216: from ra_customer_merges racm

212: arp_message.set_line('customer level : customer_id');
213:
214: UPDATE MTL_DEMAND yt
215: set customer_id = (select distinct racm.customer_id
216: from ra_customer_merges racm
217: where yt.customer_id =
218: racm.duplicate_id
219: and racm.process_flag = 'N'
220: and racm.request_id = req_id

Line 230: from ra_customer_merges racm

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'
232: and racm.request_id = req_id
233: and racm.set_number = set_num)
234: and ship_to_site_use_id is NULL