APPS.CN_CUST_MERGE_PVT dependencies on RA_CUSTOMER_MERGES

Line 45: FROM CN_COMMISSION_HEADERS_ALL yt, ra_customer_merges m

41: ,yt.COMMISSION_HEADER_ID
42: ,yt.CUSTOMER_ID
43: ,yt.BILL_TO_ADDRESS_ID
44: ,yt.SHIP_TO_ADDRESS_ID
45: FROM CN_COMMISSION_HEADERS_ALL yt, ra_customer_merges m
46: WHERE (
47: yt.CUSTOMER_ID = m.DUPLICATE_ID
48: OR ((yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID)
49: AND

Line 61: FROM ra_customer_merges

57: ;
58:
59: CURSOR CUST(p_duplicate_cust_id NUMBER) IS
60: SELECT distinct customer_id
61: FROM ra_customer_merges
62: WHERE set_number = set_num
63: AND request_id = req_id
64: AND duplicate_id = p_duplicate_cust_id;
65:

Line 68: FROM ra_customer_merges

64: AND duplicate_id = p_duplicate_cust_id;
65:
66: CURSOR ADDR(p_duplicate_addr_id NUMBER) IS
67: SELECT distinct customer_address_id
68: FROM ra_customer_merges
69: WHERE set_number = set_num
70: AND request_id = req_id
71: AND duplicate_address_id = p_duplicate_addr_id;
72:

Line 75: FROM ra_customer_merges

71: AND duplicate_address_id = p_duplicate_addr_id;
72:
73: CURSOR SITE(p_duplicate_site_id NUMBER) IS
74: SELECT distinct customer_site_id
75: FROM ra_customer_merges
76: WHERE set_number = set_num
77: AND request_id = req_id
78: AND duplicate_site_id = p_duplicate_site_id;
79:

Line 266: FROM CN_COMM_LINES_API_ALL yt, ra_customer_merges m

262: ,yt.COMM_LINES_API_ID
263: ,yt.CUSTOMER_ID
264: ,yt.BILL_TO_ADDRESS_ID
265: ,yt.SHIP_TO_ADDRESS_ID
266: FROM CN_COMM_LINES_API_ALL yt, ra_customer_merges m
267: WHERE (
268: yt.CUSTOMER_ID = m.DUPLICATE_ID
269: OR ((yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID)
270: AND

Line 281: FROM ra_customer_merges

277: AND m.set_number = set_num;
278:
279: CURSOR CUST(p_duplicate_cust_id NUMBER) IS
280: SELECT distinct customer_id
281: FROM ra_customer_merges
282: WHERE set_number = set_num
283: AND request_id = req_id
284: AND DUPLICATE_ID = p_duplicate_cust_id;
285:

Line 288: FROM ra_customer_merges

284: AND DUPLICATE_ID = p_duplicate_cust_id;
285:
286: CURSOR ADDR(p_duplicate_addr_id NUMBER) IS
287: SELECT distinct customer_address_id
288: FROM ra_customer_merges
289: WHERE set_number = set_num
290: AND request_id = req_id
291: AND duplicate_address_id = p_duplicate_addr_id;
292:

Line 295: FROM ra_customer_merges

291: AND duplicate_address_id = p_duplicate_addr_id;
292:
293: CURSOR SITE(p_duplicate_site_id NUMBER) IS
294: SELECT distinct customer_site_id
295: FROM ra_customer_merges
296: WHERE set_number = set_num
297: AND request_id = req_id
298: AND duplicate_site_id = p_duplicate_site_id;
299: