APPS.OE_VALUE_TO_ID dependencies on OE_CONTACTS_V

Line 455: FROM OE_CONTACTS_V CON

451: END IF;
452:
453: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
454: INTO l_id
455: FROM OE_CONTACTS_V CON
456: , HZ_ROLE_RESPONSIBILITY ROL
457: , HZ_CUST_ACCT_SITES ADDR
458: , HZ_CUST_SITE_USES_ALL SU
459: WHERE CON.NAME = p_deliver_to_contact

Line 1131: FROM OE_CONTACTS_V CON

1127: l_usage := 'BILL_TO';
1128:
1129: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
1130: INTO l_id
1131: FROM OE_CONTACTS_V CON
1132: , HZ_ROLE_RESPONSIBILITY ROL
1133: , HZ_CUST_ACCT_SITES ADDR
1134: , HZ_CUST_SITE_USES_ALL SU
1135: WHERE CON.NAME = p_invoice_to_contact

Line 1989: FROM OE_CONTACTS_V CON

1985: l_usage := 'SHIP_TO';
1986:
1987: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
1988: INTO l_id
1989: FROM OE_CONTACTS_V CON
1990: , HZ_ROLE_RESPONSIBILITY ROL
1991: , HZ_CUST_ACCT_SITES ADDR
1992: , HZ_CUST_SITE_USES_ALL SU
1993: WHERE CON.NAME = p_ship_to_contact

Line 2469: FROM OE_CONTACTS_V

2465: END IF;
2466:
2467: SELECT CONTACT_ID
2468: INTO l_id
2469: FROM OE_CONTACTS_V
2470: WHERE NAME = p_sold_to_contact
2471: AND CUSTOMER_ID = p_sold_to_org_id
2472: AND STATUS ='A' /*bug 6711184*/
2473: AND ROWNUM=1; /*bug 6711184*/

Line 6383: FROM OE_CONTACTS_V

6379: END IF;
6380:
6381: SELECT CONTACT_ID
6382: INTO l_id
6383: FROM OE_CONTACTS_V
6384: WHERE NAME = p_end_customer_contact
6385: AND CUSTOMER_ID = p_end_customer_id;
6386:
6387: RETURN l_id;