APPS.OPI_DBI_OPM_COGS_PKG dependencies on FII_CURRENCY

Line 234: ,fii_currency.get_global_rate_primary

230: ,MARGIN_OU_ID
231: ,sum(COGS_VAL_B)
232: ,max(COGS_DATE)
233: ,COGS_CURRENCY_CODE
234: ,fii_currency.get_global_rate_primary
235: (cogs_currency_code, max(cogs_date)) COGS_CONVERSION_RATE
236: ,SHIP_OU_ID
237: ,SELL_OU_ID
238: ,TURNS_COGS_FLAG

Line 373: ,fii_currency.get_global_rate_primary

369: ,MARGIN_OU_ID
370: ,sum(COGS_VAL_B)
371: ,max(COGS_DATE)
372: ,COGS_CURRENCY_CODE
373: ,fii_currency.get_global_rate_primary
374: (cogs_currency_code, max(cogs_date)) COGS_CONVERSION_RATE
375: ,SHIP_OU_ID
376: ,SELL_OU_ID
377: ,TURNS_COGS_FLAG

Line 664: fii_currency.get_global_rate_primary

660: pl.org_id margin_ou_id,
661: 'N' turns_cogs_flag,
662: trunc( max(aid.accounting_date)) cogs_date,
663: gsob.currency_code currency_code,
664: fii_currency.get_global_rate_primary
665: (gsob.currency_code, trunc( max(aid.accounting_date)) ) cogs_conversion_rate,
666: SUM( Nvl(aid.base_amount, aid.amount) ) cogs_val_b
667: FROM ap_invoice_distributions_all aid,
668: ap_invoices_all ai,

Line 796: , fii_currency.get_global_rate_primary

792: ,MARGIN_OU_ID
793: ,sum(COGS_VAL_B) COGS_VAL_B
794: ,max(COGS_DATE) COGS_DATE
795: ,COGS_CURRENCY_CODE
796: , fii_currency.get_global_rate_primary
797: (cogs_currency_code, max(cogs_date)) COGS_CONVERSION_RATE
798: ,SHIP_OU_ID
799: ,SELL_OU_ID
800: ,TURNS_COGS_FLAG

Line 971: ,fii_currency.get_global_rate_primary

967: ,MARGIN_OU_ID
968: ,sum(COGS_VAL_B) COGS_VAL_B
969: ,max(COGS_DATE) COGS_DATE
970: ,COGS_CURRENCY_CODE
971: ,fii_currency.get_global_rate_primary
972: (cogs_currency_code, max(cogs_date)) COGS_CONVERSION_RATE
973: ,SHIP_OU_ID
974: ,SELL_OU_ID
975: ,TURNS_COGS_FLAG

Line 1493: fii_currency.get_global_rate_primary(cogs_currency_code,cogs_date),

1489:
1490: IF l_empty_count > 0 THEN -- not empty, do a master update to remove missing rate
1491: UPDATE opi_dbi_cogs_stg
1492: SET cogs_conversion_rate =
1493: fii_currency.get_global_rate_primary(cogs_currency_code,cogs_date),
1494: last_update_date = Sysdate,
1495: last_updated_by = g_user_id,
1496: last_update_login = g_login_id
1497: WHERE NVL(cogs_conversion_rate,-99) < 0 ;