APPS.POS_COMPARE_REVISIONS dependencies on PO_VENDOR_CONTACTS

Line 378: * PO_VENDOR_CONTACTS table.

374: * Resolves the supplier contact.
375: *
376: * ARGUMENTS
377: * p_vendor_contact_id Unique identifier for vendor in
378: * PO_VENDOR_CONTACTS table.
379: *
380: * NOTES
381: * Return NULL if no matching records were found.
382: *

Line 386: * Obtain name from PO_VENDOR_CONTACTS

382: *
383: * HISTORY
384: * 08-AUG-97 Nilo Paredes Created
385: * 22-SEP-97 Rami Haddad Return NULL if no values found.
386: * Obtain name from PO_VENDOR_CONTACTS
387: * table.
388: ********************************************************************/
389: FUNCTION get_vendor_contact( p_vendor_contact_id IN NUMBER )
390: RETURN VARCHAR2 AS

Line 404: FROM po_vendor_contacts

400: We need not join with vendor_site_id because first_name and last_name are the same for one contact id. */
401:
402: SELECT DECODE(last_name, NULL, NULL, last_name || ',' || first_name)
403: INTO v_full_name
404: FROM po_vendor_contacts
405: WHERE vendor_contact_id = p_vendor_contact_id
406: AND ROWNUM=1;
407:
408: RETURN v_full_name;