APPS.POA_EDW_PO_DIST_F_SIZE dependencies on PO_DISTRIBUTIONS_ALL

Line 14: po_distributions_all pod,

10: -- dbms_output.enable(100000);
11:
12: select count(*) into p_num_rows
13: from
14: po_distributions_all pod,
15: po_line_locations_all pll,
16: po_lines_all pol,
17: po_headers_all poh
18: WHERE pll.shipment_type in ('BLANKET', 'SCHEDULED', 'STANDARD')

Line 199: from po_distributions_all

195: avg(nvl(vsize(po_header_id), 0)),
196: avg(nvl(vsize(po_line_id), 0)),
197: avg(nvl(vsize(po_release_id), 0)),
198: avg(nvl(vsize(source_distribution_id), 0))
199: from po_distributions_all
200: where last_update_date between
201: p_from_date and p_to_date;
202:
203: CURSOR c_2 IS