APPS.BSC_INVALID_DIM_LVLS_RPT dependencies on USER_OBJECTS

Line 47: WHERE table_type = 1 AND EXISTS (SELECT 1 FROM user_objects WHERE status='INVALID' AND

43: h_pmf_count NUMBER;
44: h_bsc_count NUMBER;
45: CURSOR cv IS
46: SELECT source,COUNT(short_name) FROM bsc_sys_dim_levels_vl
47: WHERE table_type = 1 AND EXISTS (SELECT 1 FROM user_objects WHERE status='INVALID' AND
48: object_name = level_table_name)
49: GROUP BY source;
50: BEGIN
51: h_bsc_count := 0;

Line 83: ' WHERE TABLE_TYPE = 1 AND EXISTS (SELECT 1 FROM user_objects '||

79: IF h_count >0 THEN
80: JTF_DIAGNOSTIC_COREAPI.BRPrint;
81: sqltxt := 'SELECT Name "Dimension Object Name", short_name, SOURCE, LEVEL_TABLE_NAME, '||
82: ' LEVEL_VIEW_NAME FROM bsc_sys_dim_levels_vl '||
83: ' WHERE TABLE_TYPE = 1 AND EXISTS (SELECT 1 FROM user_objects '||
84: ' WHERE status=''INVALID'' AND object_name = LEVEL_VIEW_NAME) ';
85:
86: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_INVALID_DIM_LVLS'));
87: JTF_DIAGNOSTIC_COREAPI.BRPrint;