APPS.OE_ID_TO_VALUE dependencies on HZ_LOCATIONS

Line 6140: HZ_LOCATIONS LOC,

6136:
6137: FROM
6138: HZ_CUST_SITE_USES_All SITE,
6139: HZ_PARTY_SITES PARTY_SITE,
6140: HZ_LOCATIONS LOC,
6141: HZ_CUST_ACCT_SITES ACCT_SITE
6142: WHERE
6143: SITE.SITE_USE_CODE = 'SOLD_TO'
6144: AND SITE.SITE_USE_ID = p_sold_to_site_use_id

Line 6563: hz_locations loc,

6559: ,x_end_customer_state
6560: ,x_end_customer_postal_code
6561: ,x_end_customer_country
6562: FROM
6563: hz_locations loc,
6564: hz_party_sites site,
6565: hz_cust_site_uses_all site_use,
6566: hz_cust_acct_sites acct_site
6567: WHERE