DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_COMP_INIT_PKG dependencies on MTL_PARAMETERS

Line 904: mtl_parameters mp,

900: EURO_MISSING_AT_START, EURO_START_DATE,
901: conv.transaction_date) transaction_date,
902: conv.base_currency_code func_currency_code
903: FROM opi_dbi_wip_comp_conv_rates conv,
904: mtl_parameters mp,
905: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
906: DISTINCT organization_id, transaction_date
907: FROM opi_dbi_wip_comp_stg) to_conv
908: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine

Line 925: mtl_parameters mp,

921: EURO_MISSING_AT_START, EURO_START_DATE,
922: conv.transaction_date) transaction_date_date,
923: conv.base_currency_code func_currency_code
924: FROM opi_dbi_wip_comp_conv_rates conv,
925: mtl_parameters mp,
926: (SELECT /*+ index_ffs(opi_dbi_wip_comp_stg) */
927: DISTINCT organization_id, transaction_date
928: FROM opi_dbi_wip_comp_stg) to_conv
929: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine