1 Reply Latest reply: May 23, 2012 12:32 AM by Vamsi Kasina Branched to a new discussion. RSS

    REPORTING CURRENCY CODE COLUMN NOT PRESENT

    898107
      Hi All,

      I Need to change one query becuase gl_mc_reporting_options table has been dropped in R12.I actally I am using GL_LEDGER_RELATIONSHIPS corrsponding table.

      But problem is Reporting_currency_code column not there in GL_LEDGER_RELATIONSHIPS table.Please kindly help me to change query.

      SELECT currency_code
      FROM gl_sets_of_books
      WHERE set_of_books_id =:$PROFILES$.gl_set_of_bks_id
      AND NOT EXISTS
      (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
      AND gmro1.enabled_flag = 'Y'
      AND gmro1.application_id = 222
      AND gmro1.primary_set_of_books_id =:$PROFILES$.gl_set_of_bks_id
      AND gmro1.primary_set_of_books_id =gmro2.primary_set_of_books_id
      )

      gl_mc_reporting_options gmro table has been dropped.

      Regards,
      Basavaraj

      Edited by: Basavaraj on Nov 24, 2011 12:50 AM