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
22: and pod.po_header_id = poh.po_header_id