APPS.POA_EDW_PO_DIST_F_SIZE dependencies on PO_HEADERS_ALL

Line 17: po_headers_all poh

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
21: and pod.po_line_id = pol.po_line_id

Line 259: from po_headers_all

255: avg(nvl(vsize(comments), 0)),
256: avg(nvl(vsize(note_to_receiver), 0)),
257: avg(nvl(vsize(revision_num), 0)),
258: avg(nvl(vsize(segment1), 0))
259: from po_headers_all
260: where last_update_date between
261: p_from_date and p_to_date;
262:
263: CURSOR c_5 IS