General Ledger - EBS (MOSC)

MOSC Banner

GL_MC_REPORTING_OPTIONS obsolete in R12

edited Apr 15, 2013 12:09AM in General Ledger - EBS (MOSC) 1 commentAnswered
Hi All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center