APPS.POA_EDW_SUP_PERF_F_SIZE dependencies on PO_LINE_LOCATIONS_ALL

Line 14: po_line_locations_all pll,

10: -- dbms_output.enable(100000);
11:
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')

Line 142: from po_line_locations_all

138: avg(nvl(vsize(ship_to_organization_id), 0)),
139: avg(nvl(vsize(ship_to_location_id), 0)),
140: avg(nvl(vsize(closed_code), 0)),
141: avg(nvl(vsize(receive_close_tolerance), 0))
142: from po_line_locations_all
143: where last_update_date between
144: p_from_date and p_to_date;
145:
146: CURSOR c_3 IS