APPS.OE_BULK_VALUE_TO_ID dependencies on OE_CONTACTS_V

Line 28: FROM OE_CONTACTS_V CON

24: BEGIN
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

Line 318: FROM OE_CONTACTS_V

314: END IF;
315:
316: SELECT CONTACT_ID
317: INTO l_id
318: FROM OE_CONTACTS_V
319: WHERE NAME = p_end_customer_contact
320: AND CUSTOMER_ID = p_end_customer_id;
321:
322: RETURN l_id;

Line 827: FROM OE_CONTACTS_V b

823: (SELECT DISTINCT b.CONTACT_ID,
824: DECODE(b.CONTACT_ID,NULL,'Y',NULL),
825: DECODE(b.CONTACT_ID,NULL,
826: c.ATTRIBUTE_STATUS||'016',c.ATTRIBUTE_STATUS)
827: FROM OE_CONTACTS_V b
828: WHERE c.SOLD_TO_CONTACT = b.NAME(+)
829: AND c.SOLD_TO_ORG_ID = b.CUSTOMER_ID(+)
830: )
831: WHERE c.batch_id = p_batch_id