DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on PO_VENDOR_CONTACTS

Line 457: FROM ap_supplier_contacts apc,po_vendor_contacts pvc

453: SELECT apc.vendor_contact_id
454: ,apc.area_code||apc.phone phone_number
455: ,apc.email_address
456: ,decode(pvc.last_name,null,null,'','',pvc.last_name || ', ') || nvl(pvc.middle_name, '')|| ' '|| pvc.first_name AS Sup_contact_full_name
457: FROM ap_supplier_contacts apc,po_vendor_contacts pvc
458: WHERE apc.vendor_site_id = pvc.vendor_site_id
459: AND apc.vendor_contact_id = pvc.vendor_contact_id
460: AND NVL(pvc.inactive_date, SYSDATE +1) > SYSDATE
461: AND apc.vendor_site_id = p_supplier_site_id