DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARATC dependencies on RA_CUSTOMER_MERGES

Line 43: FROM AR_INTERIM_CASH_RECEIPTS yt, ra_customer_merges m

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

Line 173: FROM AR_INTERIM_CASH_RECEIPT_LINES yt, ra_customer_merges m

169: SELECT distinct CUSTOMER_MERGE_HEADER_ID
170: ,cash_receipt_id
171: ,cash_receipt_line_id
172: ,sold_to_customer
173: FROM AR_INTERIM_CASH_RECEIPT_LINES yt, ra_customer_merges m
174: WHERE (
175: yt.sold_to_customer = m.DUPLICATE_ID
176: ) AND m.process_flag = 'N'
177: AND m.request_id = req_id