The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_SELECT_LIST => 'FACT.ORIGINAL_FUNDINGS_COUNT "PJI_REP_MSR_1",
FACT.ADDITIONAL_FUNDINGS_COUNT "PJI_REP_MSR_2",
FACT.TOTAL_BOOKINGS_COUNT "PJI_REP_MSR_7",
FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_3",
FACT.ADDITIONAL_FUNDINGS_AMOUNT "PJI_REP_MSR_4",
FACT.ADJUSTMENT_FUNDINGS_AMOUNT "PJI_REP_MSR_14",
FACT.CANCELLED_FUNDINGS_AMOUNT "PJI_REP_MSR_15",
FACT.TOTAL_FUNDINGS_AMOUNT "PJI_REP_MSR_8",
FACT.PRIOR_TOTAL_FUNDINGS_AMOUNT "PJI_REP_MSR_9",
FACT.TOTAL_FUND_CHANGE_PERCENT "PJI_REP_MSR_10",
FACT.PRIOR_ORIG_FUNDINGS_AMOUNT "PJI_REP_MSR_5",
FACT.PRIOR_ADTL_FUNDINGS_AMOUNT "PJI_REP_MSR_6",
FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_11",
FACT.ADDITIONAL_FUNDINGS_AMOUNT "PJI_REP_MSR_12",
FACT.TOTAL_FUNDINGS_AMOUNT "PJI_REP_MSR_13",
FACT.PJI_REP_TOTAL_1 "PJI_REP_TOTAL_1",
FACT.PJI_REP_TOTAL_2 "PJI_REP_TOTAL_2",
FACT.PJI_REP_TOTAL_3 "PJI_REP_TOTAL_3",
FACT.PJI_REP_TOTAL_4 "PJI_REP_TOTAL_4",
FACT.PJI_REP_TOTAL_5 "PJI_REP_TOTAL_5",
FACT.PJI_REP_TOTAL_6 "PJI_REP_TOTAL_6",
FACT.PJI_REP_TOTAL_7 "PJI_REP_TOTAL_7",
FACT.PJI_REP_TOTAL_8 "PJI_REP_TOTAL_8",
FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_9",
FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10"'
, P_SQL_STATEMENT => x_PMV_Sql
, P_PMV_OUTPUT => x_PMV_Output
, P_REGION_CODE => 'PJI_REP_PBO1'
, P_PLSQL_DRIVER => 'PJI_PMV_BOOKINGS.PLSQLDriver_BOOKINGS'
, P_PLSQL_DRIVER_PARAMS => ' <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <> ');
P_SELECT_LIST =>'FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_1",
FACT.PRIOR_ORIG_FUNDINGS_AMOUNT "PJI_REP_MSR_2",
FACT.ORIG_FUND_CHANGE_PERCENT "PJI_REP_MSR_3",
FACT.TOTAL_FUNDINGS_AMOUNT "PJI_REP_MSR_4",
FACT.PRIOR_TOTAL_FUNDINGS_AMOUNT "PJI_REP_MSR_5",
FACT.TOTAL_FUND_CHANGE_PERCENT "PJI_REP_MSR_6",
FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_7",
FACT.TOTAL_FUNDINGS_AMOUNT "PJI_REP_MSR_8"'
, P_SQL_STATEMENT => x_PMV_Sql
, P_PMV_OUTPUT => x_PMV_Output
, P_REGION_CODE => 'PJI_REP_PBO2'
, P_PLSQL_DRIVER => 'PJI_PMV_BOOKINGS.PLSQLDriver_BOOKINGS'
, P_PLSQL_DRIVER_PARAMS => ' <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <> ');
P_SELECT_LIST => 'FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_1",
FACT.ORIGINAL_FUNDINGS_COUNT "PJI_REP_MSR_2",
FACT.ORIGINAL_AVG_BOOKINGS "PJI_REP_MSR_3",
FACT.ADDITIONAL_FUNDINGS_AMOUNT "PJI_REP_MSR_4",
FACT.ADDITIONAL_FUNDINGS_COUNT "PJI_REP_MSR_5",
FACT.ADDITIONAL_AVG_BOOKINGS "PJI_REP_MSR_6",
FACT.ORIGINAL_FUNDINGS_AMOUNT "PJI_REP_MSR_7",
FACT.ADDITIONAL_FUNDINGS_AMOUNT "PJI_REP_MSR_8"'
, P_SQL_STATEMENT => x_PMV_Sql
, P_PMV_OUTPUT => x_PMV_Output
, P_REGION_CODE => 'PJI_REP_PBO3'
, P_PLSQL_DRIVER => 'PJI_PMV_BOOKINGS.PLSQLDriver_BOOKINGS'
, P_PLSQL_DRIVER_PARAMS => ' <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <>'||
', <> ');
** This table function is called from select statement
** generated by PJI engine. The function returns pl/sql table
** of records which have to be displayed in the pmv report.
** Following are the reports to which this function caters:
** 1. PJI_REP_PBO1 - Project Bookings Summary
** 2. PJI_REP_PBO2 - Project Bookings Trend
** 3. PJI_REP_PBO3 - Project Bookings Source Summary
** ----------------------------------------------------------
*/
FUNCTION PLSQLDriver_Bookings(
p_Operating_Unit IN VARCHAR2 DEFAULT NULL
, p_Organization IN VARCHAR2
, p_Currency_Type IN VARCHAR2
, p_As_Of_Date IN NUMBER
, p_Period_Type IN VARCHAR2
, p_View_BY IN VARCHAR2
, p_Classifications IN VARCHAR2 DEFAULT NULL
, p_Class_Codes IN VARCHAR2 DEFAULT NULL
)RETURN PJI_AC_BOOKINGS_TBL
IS
PRAGMA AUTONOMOUS_TRANSACTION;
SELECT PJI_AC_BOOKINGS(
ORG_ID
, ORGANIZATION_ID
, TIME_ID
, TIME_KEY
, PROJECT_CLASS_ID
, SUM( ORIGINAL_FUNDINGS_COUNT )
, SUM( ADDITIONAL_FUNDINGS_COUNT )
, SUM( TOTAL_FUNDING_COUNT )
, SUM( ORIGINAL_FUNDINGS_AMOUNT )
, SUM( ADDITIONAL_FUNDINGS_AMOUNT )
, SUM( ADJUSTMENT_FUNDINGS_AMOUNT )
, -SUM( CANCELLED_FUNDINGS_AMOUNT )
, SUM( ORIGINAL_FUNDINGS_AMOUNT
+ ADDITIONAL_FUNDINGS_AMOUNT
+ ADJUSTMENT_FUNDINGS_AMOUNT
+ CANCELLED_FUNDINGS_AMOUNT )
, SUM( PRIOR_ORIG_FUNDINGS_AMOUNT )
, SUM( PRIOR_ADTL_FUNDINGS_AMOUNT )
, SUM( PRIOR_ADJ_FUNDINGS_AMOUNT )
, -SUM( PRIOR_CAN_FUNDINGS_AMOUNT )
, SUM( PRIOR_ORIG_FUNDINGS_AMOUNT
+ PRIOR_ADTL_FUNDINGS_AMOUNT
+ PRIOR_ADJ_FUNDINGS_AMOUNT
+ PRIOR_CAN_FUNDINGS_AMOUNT )
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0 )
BULK COLLECT INTO l_Total_AC_Bookings_Tab
FROM
( SELECT /*+ ORDERED */
HOU.NAME ORG_ID
, HORG.NAME ORGANIZATION_ID
, TIME.NAME TIME_ID
, DECODE(p_View_BY,'TM',TIME.ORDER_BY_ID,-1) TIME_KEY
, '-1' PROJECT_CLASS_ID
, INITIAL_FUNDING_COUNT ORIGINAL_FUNDINGS_COUNT
, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDINGS_COUNT
, INITIAL_FUNDING_COUNT
+ADDITIONAL_FUNDING_COUNT TOTAL_FUNDING_COUNT
, INITIAL_FUNDING_AMOUNT ORIGINAL_FUNDINGS_AMOUNT
, ADDITIONAL_FUNDING_AMOUNT ADDITIONAL_FUNDINGS_AMOUNT
, FUNDING_ADJUSTMENT_AMOUNT ADJUSTMENT_FUNDINGS_AMOUNT
, CANCELLED_FUNDING_AMOUNT CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORIG_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM
PJI_PMV_TIME_DIM_TMP TIME
, PJI_PMV_ORGZ_DIM_TMP HORG
, PJI_AC_ORGO_F_MV FCT
, PJI_PMV_ORG_DIM_TMP HOU
WHERE
FCT.ORG_ID = HOU.ID
AND FCT.ORGANIZATION_ID = HORG.ID
AND FCT.TIME_ID = TIME.ID
AND TIME.ID IS NOT NULL
AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE
AND FCT.CALENDAR_TYPE = TIME.CALENDAR_TYPE
AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
UNION ALL
SELECT /*+ ORDERED */
HOU.NAME ORG_ID
, HORG.NAME ORGANIZATION_ID
, TIME.NAME TIME_ID
, DECODE(p_View_BY,'TM',TIME.ORDER_BY_ID,-1) TIME_KEY
, '-1' PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, INITIAL_FUNDING_AMOUNT PRIOR_ORIG_FUNDINGS_AMOUNT
, ADDITIONAL_FUNDING_AMOUNT PRIOR_ADTL_FUNDINGS_AMOUNT
, FUNDING_ADJUSTMENT_AMOUNT PRIOR_ADJ_FUNDINGS_AMOUNT
, CANCELLED_FUNDING_AMOUNT PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM
PJI_PMV_TIME_DIM_TMP TIME
, PJI_PMV_ORGZ_DIM_TMP HORG
, PJI_AC_ORGO_F_MV FCT
, PJI_PMV_ORG_DIM_TMP HOU
WHERE
FCT.ORG_ID = HOU.ID
AND FCT.ORGANIZATION_ID = HORG.ID
AND FCT.TIME_ID = TIME.PRIOR_ID
AND TIME.PRIOR_ID IS NOT NULL
AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE
AND FCT.CALENDAR_TYPE = TIME.CALENDAR_TYPE
AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
UNION ALL
SELECT NAME ORG_ID
, '-1' ORGANIZATION_ID
, '-1' TIME_ID
, -1 TIME_KEY
, '-1' PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORGI_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PJI_PMV_ORG_DIM_TMP
WHERE NAME <> '-1'
UNION ALL
SELECT '-1' ORG_ID
, NAME ORGANIZATION_ID
, '-1' TIME_ID
, -1 TIME_KEY
, '-1' PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORGI_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PJI_PMV_ORGZ_DIM_TMP
WHERE NAME <> '-1'
UNION ALL
SELECT '-1' ORG_ID
, '-1' ORGANIZATION_ID
, NAME TIME_ID
, ORDER_BY_ID TIME_KEY
, '-1' PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORGI_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PJI_PMV_TIME_DIM_TMP
WHERE NAME <> '-1')
GROUP BY
ORG_ID
, ORGANIZATION_ID
, TIME_KEY
, TIME_ID
, PROJECT_CLASS_ID ORDER BY TIME_KEY ASC;
SELECT PJI_AC_BOOKINGS( ORG_ID
, ORGANIZATION_ID
, TIME_ID
, TIME_KEY
, PROJECT_CLASS_ID
, SUM( ORIGINAL_FUNDINGS_COUNT )
, SUM( ADDITIONAL_FUNDINGS_COUNT )
, SUM( TOTAL_FUNDING_COUNT )
, SUM( ORIGINAL_FUNDINGS_AMOUNT )
, SUM( ADDITIONAL_FUNDINGS_AMOUNT )
, SUM( ADJUSTMENT_FUNDINGS_AMOUNT )
, -SUM( CANCELLED_FUNDINGS_AMOUNT )
, SUM( ORIGINAL_FUNDINGS_AMOUNT
+ ADDITIONAL_FUNDINGS_AMOUNT
+ ADJUSTMENT_FUNDINGS_AMOUNT
+ CANCELLED_FUNDINGS_AMOUNT )
, SUM( PRIOR_ORIG_FUNDINGS_AMOUNT )
, SUM( PRIOR_ADTL_FUNDINGS_AMOUNT )
, SUM( PRIOR_ADJ_FUNDINGS_AMOUNT )
, -SUM( PRIOR_CAN_FUNDINGS_AMOUNT )
, SUM( PRIOR_ORIG_FUNDINGS_AMOUNT
+ PRIOR_ADTL_FUNDINGS_AMOUNT
+ PRIOR_ADJ_FUNDINGS_AMOUNT
+ PRIOR_CAN_FUNDINGS_AMOUNT )
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0 )
BULK COLLECT INTO l_Total_AC_Bookings_Tab
FROM
( SELECT /*+ ORDERED */
HOU.NAME ORG_ID
, HORG.NAME ORGANIZATION_ID
, TIME.NAME TIME_ID
, DECODE(p_View_BY,'TM',TIME.ORDER_BY_ID,-1) TIME_KEY
, CLS.NAME PROJECT_CLASS_ID
, INITIAL_FUNDING_COUNT ORIGINAL_FUNDINGS_COUNT
, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDINGS_COUNT
, INITIAL_FUNDING_COUNT
+ ADDITIONAL_FUNDING_COUNT TOTAL_FUNDING_COUNT
, INITIAL_FUNDING_AMOUNT ORIGINAL_FUNDINGS_AMOUNT
, ADDITIONAL_FUNDING_AMOUNT ADDITIONAL_FUNDINGS_AMOUNT
, FUNDING_ADJUSTMENT_AMOUNT ADJUSTMENT_FUNDINGS_AMOUNT
, CANCELLED_FUNDING_AMOUNT CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORIG_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM
PJI_PMV_TIME_DIM_TMP TIME
, PJI_PMV_ORGZ_DIM_TMP HORG
, PJI_PMV_CLS_DIM_TMP CLS
, PJI_AC_CLSO_F_MV FCT
, PJI_PMV_ORG_DIM_TMP HOU
WHERE
FCT.PROJECT_ORG_ID = HOU.ID
AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
AND FCT.TIME_ID = TIME.ID
AND TIME.ID IS NOT NULL
AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE
AND FCT.CALENDAR_TYPE = TIME.CALENDAR_TYPE
AND FCT.PROJECT_CLASS_ID = CLS.ID
AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
UNION ALL
SELECT /*+ ORDERED */
HOU.NAME ORG_ID
, HORG.NAME ORGANIZATION_ID
, TIME.NAME TIME_ID
, DECODE(p_View_BY,'TM',TIME.ORDER_BY_ID,-1) TIME_KEY
, CLS.NAME PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, INITIAL_FUNDING_AMOUNT PRIOR_ORIG_FUNDINGS_AMOUNT
, ADDITIONAL_FUNDING_AMOUNT PRIOR_ADTL_FUNDINGS_AMOUNT
, FUNDING_ADJUSTMENT_AMOUNT PRIOR_ADJ_FUNDINGS_AMOUNT
, CANCELLED_FUNDING_AMOUNT PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM
PJI_PMV_TIME_DIM_TMP TIME
, PJI_PMV_ORGZ_DIM_TMP HORG
, PJI_PMV_CLS_DIM_TMP CLS
, PJI_AC_CLSO_F_MV FCT
, PJI_PMV_ORG_DIM_TMP HOU
WHERE
FCT.PROJECT_ORG_ID = HOU.ID
AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
AND FCT.TIME_ID = TIME.PRIOR_ID
AND TIME.PRIOR_ID IS NOT NULL
AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE
AND FCT.CALENDAR_TYPE = TIME.CALENDAR_TYPE
AND FCT.PROJECT_CLASS_ID = CLS.ID
AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
UNION ALL
SELECT NAME ORG_ID
, '-1' ORGANIZATION_ID
, '-1' TIME_ID
, -1 TIME_KEY
, '-1' PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORGI_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PJI_PMV_ORG_DIM_TMP
WHERE NAME <> '-1'
UNION ALL
SELECT '-1' ORG_ID
, NAME ORGANIZATION_ID
, '-1' TIME_ID
, -1 TIME_KEY
, '-1' PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORGI_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PJI_PMV_ORGZ_DIM_TMP
WHERE NAME <> '-1'
UNION ALL
SELECT '-1' ORG_ID
, '-1' ORGANIZATION_ID
, NAME TIME_ID
, ORDER_BY_ID TIME_KEY
, '-1' PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORGI_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PJI_PMV_TIME_DIM_TMP
WHERE NAME <> '-1'
UNION ALL
SELECT '-1' ORG_ID
, '-1' ORGANIZATION_ID
, '-1' TIME_ID
, -1 TIME_KEY
, NAME PROJECT_CLASS_ID
, 0 ORIGINAL_FUNDINGS_COUNT
, 0 ADDITIONAL_FUNDINGS_COUNT
, 0 TOTAL_FUNDING_COUNT
, 0 ORIGINAL_FUNDINGS_AMOUNT
, 0 ADDITIONAL_FUNDINGS_AMOUNT
, 0 ADJUSTMENT_FUNDINGS_AMOUNT
, 0 CANCELLED_FUNDINGS_AMOUNT
, 0 PRIOR_ORGI_FUNDINGS_AMOUNT
, 0 PRIOR_ADTL_FUNDINGS_AMOUNT
, 0 PRIOR_ADJ_FUNDINGS_AMOUNT
, 0 PRIOR_CAN_FUNDINGS_AMOUNT
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PJI_PMV_CLS_DIM_TMP
WHERE NAME <> '-1') FACT
GROUP BY
ORG_ID
, ORGANIZATION_ID
, TIME_KEY
, TIME_ID
, PROJECT_CLASS_ID ORDER BY TIME_KEY ASC;
l_Total_AC_Bookings_Tab.DELETE(l_Top_Org_Index);