DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on PO_TAX_SV

Line 558: (PLL.price_override + nvl(po_tax_sv.get_tax('PO',pod.po_distribution_id),0)/pod.quantity_ordered) *

554: set usage_rate_or_amount =
555: (SELECT (SUM(
556: (POD.quantity_ordered - NVL(POD.quantity_delivered,0)) *
557: (
558: (PLL.price_override + nvl(po_tax_sv.get_tax('PO',pod.po_distribution_id),0)/pod.quantity_ordered) *
559: --modified for GP currency conversion
560: DECODE(po_cur.po_currency,rcvcur.currency_code, NVL(POD.rate,1),
561: NVL(gl_currency_api.get_rate(po_cur.po_currency, rcvcur.currency_code, NVL(pod.rate_Date,TRUNC(SYSDATE)), psp.default_rate_type),1))
562: )