APPS.BSC_INVALID_DIM_LVLS_RPT SQL Statements

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

Line: 46

        SELECT source,COUNT(short_name) FROM bsc_sys_dim_levels_vl
        WHERE table_type = 1 AND EXISTS (SELECT 1 FROM user_objects WHERE status='INVALID' AND
        object_name = level_table_name)
        GROUP BY source;

Line: 57

        JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 81

            sqltxt := 'SELECT Name "Dimension Object Name", short_name, SOURCE, LEVEL_TABLE_NAME, '||
                      ' LEVEL_VIEW_NAME FROM bsc_sys_dim_levels_vl '||
                      ' WHERE TABLE_TYPE = 1 AND EXISTS (SELECT 1 FROM user_objects '||
                      ' WHERE status=''INVALID'' AND object_name = LEVEL_VIEW_NAME) ';