APPS.PO_AUTOCREATE_DOC dependencies on PO_SUPPLIER_SITES_VAL_V

Line 1191: --instead of po_supplier_sites_val_v.

1187: begin
1188:
1189: --
1190: --Changed the query to go against po_vendor_sites_all
1191: --instead of po_supplier_sites_val_v.
1192: select 'Y',
1193: vendor_site_code
1194: into x_valid_vendor_site,
1195: x_vendor_site

Line 1232: from po_supplier_sites_val_v

1228: select 'Y',
1229: vendor_site_id
1230: into x_valid_vendor_site,
1231: x_vendor_site_id
1232: from po_supplier_sites_val_v
1233: where vendor_id = x_vendor_id
1234: and vendor_site_code = x_suggested_vendor_site;
1235: exception
1236: when NO_DATA_FOUND then