APPS.OE_VALUE_TO_ID dependencies on HZ_PARTY_SITES

Line 6137: HZ_PARTY_SITES PARTY_SITE,

6133: SELECT /* MOAC_SQL_CHANGE */ SITE.SITE_USE_ID
6134: INTO l_id
6135: FROM
6136: HZ_CUST_SITE_USES SITE,
6137: HZ_PARTY_SITES PARTY_SITE,
6138: HZ_LOCATIONS LOC,
6139: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
6140: WHERE
6141: SITE.SITE_USE_CODE = 'SOLD_TO'

Line 6439: hz_party_sites site,

6435: -- cursor to get the site_id for end_customer
6436: CURSOR c_site_use_id(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS --Changed datatype to VARCHAR2 for bug16474566
6437: SELECT /* MOAC_SQL_CHANGE */ site_use.site_use_id
6438: FROM hz_locations loc,
6439: hz_party_sites site,
6440: hz_cust_acct_sites_all acct_site,
6441: hz_cust_site_uses site_use
6442: WHERE
6443: site_use.cust_acct_site_id=acct_site.cust_acct_site_id

Line 6470: hz_party_sites site,

6466:
6467: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS --Changed datatype to VARCHAR2 for bug16474566
6468: SELECT /* MOAC_SQL_CHANGE */ site_use.site_use_id
6469: FROM hz_locations loc,
6470: hz_party_sites site,
6471: hz_cust_acct_sites_all acct_site,
6472: hz_cust_site_uses site_use
6473: WHERE loc.ADDRESS1 = p_end_customer_site_address1
6474: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =