APPS.AR_CMGT_ACCOUNT_MERGE dependencies on RA_CUSTOMER_MERGES

Line 46: ra_customer_merges m

42: ,CASE_FOLDER_ID
43: ,CUST_ACCOUNT_ID
44: ,SITE_USE_ID
45: FROM ar_cmgt_case_folders yt,
46: ra_customer_merges m
47: WHERE yt.cust_account_id = m.duplicate_id
48: AND DECODE( yt.site_use_id , -99, m.duplicate_site_id,
49: yt.site_use_id ) = m.duplicate_site_id
50: AND m.process_flag = 'N'

Line 199: ra_customer_merges m

195: ,CREDIT_REQUEST_ID
196: ,CUST_ACCOUNT_ID
197: ,SITE_USE_ID
198: FROM AR_CMGT_CREDIT_REQUESTS yt,
199: ra_customer_merges m
200: WHERE yt.cust_account_id = m.DUPLICATE_ID
201: AND DECODE( yt.site_use_id , -99, m.duplicate_site_id,
202: yt.site_use_id ) = m.duplicate_site_id
203: AND m.process_flag = 'N'

Line 417: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m

413: ,PAST_DUE_INV_INST_COUNT
414: ,LAST_PAYMENT_AMOUNT
415: ,LAST_PAYMENT_DATE
416: ,LAST_PAYMENT_NUMBER
417: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m
418: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
419: AND DECODE(yt.SITE_USE_ID , -99, m.DUPLICATE_SITE_ID,
420: yt.SITE_USE_ID) = m.DUPLICATE_SITE_ID
421: AND m.process_flag = 'N'

Line 460: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m

456: ,PAST_DUE_INV_INST_COUNT
457: ,LAST_PAYMENT_AMOUNT
458: ,LAST_PAYMENT_DATE
459: ,LAST_PAYMENT_NUMBER
460: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m
461: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
462: AND yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
463: AND m.process_flag = 'N'
464: AND m.request_id = req_id

Line 1010: FROM AR_TRX_SUMMARY yt, ra_customer_merges m

1006: ,LARGEST_INV_CUST_TRX_ID
1007: ,DAYS_CREDIT_GRANTED_SUM
1008: ,NSF_STOP_PAYMENT_COUNT
1009: ,NSF_STOP_PAYMENT_AMOUNT
1010: FROM AR_TRX_SUMMARY yt, ra_customer_merges m
1011: WHERE yt.cust_account_id = m.duplicate_id
1012: AND DECODE( yt.site_use_id , -99, m.duplicate_site_id,
1013: yt.site_use_id ) = m.duplicate_site_id
1014: AND m.process_flag = 'N'