9:
10: -- dbms_output.enable(100000);
11:
12: select count(*) into p_num_rows
13: from po_headers_all
14: WHERE type_lookup_code in ('CONTRACT', 'BLANKET')
15: and approved_flag = 'Y'
16: and last_update_date between p_from_date and p_to_date;
17:
118: avg(nvl(vsize(segment1), 0)),
119: avg(nvl(vsize(rate), 0)),
120: avg(nvl(vsize(confirming_order_flag), 0)),
121: avg(nvl(vsize(edi_processed_flag), 0))
122: from PO_HEADERS_ALL
123: where last_update_date between
124: p_from_date and p_to_date;
125:
126: --------