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

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

Line: 14


  SELECT oracle_username INTO l_owner
  FROM   fnd_oracle_userid
  WHERE  oracle_id = 690;

Line: 33


  SELECT 1
  FROM ALL_OBJECTS
  WHERE OBJECT_NAME = 'JTF_NOTES_TL_C1'
  AND OBJECT_TYPE = 'INDEX'
  AND OWNER = p_owner;

Line: 39


  SELECT IDX_LANGUAGE_COLUMN
  FROM CTXSYS.ctx_indexes
  WHERE idx_name = 'JTF_NOTES_TL_C1';