[Home] [Help]
83: PJI_RM_SUM_MAIN.g_process,
84: 'PA_CALENDAR_FLAG'
85: );
86:
87: insert /*+ append parallel(act3_i) */ into PJI_FM_AGGR_ACT3 act3_i
88: (
89: WORKER_ID,
90: PROJECT_ID,
91: PROJECT_ORG_ID,
1126: )) then
1127: return;
1128: end if;
1129:
1130: insert /*+ append parallel(act3_i) */ into PJI_FM_AGGR_ACT3 act3_i -- in EXPAND_ACT_CAL_EN
1131: (
1132: WORKER_ID,
1133: PROJECT_ID,
1134: PROJECT_ORG_ID,
1244: sum(act.ACTIVE_BACKLOG),
1245: sum(act.REVENUE_AT_RISK)
1246: from
1247: FII_TIME_DAY time,
1248: PJI_FM_AGGR_ACT3 act
1249: where
1250: act.PERIOD_TYPE_ID = 1 and
1251: act.CALENDAR_TYPE = 'C' and
1252: act.CURR_RECORD_TYPE_ID not in (8, 256) and
1305: )) then
1306: return;
1307: end if;
1308:
1309: insert /*+ append parallel(act3_i) */ into PJI_FM_AGGR_ACT3 act3_i -- in EXPAND_ACT_CAL_PA
1310: (
1311: WORKER_ID,
1312: PROJECT_ID,
1313: PROJECT_ORG_ID,
1423: sum(act.ACTIVE_BACKLOG),
1424: sum(act.REVENUE_AT_RISK)
1425: from
1426: FII_TIME_CAL_DAY_MV time,
1427: PJI_FM_AGGR_ACT3 act
1428: where
1429: act.PERIOD_TYPE_ID = 1 and
1430: act.CALENDAR_TYPE = 'P' and
1431: to_date(to_char(act.TIME_ID), 'J') = time.REPORT_DATE and
1484: )) then
1485: return;
1486: end if;
1487:
1488: insert /*+ append parallel(act3_i) */ into PJI_FM_AGGR_ACT3 act3_i -- in EXPAND_ACT_CAL_GL
1489: (
1490: WORKER_ID,
1491: PROJECT_ID,
1492: PROJECT_ORG_ID,
1649: sum(act.ACTIVE_BACKLOG) ACTIVE_BACKLOG,
1650: sum(act.REVENUE_AT_RISK) REVENUE_AT_RISK
1651: from
1652: FII_TIME_CAL_DAY_MV time,
1653: PJI_FM_AGGR_ACT3 act
1654: where
1655: act.PERIOD_TYPE_ID = 1 and
1656: act.CALENDAR_TYPE = 'C' and
1657: to_date(to_char(act.TIME_ID), 'J') = time.REPORT_DATE and
1706: )) then
1707: return;
1708: end if;
1709:
1710: insert /*+ append parallel(act3_i) */ into PJI_FM_AGGR_ACT3 act3_i -- in EXPAND_ACT_CAL_WK
1711: (
1712: WORKER_ID,
1713: PROJECT_ID,
1714: PROJECT_ORG_ID,
1800: sum(act.ACTIVE_BACKLOG),
1801: sum(act.REVENUE_AT_RISK)
1802: from
1803: FII_TIME_DAY time,
1804: PJI_FM_AGGR_ACT3 act
1805: where
1806: act.PERIOD_TYPE_ID = 1 and
1807: act.CALENDAR_TYPE = 'C' and
1808: act.CURR_RECORD_TYPE_ID not in (8, 256) and
1961: l_creation_date,
1962: l_created_by,
1963: l_last_update_login
1964: from
1965: PJI_FM_AGGR_ACT3 act
1966: where
1967: (nvl(REVENUE , 0) <> 0 or
1968: nvl(INITIAL_FUNDING_AMOUNT , 0) <> 0 or
1969: nvl(INITIAL_FUNDING_COUNT , 0) <> 0 or
2134: LOST_BACKLOG,
2135: ACTIVE_BACKLOG,
2136: REVENUE_AT_RISK
2137: from
2138: PJI_FM_AGGR_ACT3 act
2139: union all -- partial refresh
2140: select /*+ ordered full(map) parallel(map)
2141: index(acp, PJI_AC_PROJ_F_N2) use_nl(acp) */
2142: acp.PROJECT_ORG_ID,
2583:
2584: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2585:
2586: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema ,
2587: 'PJI_FM_AGGR_ACT3',
2588: 'NORMAL',
2589: null);
2590:
2591: end if;