DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCPF dependencies on HZ_CUST_ACCT_SITES_ALL

Line 635: FROM hz_cust_acct_sites_all acct --SSUptake

631: AND m.delete_duplicate_flag = 'Y'
632: AND site_use_id IS NULL
633: AND NOT EXISTS (
634: SELECT 'accounts exist'
635: FROM hz_cust_acct_sites_all acct --SSUptake
636: WHERE acct.cust_account_id = yt.cust_account_id
637: AND acct.org_id = m.org_id --SSUptake
638: AND status <> 'D' )
639: