DBA Data[Home] [Help]

APPS.POA_EDW_TRD_PNTR_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 281: from po_vendor_sites_all where last_update_date

277: avg(nvl(vsize(vendor_site_code),0)),
278: avg(nvl(vsize(purchasing_site_flag),0)),
279: avg(nvl(vsize(rfq_only_site_flag),0)),
280: avg(nvl(vsize(pay_site_flag),0))
281: from po_vendor_sites_all where last_update_date
282: between p_from_date and p_to_date;
283:
284: cursor c9 is
285: select avg(nvl(vsize(site_use_code),0)),