APPS.POA_EDW_ALINES_F_SIZE dependencies on PO_HEADERS_ALL

Line 15: po_headers_all poh

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
19: and greatest(pol.last_update_date, poh.last_update_date)

Line 147: from PO_HEADERS_ALL

143: avg(nvl(vsize(user_hold_flag), 0)),
144: avg(nvl(vsize(confirming_order_flag), 0)),
145: avg(nvl(vsize(supply_agreement_flag), 0)),
146: avg(nvl(vsize(edi_processed_flag), 0))
147: from PO_HEADERS_ALL
148: where last_update_date between
149: p_from_date and p_to_date;
150:
151: --------