DBA Data[Home] [Help]

APPS.OE_ID_TO_VALUE dependencies on HZ_PARTY_SITES

Line 6139: HZ_PARTY_SITES PARTY_SITE,

6135: , x_sold_to_location_country
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'

Line 6564: hz_party_sites site,

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
6568: site_use.site_use_id= p_end_customer_site_use_id