DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on PO_TAX_SV

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

506:
507: UPDATE cst_open_pos_temp COPT
508: set usage_rate_or_amount =
509: (SELECT (SUM((POD.quantity_ordered - NVL(POD.quantity_delivered,0)) *
510: (PLL.price_override + nvl(po_tax_sv.get_tax('PO',pod.po_distribution_id),0)/pod.quantity_ordered) *
511: NVL(POD.rate,1)) /
512: decode(SUM((POD.quantity_ordered - NVL(POD.quantity_delivered,0)) *
513: UOM.conversion_rate), 0, 1,
514: SUM((POD.quantity_ordered - NVL(POD.quantity_delivered,0)) *