APPS.POA_EDW_PO_DIST_F_SIZE dependencies on PO_LINES_ALL

Line 16: po_lines_all pol,

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'
20: and pll.line_location_id = pod.line_location_id

Line 215: from po_lines_all

211: avg(nvl(vsize(negotiated_by_preparer_flag), 0)),
212: avg(nvl(vsize(item_description), 0)),
213: avg(nvl(vsize(note_to_vendor), 0)),
214: avg(nvl(vsize(contract_num), 0))
215: from po_lines_all
216: where last_update_date between
217: p_from_date and p_to_date;
218:
219: CURSOR c_3 IS