DBA Data[Home] [Help]

APPS.CLN_RN_UTILS dependencies on PO_VENDOR_SITES_ALL

Line 420: FROM po_vendors pv, po_vendor_sites_all pvsa

416: IF (l_party_type = 'S') THEN
417: SELECT pv.vendor_name, pvsa.area_code || ' ' || pvsa.phone, pvsa.fax_area_code || ' ' || pvsa.fax,
418: pvsa.ece_tp_location_code, pvsa.email_address
419: INTO x_name, x_telephone, x_fax, x_ece_location_code, x_email
420: FROM po_vendors pv, po_vendor_sites_all pvsa
421: WHERE pv.vendor_id = pvsa.vendor_id
422: AND pv.vendor_id = l_party_id
423: AND pvsa.vendor_site_id = l_party_site_id;
424: ELSIF (l_party_type = 'B') THEN