DBA Data[Home] [Help]

APPS.CSTPMECS dependencies on GL_CURRENCY_API

Line 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))

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: )
563: ) /
564: decode(SUM((POD.quantity_ordered - NVL(POD.quantity_delivered,0)) *
565: UOM.conversion_rate), 0, 1,