APPS.OE_BULK_VALUE_TO_ID dependencies on HZ_CUST_SITE_USES

Line 30: , HZ_CUST_SITE_USES_ALL SITE

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
34: AND CON.STATUS = 'A'

Line 69: hz_cust_site_uses site_use

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
73: and site.location_id=loc.location_id

Line 99: hz_cust_site_uses site_use

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)
103: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =

Line 952: FROM HZ_CUST_SITE_USES_ALL SITE,

948: (SELECT SITE.SITE_USE_ID,
949: DECODE(SITE.SITE_USE_ID,null,'Y',null),
950: DECODE(SITE.SITE_USE_ID,null,d.ATTRIBUTE_STATUS||'014',d.ATTRIBUTE_STATUS)
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