DBA Data[Home] [Help]

APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 4498: , HZ_CUST_SITE_USES_ALL CSU

4494: , HPS.PARTY_SITE_ID
4495: , HPS.LOCATION_ID
4496: FROM HZ_PARTY_SITES HPS
4497: , HZ_CUST_ACCT_SITES_ALL CAS
4498: , HZ_CUST_SITE_USES_ALL CSU
4499: WHERE CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
4500: AND CAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
4501: AND CSU.SITE_USE_ID = l_site_use_id;
4502:

Line 4775: , HZ_CUST_SITE_USES_ALL CSU

4771: , HPS.PARTY_SITE_ID
4772: , HPS.LOCATION_ID
4773: FROM HZ_PARTY_SITES HPS
4774: , HZ_CUST_ACCT_SITES_ALL CAS
4775: , HZ_CUST_SITE_USES_ALL CSU
4776: WHERE CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
4777: AND CAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
4778: AND CSU.SITE_USE_ID = l_site_use_id;
4779: