APPS.BSC_INVALID_DIM_LVLS_RPT dependencies on BSC_SYS_DIM_LEVELS_VL

Line 46: SELECT source,COUNT(short_name) FROM bsc_sys_dim_levels_vl

42: h_source bsc_sys_dim_levels_b.source%TYPE;
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

Line 82: ' LEVEL_VIEW_NAME FROM bsc_sys_dim_levels_vl '||

78: h_count := h_pmf_count + h_bsc_count;
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'));