eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_SET_OF_BOOKS SQL Statements

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

Line: 27


       SELECT b.period_year year,
              SUBSTR(b.entered_period_name, 0, 2) quarter,
              TO_CHAR(p_input_date, 'MON') month
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 40


       SELECT b.period_name, b.period_num
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=month_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 49


       SELECT b.period_name, b.period_num
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 58


       SELECT b.period_name
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=year_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 139


       SELECT b.period_name
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          --AND b.period_type=month_type
          AND b.period_type=month_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 204


       SELECT b.period_name
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 266


       SELECT b.period_name year
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=year_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 331


       SELECT b.period_num period_num
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 395


      SELECT period_name
      FROM gl_periods
      WHERE end_date =( SELECT start_date -1
                        FROM gl_periods
                        WHERE period_name =p_name
                        AND period_set_name = default_calender)
      AND period_set_name = default_calender
      AND UPPER(period_type) =p_type;

Line: 462


       SELECT b.period_num period_num
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=month_type
          AND b.period_name =p_month;

Line: 526


       SELECT b.period_num period_num
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=month_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 592


       SELECT b.start_date
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=quarter_type
          AND TRUNC(v_date) >= TRUNC(b.start_date)
          AND TRUNC(v_date) <= TRUNC(b.end_date);

Line: 603


       SELECT b.start_date
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND TRUNC(v_date) >= TRUNC(b.start_date)
          AND TRUNC(v_date) <= TRUNC(b.end_date);

Line: 802


       SELECT b.start_date
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=year_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 813


       SELECT b.start_date
       FROM gl_periods b
       WHERE b.period_set_name = default_calender
          AND b.period_type=year_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 879


       SELECT b.start_date
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 890


       SELECT b.start_date
       FROM gl_periods b
       WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 958


       SELECT b.start_date
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=month_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 969


       SELECT b.start_date
       FROM gl_periods b
       WHERE b.period_set_name = default_calender
          AND b.period_type=month_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 1341


       SELECT b.end_date
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=month_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 1352


       SELECT b.end_date
       FROM gl_periods b
       WHERE b.period_set_name = default_calender
          AND b.period_type=month_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 1418


       SELECT b.end_date
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 1429


       SELECT b.end_date
       FROM gl_periods b
       WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 1495


       SELECT b.end_date
       FROM gl_sets_of_books a, gl_periods b
       WHERE a.set_of_books_id = (select set_of_books_id FROM
                                       ozf_sys_parameters_all WHERE org_id = p_org_id)
          AND b.period_set_name = a.period_set_name
          AND b.period_type=year_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 1506


       SELECT b.end_date
       FROM gl_periods b
       WHERE b.period_set_name = default_calender
          AND b.period_type=year_type
          AND TRUNC(p_input_date) >= TRUNC(b.start_date)
          AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line: 1572


       SELECT b.start_date
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=month_type
          AND b.period_name =p_period_name;

Line: 1580


       SELECT b.period_name period_name
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND TRUNC(l_start_date) >= TRUNC(b.start_date)
          AND TRUNC(l_start_date) <= TRUNC(b.end_date);

Line: 1655


       SELECT b.start_date
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=month_type
          AND b.period_name =p_period_name;

Line: 1663


       SELECT b.period_name period_name
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=year_type
          AND TRUNC(l_start_date) >= TRUNC(b.start_date)
          AND TRUNC(l_start_date) <= TRUNC(b.end_date);

Line: 1738


       SELECT b.start_date
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=quarter_type
          AND b.period_name =p_period_name;

Line: 1746


       SELECT b.period_name period_name
       FROM gl_periods b
          WHERE b.period_set_name = default_calender
          AND b.period_type=year_type
          AND TRUNC(l_start_date) >= TRUNC(b.start_date)
          AND TRUNC(l_start_date) <= TRUNC(b.end_date);