DBA Data[Home] [Help]

APPS.IBY_MERGE dependencies on RA_CUSTOMER_MERGES

Line 76: FROM iby_trxn_summaries_all yt, ra_customer_merges m

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

Line 807: FROM iby_external_payers_all yt, ra_customer_merges m

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 )