[Home] [Help]
792: cfrb.forecast_periods
793: from csp_usage_histories cuh_fcst,
794: csp_planning_parameters cpp,
795: csp_forecast_rules_b cfrb,
796: csp_usage_org_mv cuh_usg
797: where cuh_fcst.history_data_type = 5
798: and cuh_fcst.period_start_date between (trunc(sysdate) - cfrb.forecast_periods * cfrb.period_size * cfrb.tracking_signal_cycle) and trunc(sysdate)
799: and cpp.organization_id = cuh_fcst.organization_id
800: and cpp.recommend_method in ('USAGE','USAGE_PNORM','USAGE_TNORM')
843: THEN
844: COMMIT WORK;
845: END IF;
846:
847: EXECUTE IMMEDIATE 'ALTER MATERIALIZED VIEW CSP_USAGE_ORG_MV COMPILE';
848: EXECUTE IMMEDIATE 'ALTER MATERIALIZED VIEW CSP_USAGE_REG_MV COMPILE';
849:
850: -- Standard call to get message count and if count is 1, get message info.
851: FND_MSG_PUB.Count_And_Get
1149: COMMIT;
1150: -- Re-establish Savepoint
1151: SAVEPOINT CREATE_USAGE_PVT;
1152: --- Refresh Organization rollup snapshot
1153: DBMS_MVIEW.REFRESH('CSP_USAGE_ORG_MV','C');
1154: --- Refresh other rollup snapshot
1155: Create_Usage_Rollup ( P_Api_Version_Number => 1.0,
1156: retcode => retcode,
1157: errbuf => errbuf);
1336: cfrb.WEIGHTED_AVG_PERIOD11,
1337: cfrb.WEIGHTED_AVG_PERIOD12,
1338: cpp.RECOMMEND_METHOD
1339: From CSP_PLANNING_PARAMETERS cpp,
1340: CSP_USAGE_ORG_MV cuom,
1341: CSP_SUPERSEDE_ITEMS csi,
1342: CSP_FORECAST_RULES_B cfrb
1343: Where cpp.level_id like P_Level_Id || '%'
1344: And cpp.node_type = 'ORGANIZATION_WH'