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.HR_TEMPLATE_TAB_PAGE_INFO SQL Statements

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

Line: 17


    SELECT ttp.template_tab_page_id
          ,ftp.tab_page_name
          ,fcn.canvas_name
          ,ftp.display_order
          ,tpt.label
          ,tpp.navigation_direction
          ,tpp.visible
          ,tpp.information_category
          ,tpp.information1
          ,tpp.information2
          ,tpp.information3
          ,tpp.information4
          ,tpp.information5
          ,tpp.information6
          ,tpp.information7
          ,tpp.information8
          ,tpp.information9
          ,tpp.information10
          ,tpp.information11
          ,tpp.information12
          ,tpp.information13
          ,tpp.information14
          ,tpp.information15
          ,tpp.information16
          ,tpp.information17
          ,tpp.information18
          ,tpp.information19
          ,tpp.information20
          ,tpp.information21
          ,tpp.information22
          ,tpp.information23
          ,tpp.information24
          ,tpp.information25
          ,tpp.information26
          ,tpp.information27
          ,tpp.information28
          ,tpp.information29
          ,tpp.information30
      FROM hr_tab_page_properties_tl tpt
          ,hr_tab_page_properties_b tpp
          ,hr_template_tab_pages_b ttp
          ,hr_template_canvases_b tcn
          ,hr_template_windows_b twn
          ,hr_form_canvases_b fcn
          ,hr_form_tab_pages_b ftp
     WHERE tpt.language (+) = userenv('LANG')
       AND tpt.tab_page_property_id (+) = tpp.tab_page_property_id
       AND tpp.template_tab_page_id (+) = ttp.template_tab_page_id
       AND ttp.form_tab_page_id (+) = p_form_tab_page_id
       AND ttp.template_canvas_id (+) = tcn.template_canvas_id
       AND tcn.template_window_id (+) = twn.template_window_id
       AND twn.form_template_id (+) = p_form_template_id
       AND fcn.form_canvas_id = ftp.form_canvas_id
       AND ftp.form_tab_page_id = p_form_tab_page_id
  ORDER BY ttp.template_tab_page_id;