12: select count(*) into p_num_rows
13: from
14: po_line_locations_all pll,
15: po_lines_all pol,
16: po_headers_all poh
17: WHERE pll.approved_flag = 'Y'
18: AND pll.shipment_type in ('BLANKET', 'SCHEDULED', 'STANDARD')
19: AND pll.po_line_id = pol.po_line_id
20: AND pll.po_header_id = poh.po_header_id
149: avg(nvl(vsize(org_id), 0)),
150: avg(nvl(vsize(terms_id), 0)),
151: avg(nvl(vsize(currency_code), 0)),
152: avg(nvl(vsize(segment1), 0))
153: from po_headers_all
154: where last_update_date between
155: p_from_date and p_to_date;
156:
157: CURSOR c_4 IS