APPS.OE_ID_TO_VALUE dependencies on OE_CONTACTS_V

Line 486: FROM OE_CONTACTS_V

482: IF p_deliver_to_contact_id IS NOT NULL THEN
483:
484: SELECT NAME
485: INTO l_deliver_to_contact
486: FROM OE_CONTACTS_V
487: WHERE CONTACT_ID = p_deliver_to_contact_id;
488:
489: END IF;
490:

Line 790: FROM OE_CONTACTS_V

786: IF p_intermed_ship_to_contact_id IS NOT NULL THEN
787:
788: SELECT NAME
789: INTO l_intermed_ship_to_contact
790: FROM OE_CONTACTS_V
791: WHERE CONTACT_ID = p_intermed_ship_to_contact_id;
792:
793: END IF;
794:

Line 936: FROM OE_CONTACTS_V

932: IF p_invoice_to_contact_id IS NOT NULL THEN
933:
934: SELECT NAME
935: INTO l_invoice_to_contact
936: FROM OE_CONTACTS_V
937: WHERE CONTACT_ID = p_invoice_to_contact_id;
938:
939: END IF;
940:

Line 1570: FROM OE_CONTACTS_V

1566: IF p_ship_to_contact_id IS NOT NULL THEN
1567:
1568: SELECT NAME
1569: INTO l_ship_to_contact
1570: FROM OE_CONTACTS_V
1571: WHERE CONTACT_ID = p_ship_to_contact_id;
1572:
1573: END IF;
1574:

Line 1717: FROM OE_CONTACTS_V

1713: IF p_sold_to_contact_id IS NOT NULL THEN
1714:
1715: SELECT NAME
1716: INTO l_sold_to_contact
1717: FROM OE_CONTACTS_V
1718: WHERE CONTACT_ID = p_sold_to_contact_id;
1719:
1720: END IF;
1721:

Line 6425: FROM OE_CONTACTS_V

6421: IF p_end_customer_contact_id IS NOT NULL THEN
6422:
6423: SELECT NAME
6424: INTO l_end_customer_contact
6425: FROM OE_CONTACTS_V
6426: WHERE CONTACT_ID = p_end_customer_contact_id;
6427:
6428: END IF;
6429: