GL_MC_REPORTING_OPTIONS obsolete in R12
We have a query which uses the GL_MC_REPORTING_OPTIONS table and have found that this table is obsolete in R12. It would be a help if someone can let us know what could be the replacement. I have mentioned the query below
select 'x'
from gl_mc_reporting_options gmro1, gl_mc_reporting_options gmro2
where (gmro1.primary_currency_code = gmro2.reporting_currency_code OR
gmro1.reporting_currency_code =
gmro2.reporting_currency_code)
and gmro1.enabled_flag = gmro2.enabled_flag
and gmro1.application_id = gmro2.application_id
and gmro1.reporting_option_id <> gmro2.reporting_option_id