DBA Data[Home] [Help]

APPS.OPI_DBI_COGS_PKG dependencies on MTL_PARAMETERS

Line 1378: mtl_parameters mp,

1374: C_EURO_MISSING_AT_START, g_euro_start_date,
1375: conv.transaction_date) cogs_date,
1376: conv.f_currency_code func_currency_code
1377: FROM opi_dbi_cogsf_conv_rates conv,
1378: mtl_parameters mp,
1379: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1380: DISTINCT organization_id, trunc (cogs_date) cogs_date
1381: FROM opi_dbi_cogs_fstg) to_conv
1382: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine

Line 1400: mtl_parameters mp,

1396: C_EURO_MISSING_AT_START, g_euro_start_date,
1397: conv.transaction_date) cogs_date,
1398: conv.f_currency_code func_currency_code
1399: FROM opi_dbi_cogsf_conv_rates conv,
1400: mtl_parameters mp,
1401: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1402: DISTINCT organization_id, trunc (cogs_date) cogs_date
1403: FROM opi_dbi_cogs_fstg) to_conv
1404: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine

Line 1635: mtl_parameters mp,

1631: C_EURO_MISSING_AT_START, g_euro_start_date,
1632: conv.transaction_date) cogs_date,
1633: conv.f_currency_code func_currency_code
1634: FROM opi_dbi_cogsf_conv_rates conv,
1635: mtl_parameters mp,
1636: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1637: DISTINCT organization_id, trunc (cogs_date) cogs_date
1638: FROM opi_dbi_cogs_fstg) to_conv
1639: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine

Line 1656: mtl_parameters mp,

1652: C_EURO_MISSING_AT_START, g_euro_start_date,
1653: conv.transaction_date) cogs_date,
1654: conv.f_currency_code func_currency_code
1655: FROM opi_dbi_cogsf_conv_rates conv,
1656: mtl_parameters mp,
1657: (SELECT /*+ parallel (opi_dbi_cogs_fstg) */
1658: DISTINCT organization_id, trunc (cogs_date) cogs_date
1659: FROM opi_dbi_cogs_fstg) to_conv
1660: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine