APPS.OE_BULK_VALUE_TO_ID dependencies on HZ_CUST_SITE_USES_ALL

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 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