72: ,trxnmid
73: ,cust_account_id
74: ,acct_site_id
75: ,acct_site_use_id
76: FROM iby_trxn_summaries_all yt, ra_customer_merges m
77: WHERE (
78: yt.cust_account_id = m.duplicate_id
79: OR yt.acct_site_id = m.duplicate_address_id
80: OR yt.acct_site_use_id = m.duplicate_site_id
803: SELECT DISTINCT customer_merge_header_id
804: ,ext_payer_id
805: ,cust_account_id
806: ,acct_site_use_id
807: FROM iby_external_payers_all yt, ra_customer_merges m
808: WHERE (
809: ( yt.cust_account_id = m.duplicate_id
810: AND yt.acct_site_use_id is null
811: AND m.customer_id <> m.duplicate_id )