PR
select sum (nvl(recoverable_tax,0)+nvl(nonrecoverable_tax,0))
from po_req_distributions_all
where requisition_line_id = p_pr
PO
select sum (nvl(recoverable_tax,0)+nvl(nonrecoverable_tax,0))
from po_distributions_all
where po_header_id = p_po
Amount PR
select sum(unit_price*quantity + get_tax_pr(requisition_line_id))
from po_requisition_lines_all
where requisition_header_id = p_pr;
Amount PO
select (zl.unit_price*zl.tax_rate)/100
from zx_lines zl
where zl.internal_organization_id = p_org
and zl.trx_id = p_po_no
and zl.trx_line_id = (select pll.line_location_id
from
po_lines_all pod, po_line_locations_all pll
where
pod.po_line_id = pll.po_line_id(+)
and
pod.org_id= pll.org_id(+)
and
pod.po_header_id = zl.trx_id
and
pod.po_line_id = p_po_line
and rownum =
'1');
