MATERIALIZED VIEW: APPS.PJI_AV_ORGO_F_MV

Source

SELECT /* 12.0: bug#4526784 */
	 count(*)                               CNT,
	 dnm.ORGANIZATION_ID 			as EXPENDITURE_ORGANIZATION_ID,
	 rmo.EXPENDITURE_ORG_ID 		as EXPENDITURE_ORG_ID,
	 rmo.PERIOD_TYPE_ID 			as PERIOD_TYPE_ID,
	 rmo.TIME_ID 				as TIME_ID,
	 rmo.CALENDAR_TYPE 			as CALENDAR_TYPE,
	 rmo.THRESHOLD 				as THRESHOLD,
	 rmo.AS_OF_DATE				as AS_OF_DATE,
	 sum(rmo.BCKT_1_CS)       		BCKT_1_CS,
	 count(rmo.BCKT_1_CS)       		BCKT_1_CS_CNT,
	 sum(rmo.BCKT_2_CS)       		BCKT_2_CS,
	 count(rmo.BCKT_2_CS)       		BCKT_2_CS_CNT,
	 sum(rmo.BCKT_3_CS)       		BCKT_3_CS,
	 count(rmo.BCKT_3_CS)       		BCKT_3_CS_CNT,
	 sum(rmo.BCKT_4_CS)       		BCKT_4_CS,
	 count(rmo.BCKT_4_CS)       		BCKT_4_CS_CNT,
	 sum(rmo.BCKT_5_CS)       		BCKT_5_CS,
	 count(rmo.BCKT_5_CS)       		BCKT_5_CS_CNT,
	 sum(rmo.BCKT_1_CM)       		BCKT_1_CM,
	 count(rmo.BCKT_1_CM)       		BCKT_1_CM_CNT,
	 sum(rmo.BCKT_2_CM)       		BCKT_2_CM,
	 count(rmo.BCKT_2_CM)       		BCKT_2_CM_CNT,
	 sum(rmo.BCKT_3_CM)       		BCKT_3_CM,
	 count(rmo.BCKT_3_CM)       		BCKT_3_CM_CNT,
	 sum(rmo.BCKT_4_CM)       		BCKT_4_CM,
	 count(rmo.BCKT_4_CM)       		BCKT_4_CM_CNT,
	 sum(rmo.BCKT_5_CM)       		BCKT_5_CM,
	 count(rmo.BCKT_5_CM)       		BCKT_5_CM_CNT,
	 sum(rmo.TOTAL_RES_COUNT)       	TOTAL_RES_COUNT,
	 count(rmo.TOTAL_RES_COUNT)   		TOTAL_RES_COUNT_CNT
       FROM
		PJI.PJI_AV_ORG_F rmo, PJI.PJI_ORG_DENORM dnm
       WHERE
       		rmo.EXPENDITURE_ORGANIZATION_ID = dnm.SUB_ORGANIZATION_ID
       GROUP BY
		    dnm.ORGANIZATION_ID,
		    rmo.EXPENDITURE_ORG_ID,
		    rmo.PERIOD_TYPE_ID,
		    rmo.TIME_ID,
		    rmo.CALENDAR_TYPE,
		    rmo.THRESHOLD,
		    rmo.AS_OF_DATE