DBA Data[Home] [Help]

APPS.HR_TEMPLATE_CANVAS_INFO SQL Statements

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

Line: 17

    SELECT tcn.template_canvas_id
          ,fcn.canvas_name
          ,fcn.canvas_type
          ,fwn.window_name
          ,cnp.height
          ,cnp.visible
          ,cnp.width
          ,cnp.x_position
          ,cnp.y_position
          ,cnp.information_category
          ,cnp.information1
          ,cnp.information2
          ,cnp.information3
          ,cnp.information4
          ,cnp.information5
          ,cnp.information6
          ,cnp.information7
          ,cnp.information8
          ,cnp.information9
          ,cnp.information10
          ,cnp.information11
          ,cnp.information12
          ,cnp.information13
          ,cnp.information14
          ,cnp.information15
          ,cnp.information16
          ,cnp.information17
          ,cnp.information18
          ,cnp.information19
          ,cnp.information20
          ,cnp.information21
          ,cnp.information22
          ,cnp.information23
          ,cnp.information24
          ,cnp.information25
          ,cnp.information26
          ,cnp.information27
          ,cnp.information28
          ,cnp.information29
          ,cnp.information30
      FROM hr_canvas_properties cnp
          ,hr_template_canvases_b tcn
          ,hr_template_windows_b twn
          ,hr_form_windows_b fwn
          ,hr_form_canvases_b fcn
     WHERE cnp.template_canvas_id (+) = tcn.template_canvas_id
       AND tcn.form_canvas_id (+) = p_form_canvas_id
       AND tcn.template_window_id (+) = twn.template_window_id
       AND twn.form_template_id (+) = p_form_template_id
       AND fwn.form_window_id = fcn.form_window_id
       AND fcn.form_canvas_id = p_form_canvas_id
  ORDER BY tcn.template_canvas_id;