DBA Data[Home] [Help]

APPS.POA_EDW_GEOGRAPHY_M_SIZE dependencies on PO_VENDORS

Line 16: po_vendors vnd,

12: select sum(cnt) into p_num_rows
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

Line 188: from po_vendors where last_update_date

184: between p_from_date and p_to_date;
185:
186: cursor c6 is
187: select avg(nvl(vsize(vendor_name), 0))
188: from po_vendors where last_update_date
189: between p_from_date and p_to_date;
190:
191:
192: BEGIN