APPS.POA_EDW_SUPPERF dependencies on PO_HEADERS_ALL

Line 124: po_headers_all poh

120: select SUM(aid.base_invoice_price_variance / nvl(pod.rate,nvl(poh.rate,1)))
121: into v_ipv
122: from po_distributions_all pod,
123: ap_invoice_distributions_all aid,
124: po_headers_all poh
125: where p_line_location_id = pod.line_location_id
126: AND aid.po_distribution_id = pod.po_distribution_id
127: AND poh.po_header_id = pod.po_header_id
128: AND nvl(pod.distribution_type,'-99') <> 'AGREEMENT';

Line 743: FROM po_headers_all poh,

739: SELECT pol.item_id, pol.unit_meas_lookup_code, poh.currency_code,
740: pll.approved_date, pll.quantity, pll.need_by_date, pll.creation_date INTO
741: v_item_id, v_unit_meas_lookup_code, v_currency_code,
742: v_approved_date, v_quantity, v_need_by_date, v_creation_date
743: FROM po_headers_all poh,
744: po_lines_all pol,
745: po_line_locations_all pll
746: WHERE pll.line_location_id = p_line_location_id
747: AND pll.po_line_id = pol.po_line_id

Line 777: po_headers_all poh,

773: DECODE(pll.shipment_type, 'PRICE BREAK', pll.price_override, 'PLANNED', pll.price_override, pol.unit_price))))
774: lowest_price
775: FROM gl_sets_of_books gsob,
776: financials_system_params_all fsp,
777: po_headers_all poh,
778: po_lines_all pol,
779: po_line_locations_all pll
780: WHERE pol.item_id = v_item_id
781: AND pol.unit_meas_lookup_code = v_unit_meas_lookup_code