MATERIALIZED VIEW: APPS.ASO_BI_QOT_RULB_MV

Source

SELECT /* 12.0: bug#4526784 */ 'NEWRUL' Umarker,
           Resource_Grp_id,
           Resource_Id,
           Oam_rule_id,
           COUNT(*) open,
           COUNT(*) new,
           time.report_date_julian day_id,
           time.week_id,
           time.ent_period_id,
           time.ent_qtr_id,
           time.ent_year_id
    FROM
        ASO.ASO_BI_APR_RUL_F APR,
        FII.FII_TIME_DAY TIME
    WHERE apr.apr_start_date = time.report_date
    GROUP BY Resource_Grp_Id,
             Resource_Id,
             APR.Oam_Rule_Id,
       	     time.report_date_julian,
             time.week_id,
             time.ent_period_id,
             time.ent_qtr_id,
             time.ent_year_id
    UNION ALL
    SELECT  'CLSRUL' Umarker,
            Resource_grp_id,
            Resource_id,
            Oam_rule_id,
	    COUNT(*) open1,
            NULL new,
            time.report_date_julian day_id,
            time.week_id,
            time.ent_period_id,
            time.ent_qtr_id,
            time.ent_year_id
    FROM
        ASO.ASO_BI_APR_RUL_F APR,
        FII.FII_TIME_DAY TIME
    WHERE apr.qa_end_date = time.report_date
    GROUP BY Resource_Grp_Id,
             Resource_Id,
             APR.Oam_Rule_Id,
             time.report_date_julian,
             time.week_id,
             time.ent_period_id,
             time.ent_qtr_id,
             time.ent_year_id