APPS.MSC_SATP_FUNC dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1727: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1723: INTO l_postal_code, l_city, l_state, l_country
1724: FROM HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
1725: HZ_PARTY_SITES PARTY_SITE,
1726: HZ_LOCATIONS LOC,
1727: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1728: WHERE LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1729: AND PARTY_SITE.party_site_id =ACCT_SITE.party_site_id
1730: AND SITE_USES_ALL.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1731: AND SITE_USES_ALL.site_use_id = p_customer_site_id;

Line 2260: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2256: (SELECT LOC.LOCATION_ID
2257: FROM HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
2258: HZ_PARTY_SITES PARTY_SITE,
2259: HZ_LOCATIONS LOC,
2260: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2261: WHERE LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2262: AND PARTY_SITE.party_site_id =ACCT_SITE.party_site_id
2263: AND SITE_USES_ALL.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2264: AND SITE_USES_ALL.site_use_id = :p_customer_site_id

Line 2284: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2280: (SELECT LOC.LOCATION_ID
2281: FROM HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
2282: HZ_PARTY_SITES PARTY_SITE,
2283: HZ_LOCATIONS LOC,
2284: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2285: WHERE LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2286: AND PARTY_SITE.party_site_id =ACCT_SITE.party_site_id
2287: AND SITE_USES_ALL.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2288: AND SITE_USES_ALL.site_use_id = p_customer_site_id

Line 2303: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2299: FROM WSH_REGION_LOCATIONS WRL,
2300: HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
2301: HZ_PARTY_SITES PARTY_SITE,
2302: HZ_LOCATIONS LOC,
2303: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2304: WHERE WRL.location_id = LOC.LOCATION_ID
2305: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2306: AND PARTY_SITE.party_site_id =ACCT_SITE.party_site_id
2307: AND SITE_USES_ALL.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID