DBA Data[Home] [Help]

APPS.CS_REPORTS_PACKAGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

      SELECT sob.name
      FROM   gl_sets_of_books sob
      WHERE  sob.set_of_books_id = p_sob_id;
Line: 25

   SELECT cp.user_concurrent_program_name
   FROM   FND_CONCURRENT_PROGRAMS_VL cp,
          FND_CONCURRENT_REQUESTS cr
   WHERE  cr.request_id            = p_conc_request_id
     AND  cp.application_id        = cr.program_application_id
     AND  cp.concurrent_program_id = cr.concurrent_program_id;
Line: 45

   SELECT structure_id
   FROM   mtl_default_sets_view
   WHERE  functional_area_id = 2 ;