APPS.POA_EDW_GEOGRAPHY_M_SIZE dependencies on PO_VENDOR_SITES_ALL

Line 17: po_vendor_sites_all vns

13: from (
14: select count(*) cnt
15: from
16: po_vendors vnd,
17: po_vendor_sites_all vns
18: WHERE vns.vendor_id = vnd.vendor_id
19: and greatest(vns.last_update_date, vnd.last_update_date)
20: between p_from_date and p_to_date
21: union all

Line 145: from po_vendor_sites_all where last_update_date

141: avg(nvl(vsize(zip),0)),
142: avg(nvl(vsize(province),0)),
143: avg(nvl(vsize(country),0)),
144: avg(nvl(vsize(vendor_site_code),0))
145: from po_vendor_sites_all where last_update_date
146: between p_from_date and p_to_date;
147:
148: cursor c2 is
149: select avg(nvl(vsize(location_id),0)),