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

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

Line: 67


  JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 77


  l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);

Line: 78


  l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
                                                                           ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);

Line: 80


  l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);