DBA Data[Home] [Help]

APPS.POA_EDW_SUPPERF dependencies on GL_CURRENCY_API

Line 762: gl_currency_api.convert_amount_sql(

758: 'User',
759: DECODE(gsob.currency_code,
760: v_currency_code,
761: poh.rate * DECODE(pll.shipment_type, 'PRICE BREAK', pll.price_override, 'PLANNED', pll.price_override, pol.unit_price),
762: gl_currency_api.convert_amount_sql(
763: gsob.currency_code,
764: v_currency_code,
765: NVL(poh.rate_date, pll.creation_date),
766: NULL,

Line 768: gl_currency_api.convert_amount_sql(

764: v_currency_code,
765: NVL(poh.rate_date, pll.creation_date),
766: NULL,
767: poh.rate * DECODE(pll.shipment_type, 'PRICE BREAK', pll.price_override, 'PLANNED', pll.price_override, pol.unit_price))),
768: gl_currency_api.convert_amount_sql(
769: poh.currency_code,
770: v_currency_code,
771: NVL(poh.rate_date, pll.creation_date),
772: poh.rate_type,