APPS.POA_EDW_RCV_TXNS_F_SIZE dependencies on PO_HEADERS_ALL

Line 13: PO_HEADERS_ALL POH,

9: -- dbms_output.enable(100000);
10:
11: select count(*) into p_num_rows
12: from
13: PO_HEADERS_ALL POH,
14: PO_LINES_ALL POL,
15: PO_LINE_LOCATIONS_ALL PLL,
16: RCV_SHIPMENT_HEADERS RSH,
17: RCV_SHIPMENT_LINES RSL,

Line 190: from po_headers_all

186: avg(nvl(vsize(org_id), 0)),
187: avg(nvl(vsize(agent_id), 0)),
188: avg(nvl(vsize(currency_code), 0)),
189: avg(nvl(vsize(segment1), 0))
190: from po_headers_all
191: where last_update_date between
192: p_from_date and p_to_date;
193:
194: CURSOR c_5 IS