APPS.OE_CNCL_VALUE_TO_ID dependencies on HZ_PARTY_SITES

Line 5370: HZ_PARTY_SITES PARTY_SITE,

5366: SELECT /* MOAC_SQL_CHANGE */ SITE.SITE_USE_ID
5367: INTO l_id
5368: FROM
5369: HZ_CUST_SITE_USES_ALL SITE,
5370: HZ_PARTY_SITES PARTY_SITE,
5371: HZ_LOCATIONS LOC,
5372: HZ_CUST_ACCT_SITES ACCT_SITE
5373: WHERE
5374: SITE.SITE_USE_CODE = 'SOLD_TO'

Line 5565: hz_party_sites site,

5561: -- cursor to get the site_id for end_customer
5562: CURSOR c_site_use_id(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
5563: SELECT site_use.site_use_id
5564: FROM hz_locations loc,
5565: hz_party_sites site,
5566: hz_cust_acct_sites acct_site,
5567: hz_cust_site_uses site_use
5568: WHERE
5569: site_use.cust_acct_site_id=acct_site.cust_acct_site_id

Line 5595: hz_party_sites site,

5591:
5592: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
5593: SELECT site_use.site_use_id
5594: FROM hz_locations loc,
5595: hz_party_sites site,
5596: hz_cust_acct_sites acct_site,
5597: hz_cust_site_uses site_use
5598: WHERE loc.ADDRESS1 = p_end_customer_site_address1
5599: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =