782: l_stmt_num := 46;
783:
784: select pod.quantity_ordered * (poll.price_override) + nvl(pod.nonrecoverable_tax,0)
785: into l_total_dist_amount
786: from po_line_locations_all poll,
787: po_distributions_all pod
788: where poll.po_header_id =pod.po_header_id
789: and poll.line_location_id =pod.line_location_id
790: and pod.po_distribution_id =l_loc_po_distribution_id;