APPS.POA_EDW_PO_DIST_F_SIZE dependencies on PO_LINE_LOCATIONS_ALL

Line 15: po_line_locations_all pll,

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')
19: and pll.approved_flag = 'Y'

Line 234: from po_line_locations_all

230: avg(nvl(vsize(taxable_flag), 0)),
231: avg(nvl(vsize(cancel_reason), 0)),
232: avg(nvl(vsize(closed_reason), 0)),
233: avg(nvl(vsize(source_shipment_id), 0))
234: from po_line_locations_all
235: where last_update_date between
236: p_from_date and p_to_date;
237:
238: CURSOR c_4 IS