APPS.POA_EDW_ALINES_F_SIZE dependencies on PO_LINES_ALL

Line 14: po_lines_all pol,

10: -- dbms_output.enable(100000);
11:
12: select count(*) into p_num_rows
13: from
14: po_lines_all pol,
15: po_headers_all poh
16: WHERE poh.type_lookup_code = 'BLANKET'
17: and poh.approved_flag = 'Y'
18: and poh.po_header_id = pol.po_header_id

Line 170: from PO_LINES_ALL

166: avg(nvl(vsize(po_header_id), 0)),
167: avg(nvl(vsize(po_line_id), 0)),
168: avg(nvl(vsize(note_to_vendor), 0)),
169: avg(nvl(vsize(cancel_reason), 0))
170: from PO_LINES_ALL
171: where last_update_date between
172: p_from_date and p_to_date;
173:
174: --------