DBA Data[Home] [Help]

APPS.POA_EDW_TRD_PNTR_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 37: po_vendors

33: between p_from_date and p_to_date
34: union all
35: select count(*) cnt
36: from
37: po_vendors
38: where last_update_date between p_from_date and p_to_date
39: union all
40: select count(*) cnt
41: FROM hz_cust_accounts hzca,

Line 207: from po_vendors where last_update_date

203: avg(nvl(vsize(inspection_required_flag),0)),
204: avg(nvl(vsize(receipt_required_flag),0)),
205: avg(nvl(vsize(allow_substitute_receipts_flag),0)),
206: avg(nvl(vsize(allow_unordered_receipts_flag),0))
207: from po_vendors where last_update_date
208: between p_from_date and p_to_date;
209:
210: cursor c2 is
211: select avg(nvl(vsize(instance_code),0))