APPS.OE_ID_TO_VALUE dependencies on HZ_PARTY_SITES

Line 6113: HZ_PARTY_SITES PARTY_SITE,

6109: , x_sold_to_location_country
6110:
6111: FROM
6112: HZ_CUST_SITE_USES_All SITE,
6113: HZ_PARTY_SITES PARTY_SITE,
6114: HZ_LOCATIONS LOC,
6115: HZ_CUST_ACCT_SITES ACCT_SITE
6116: WHERE
6117: SITE.SITE_USE_CODE = 'SOLD_TO'

Line 6538: hz_party_sites site,

6534: ,x_end_customer_postal_code
6535: ,x_end_customer_country
6536: FROM
6537: hz_locations loc,
6538: hz_party_sites site,
6539: hz_cust_site_uses_all site_use,
6540: hz_cust_acct_sites acct_site
6541: WHERE
6542: site_use.site_use_id= p_end_customer_site_use_id