APPS.POA_EDW_SUP_PERF_F_SIZE dependencies on PO_LINES_ALL

Line 15: po_lines_all pol,

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')
19: AND pll.po_line_id = pol.po_line_id

Line 132: from po_lines_all

128: avg(nvl(vsize(item_description), 0)),
129: avg(nvl(vsize(category_id), 0)),
130: avg(nvl(vsize(price_type_lookup_code), 0)),
131: avg(nvl(vsize(contract_num), 0))
132: from po_lines_all
133: where last_update_date between
134: p_from_date and p_to_date;
135:
136: CURSOR c_2 IS