MATERIALIZED VIEW: APPS.PJI_CA_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.AVAILABILITY)       		AVAILABILITY,
	 count(rmo.AVAILABILITY)       		AVAILABILITY_CNT,
	 sum(rmo.TOTAL_RES_COUNT)       	TOTAL_RES_COUNT,
	 count(rmo.TOTAL_RES_COUNT)   		TOTAL_RES_COUNT_CNT
       FROM
		PJI.PJI_CA_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