APPS.ARP_CMERGE_ARCOL dependencies on RA_CUSTOMER_MERGES

Line 44: FROM AR_CUSTOMER_CALL_TOPICS yt, ra_customer_merges m

40: SELECT distinct CUSTOMER_MERGE_HEADER_ID
41: ,customer_call_topic_id
42: ,yt.customer_id
43: ,site_use_id
44: FROM AR_CUSTOMER_CALL_TOPICS yt, ra_customer_merges m
45: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
46: nvl(yt.site_use_id, m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
47: AND m.process_flag = 'N'
48: AND m.request_id = req_id

Line 175: FROM AR_CUSTOMER_CALLS yt, ra_customer_merges m

171: SELECT distinct CUSTOMER_MERGE_HEADER_ID
172: ,customer_call_id
173: ,yt.customer_id
174: ,site_use_id
175: FROM AR_CUSTOMER_CALLS yt, ra_customer_merges m
176: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
177: nvl(yt.site_use_id, m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
178: AND m.process_flag = 'N'
179: AND m.request_id = req_id

Line 308: FROM AR_STATEMENTS_HISTORY yt, ra_customer_merges m

304: SELECT distinct CUSTOMER_MERGE_HEADER_ID
305: ,line_cluster_id
306: ,yt.customer_id
307: ,site_use_id
308: FROM AR_STATEMENTS_HISTORY yt, ra_customer_merges m
309: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
310: yt.site_use_id = m.DUPLICATE_SITE_ID)
311: AND m.process_flag = 'N'
312: AND m.request_id = req_id