Tuesday, 13 January 2015

To find SOBs set up in the instance :

SELECT   set_of_books_id,
         name sob_name,
         chart_of_accounts_id,
         chart_of_accounts_name,
         period_set_name calendar_period,
         accounted_period_type,
         user_period_type,
         currency_code
  FROM   gl_sets_of_books_v
 WHERE   set_of_books_id = 1
/

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete