APPS.BSC_SETUP_DATA_RPT SQL Statements

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

Line: 56

        JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 64

        sqltxt := 'SELECT a.SESSION_ID,b.serial#,b.status,c.object_name,a.ORACLE_USERNAME,'||
                  ' a.OS_USER_NAME,a.PROCESS FROM v$locked_object a, v$session b, all_objects c '||
                  ' WHERE c.OBJECT_NAME LIKE ''BSC%'' AND c.OBJECT_ID=a.OBJECT_ID AND b.sid=a.SESSION_ID'||
                  ' AND c.OWNER = '''|| l_oracle_schema||'''';

Line: 73

        sqltxt := 'SELECT * FROM BSC_CURRENT_SESSIONS';

Line: 81

        sqltxt := 'SELECT * FROM bsc_sys_init ';

Line: 87

        sqltxt := 'SELECT * FROM BSC_MESSAGE_LOGS ';