DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_MERGE_PUB dependencies on HZ_MERGE_ADDRESSES_V

Line 1771: from hz_merge_addresses_v a

1767: , 'Y' /*CUSTOMER_CREATESAME*/
1768: , a.site_number /*DUPLICATE_SITE_NUMBER*/
1769: , NULL /*CUSTOMER_SITE_NUMBER*/
1770: , a.org_id /*ORG_ID*/
1771: from hz_merge_addresses_v a
1772: where customer_id = l_account_merge_request_obj.merge_from_account.account_id
1773: and a.org_id = decode(l_account_merge_request_obj.org_id,-1,a.org_id,l_account_merge_request_obj.org_id)
1774: and ((a.site_use_id <> -99 AND a.site_use_id not in (select duplicate_site_id
1775: from ra_customer_merges m