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_FORM_TAB_PAGE_INFO SQL Statements

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

Line: 26


    SELECT ftp.form_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_form_tab_pages_b ftp
          ,hr_form_canvases_b fcn
          ,hr_form_windows_b fwn
     WHERE tpt.language = userenv('LANG')
       AND tpt.tab_page_property_id = tpp.tab_page_property_id
       AND tpp.form_tab_page_id = ftp.form_tab_page_id
       AND ftp.form_canvas_id = fcn.form_canvas_id
       AND fcn.form_window_id = fwn.form_window_id
       AND fwn.application_id = p_application_id
       AND fwn.form_id = p_form_id;