DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_SCRAP_INIT_PKG dependencies on MTL_PARAMETERS

Line 865: mtl_parameters mp,

861: EURO_MISSING_AT_START, EURO_START_DATE,
862: conv.transaction_date) transaction_date,
863: conv.base_currency_code func_currency_code
864: FROM opi_dbi_wip_scrap_conv_rates conv,
865: mtl_parameters mp,
866: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
867: DISTINCT organization_id, transaction_date
868: FROM opi_dbi_wip_scrap_stg) to_conv
869: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine

Line 886: mtl_parameters mp,

882: EURO_MISSING_AT_START, EURO_START_DATE,
883: conv.transaction_date) transaction_date_date,
884: conv.base_currency_code func_currency_code
885: FROM opi_dbi_wip_scrap_conv_rates conv,
886: mtl_parameters mp,
887: (SELECT /*+ index_ffs(opi_dbi_wip_scrap_stg) */
888: DISTINCT organization_id, transaction_date
889: FROM opi_dbi_wip_scrap_stg) to_conv
890: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine