APPS.PO_AUTOCREATE_DOC dependencies on PO_SUPPLIER_SITES_VAL_V

Line 1392: --instead of po_supplier_sites_val_v.

1388: begin
1389:
1390: --
1391: --Changed the query to go against po_vendor_sites_all
1392: --instead of po_supplier_sites_val_v.
1393: select 'Y',
1394: vendor_site_code
1395: into x_valid_vendor_site,
1396: x_vendor_site

Line 1433: from po_supplier_sites_val_v

1429: select 'Y',
1430: vendor_site_id
1431: into x_valid_vendor_site,
1432: x_vendor_site_id
1433: from po_supplier_sites_val_v
1434: where vendor_id = x_vendor_id
1435: and vendor_site_code = x_suggested_vendor_site;
1436: exception
1437: when NO_DATA_FOUND then