DBA Data[Home] [Help]

APPS.OE_ID_TO_VALUE dependencies on HZ_LOCATIONS

Line 6114: HZ_LOCATIONS LOC,

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'
6118: AND SITE.SITE_USE_ID = p_sold_to_site_use_id

Line 6537: hz_locations loc,

6533: ,x_end_customer_state
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