APPS.ARP_CMERGE_ARCON dependencies on RA_CUSTOMER_MERGES

Line 43: FROM AR_CONS_INV yt, ra_customer_merges m

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

Line 130: ra_customer_merges m

126: SET status = 'MERGE_PENDING'
127: WHERE (cons_inv_id) in
128: (SELECT max(ci2.cons_inv_id)
129: FROM ar_cons_inv ci2,
130: ra_customer_merges m
131: WHERE ci2.site_use_id = m.duplicate_site_id
132: AND m.process_flag = 'N'
133: AND m.request_id = req_id
134: AND m.set_number = set_num