[Home] [Help]
137: STATE || ' '||
138: ZIP || ' '||
139: PROVINCE || ' '||
140: COUNTRY AS Address
141: FROM PO_VENDOR_SITES_ALL
142: WHERE VENDOR_ID = a_vendor_id
143: AND VENDOR_SITE_ID = a_vendor_site_id;
144:
145: CURSOR contact_csr (a_vendor_contact_id NUMBER)