DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on AP_SUPPLIER_CONTACTS

Line 635: FROM ap_supplier_contacts apc,po_vendor_contacts pvc

631: SELECT apc.vendor_contact_id
632: ,apc.area_code||apc.phone phone_number
633: ,apc.email_address
634: ,decode(pvc.last_name,null,null,'','',pvc.last_name || ', ') || nvl(pvc.middle_name, '')|| ' '|| pvc.first_name AS Sup_contact_full_name
635: FROM ap_supplier_contacts apc,po_vendor_contacts pvc
636: WHERE apc.vendor_site_id = pvc.vendor_site_id
637: AND apc.vendor_contact_id = pvc.vendor_contact_id
638: AND NVL(pvc.inactive_date, SYSDATE +1) > SYSDATE
639: AND apc.vendor_site_id = p_supplier_site_id