APPS.OE_BULK_VALUE_TO_ID dependencies on HZ_CUST_ACCT_SITES

Line 29: , HZ_CUST_ACCT_SITES CAS

25:
26: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
27: INTO l_id
28: FROM OE_CONTACTS_V CON
29: , HZ_CUST_ACCT_SITES CAS
30: , HZ_CUST_SITE_USES_ALL SITE
31: WHERE CON.NAME = p_contact
32: AND CON.CUSTOMER_ID = CAS.CUST_ACCOUNT_ID
33: AND CAS.CUST_ACCT_SITE_ID = SITE.CUST_ACCT_SITE_ID

Line 68: hz_cust_acct_sites acct_site,

64: CURSOR c_site_use_id(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
65: SELECT site_use.site_use_id
66: FROM hz_locations loc,
67: hz_party_sites site,
68: hz_cust_acct_sites acct_site,
69: hz_cust_site_uses site_use
70: WHERE
71: site_use.cust_acct_site_id=acct_site.cust_acct_site_id
72: and acct_site.party_site_id=site.party_site_id

Line 98: hz_cust_acct_sites acct_site,

94: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
95: SELECT site_use.site_use_id
96: FROM hz_locations loc,
97: hz_party_sites site,
98: hz_cust_acct_sites acct_site,
99: hz_cust_site_uses site_use
100: WHERE loc.ADDRESS1 = p_end_customer_site_address1
101: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
102: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)

Line 955: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,

951:
952: FROM HZ_CUST_SITE_USES_ALL SITE,
953: HZ_PARTY_SITES PARTY_SITE,
954: HZ_LOCATIONS LOC,
955: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
956: OE_HEADERS_IFACE_ALL d
957:
958: WHERE SITE.SITE_USE_CODE ='SOLD_TO'
959: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID