APPS.PO_COMPARE_REVISIONS dependencies on PO_VENDOR_CONTACTS

Line 321: * PO_VENDOR_CONTACTS table.

317: * Resolves the supplier contact.
318: *
319: * ARGUMENTS
320: * p_vendor_contact_id Unique identifier for vendor in
321: * PO_VENDOR_CONTACTS table.
322: *
323: * NOTES
324: * Return NULL if no matching records were found.
325: *

Line 329: * Obtain name from PO_VENDOR_CONTACTS

325: *
326: * HISTORY
327: * 08-AUG-97 Nilo Paredes Created
328: * 22-SEP-97 Rami Haddad Return NULL if no values found.
329: * Obtain name from PO_VENDOR_CONTACTS
330: * table.
331: ********************************************************************/
332: FUNCTION get_vendor_contact( p_vendor_contact_id IN NUMBER )
333: RETURN VARCHAR2 AS

Line 347: FROM po_vendor_contacts

343: --We need not join with vendor_site_id because first_name and last_name are the same for one contact id.
344:
345: SELECT DISTINCT DECODE(last_name, NULL, NULL, last_name || ',' || first_name)
346: INTO v_full_name
347: FROM po_vendor_contacts
348: WHERE vendor_contact_id = p_vendor_contact_id;
349:
350: RETURN v_full_name;
351: