APPS.OE_CNCL_VALUE_TO_ID dependencies on OE_CONTACTS_V

Line 255: FROM OE_CONTACTS_V CON

251: END IF;
252:
253: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
254: INTO l_id
255: FROM OE_CONTACTS_V CON
256: , HZ_CUST_ACCT_SITES ACCT_SITE
257: , HZ_CUST_SITE_USES_ALL SITE
258: WHERE CON.NAME = p_deliver_to_contact
259: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 814: FROM OE_CONTACTS_V CON

810: END IF;
811:
812: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
813: INTO l_id
814: FROM OE_CONTACTS_V CON
815: , HZ_CUST_ACCT_SITES ACCT_SITE
816: , HZ_CUST_SITE_USES_ALL SITE
817: WHERE CON.NAME = p_invoice_to_contact
818: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 1623: FROM OE_CONTACTS_V CON

1619:
1620:
1621: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
1622: INTO l_id
1623: FROM OE_CONTACTS_V CON
1624: , HZ_CUST_ACCT_SITES ACCT_SITE
1625: , HZ_CUST_SITE_USES_ALL SITE
1626: WHERE CON.NAME = p_ship_to_contact
1627: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 2081: FROM OE_CONTACTS_V CON

2077:
2078:
2079: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
2080: INTO l_id
2081: FROM OE_CONTACTS_V CON
2082: , HZ_CUST_ACCT_SITES ACCT_SITE
2083: , HZ_CUST_SITE_USES_ALL SITE
2084: WHERE CON.NAME = p_sold_to_contact
2085: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 5509: FROM OE_CONTACTS_V

5505: END IF;
5506:
5507: SELECT CONTACT_ID
5508: INTO l_id
5509: FROM OE_CONTACTS_V
5510: WHERE NAME = p_end_customer_contact
5511: AND CUSTOMER_ID = p_end_customer_id;
5512:
5513: RETURN l_id;