[Home] [Help]
234: h_arr_keys_no_account(h_num_keys_no_account + 3) := 'PERIOD';
235: h_num_keys_no_account := h_num_keys_no_account + 3;
236:
237: -- AW_INTEGRATION: Base table does not have periodicity_id
238: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
239: h_arr_keys_no_account(h_num_keys_no_account + 1) := 'PERIODICITY_ID';
240: h_num_keys_no_account := h_num_keys_no_account + 1;
241: END IF;
242:
246: h_lst_keys_no_account := h_lst_keys_no_account||', YEAR, TYPE, PERIOD';
247: END IF;
248:
249: -- AW_INTEGRATION: Base table does not have periodicity_id
250: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
251: h_lst_keys_no_account := h_lst_keys_no_account||', PERIODICITY_ID';
252: END IF;
253:
254: -- Get the name of key column for type of account
257: IF c_type_of_account_key%NOTFOUND THEN
258: RAISE e_unexpected_error;
259: END IF;
260: CLOSE c_type_of_account_key;
261: IF BSC_APPS.bsc_mv THEN
262: -- Since h_account_key is subaccount, what we got was the key column
263: -- for account. We need to do it again to get the type of account
264: h_acc_key := h_type_of_account_key;
265: OPEN c_type_of_account_key (h_acc_key);
274: RAISE e_unexpected_error;
275: END IF;
276:
277: -- Get the profit account
278: IF NOT BSC_APPS.bsc_mv THEN
279: h_sql := 'SELECT code'||
280: ' FROM '||h_account_dim_table||
281: ' WHERE '||h_type_of_account_key||' = :1';
282: OPEN h_cursor FOR h_sql USING 3;
325:
326: -- Get a list with the calculation of the profit for all data fields
327: FOR h_i IN 1 .. x_num_data_columns LOOP
328: IF h_lst_sum_profit IS NULL THEN
329: IF BSC_APPS.bsc_mv THEN
330: h_lst_sum_profit := 'SUM(DECODE('||h_acc_table;
331: ELSE
332: h_lst_sum_profit := 'SUM(DECODE('||h_account_dim_table;
333: END IF;
334: h_lst_sum_profit := h_lst_sum_profit||'.'||h_type_of_account_key||', '||
335: '1, '||x_table_name||'.'||x_data_columns(h_i)||', '||
336: '-'||x_table_name||'.'||x_data_columns(h_i)||'))';
337: ELSE
338: IF BSC_APPS.bsc_mv THEN
339: h_lst_sum_profit := h_lst_sum_profit||', '||
340: 'SUM(DECODE('||h_acc_table;
341: ELSE
342: h_lst_sum_profit := h_lst_sum_profit||', '||
369: IF x_aw_flag THEN
370: h_sql:=h_sql||', '||x_table_name||'.PROJECTION, '||x_change_vector_value;
371: END IF;
372: h_sql:=h_sql||' FROM '||x_table_name||', '||h_account_dim_table;
373: IF BSC_APPS.bsc_mv THEN
374: h_sql := h_sql||', '||h_acc_table;
375: END IF;
376: h_sql := h_sql||' WHERE '||x_table_name||'.'||h_account_key||' = '||h_account_dim_table||'.CODE';
377: IF BSC_APPS.bsc_mv THEN
373: IF BSC_APPS.bsc_mv THEN
374: h_sql := h_sql||', '||h_acc_table;
375: END IF;
376: h_sql := h_sql||' WHERE '||x_table_name||'.'||h_account_key||' = '||h_account_dim_table||'.CODE';
377: IF BSC_APPS.bsc_mv THEN
378: h_sql := h_sql||' AND '||h_account_dim_table||'.'||h_acc_key||' = '||h_acc_table||'.CODE';
379: END IF;
380: h_sql := h_sql||' GROUP BY '||
381: BSC_UPDATE_UTIL.Make_Lst_Table_Column(x_table_name, h_arr_keys_no_account, h_num_keys_no_account);
525: -- the projected data is in the summary table and the other data including
526: -- targets are in the MV
527: --AW_INTEGRATION: In this architecture we never calculate projection in PT tables, only
528: -- in the base table. So no changes here
529: IF BSC_APPS.bsc_mv AND (NOT x_is_base) THEN
530: h_mv_name := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(x_table_name);
531: h_ref_table := h_mv_name;
532: ELSE
533: h_ref_table := x_table_name;
535:
536: l_bind_vars_union.delete;
537: l_num_bind_vars_union := 0;
538: h_uni_table := '(SELECT '||h_lst_keys_tochar||'YEAR, TYPE, PERIOD, ';
539: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
540: h_uni_table := h_uni_table||'PERIODICITY_ID, ';
541: END IF;
542: h_uni_table := h_uni_table||h_lst_data_columns||
543: ' FROM '||h_ref_table||
543: ' FROM '||h_ref_table||
544: ' WHERE TYPE = :1';
545: l_num_bind_vars_union := l_num_bind_vars_union + 1;
546: l_bind_vars_union(l_num_bind_vars_union) := 0;
547: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
548: h_uni_table := h_uni_table||' AND PERIODICITY_ID = :2';
549: l_num_bind_vars_union := l_num_bind_vars_union + 1;
550: l_bind_vars_union(l_num_bind_vars_union) := x_periodicity;
551: END IF;
563: l_bind_vars_union(l_num_bind_vars_union) := x_period;
564: END IF;
565: h_uni_table := h_uni_table||' UNION '||
566: 'SELECT '||h_lst_keys_temp||'YEAR, TYPE, PERIOD, ';
567: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
568: h_uni_table := h_uni_table||'PERIODICITY_ID, ';
569: END IF;
570: h_uni_table := h_uni_table||h_lst_data_columns_temp||
571: ' FROM bsc_tmp_xmd'||
620: end if;
621: h_sql:=h_sql||' */';
622: h_sql:=h_sql||'INTO bsc_tmp_xmd ('||h_lst_select||'YEAR, TYPE, PERIOD, ';
623: -- AW_INTEGRATION: Base table does not have periodicity_id
624: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
625: h_sql := h_sql||'PERIODICITY_ID, ';
626: END IF;
627: h_sql := h_sql||h_lst_xmed_columns||')';
628: h_sql := h_sql||' SELECT ';
636: l_bind_vars_values(2) := h_i;
637: l_num_bind_vars := 2;
638: END IF;
639: -- AW_INTEGRATION: Base table does not have periodicity_id
640: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
641: h_sql := h_sql||'PERIODICITY_ID, ';
642: END IF;
643: h_sql := h_sql||h_lst_avg_columns||
644: ' FROM '||h_uni_table;
657: l_num_bind_vars_post := 4;
658: END IF;
659: h_sql := h_sql||' type = 0';
660: -- AW_INTEGRATION: Base table does not have periodicity_id
661: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
662: h_sql := h_sql||' AND periodicity_id = :17';
663: l_num_bind_vars_post := l_num_bind_vars_post + 1;
664: l_bind_vars_post(l_num_bind_vars_post) := x_periodicity;
665: END IF;
666:
667: IF h_lst_keys IS NOT NULL THEN
668: h_sql := h_sql||' GROUP BY '||h_lst_keys_nc;
669: -- AW_INTEGRATION: Base table does not have periodicity_id
670: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
671: h_sql := h_sql||', PERIODICITY_ID';
672: END IF;
673: ELSE
674: -- Fix bug#3381324 If there is no key columns we need to group by periodicity_id
672: END IF;
673: ELSE
674: -- Fix bug#3381324 If there is no key columns we need to group by periodicity_id
675: -- AW_INTEGRATION: Base table does not have periodicity_id
676: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
677: h_sql := h_sql||' GROUP BY PERIODICITY_ID';
678: END IF;
679: END IF;
680:
724: ' AND';
725: END IF;
726: h_sql := h_sql||' B.YEAR = P.YEAR AND B.TYPE = P.TYPE AND B.PERIOD = P.PERIOD';
727: --AW_INTEGRATION: Base table does not have periodicity_id
728: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
729: h_sql := h_sql||' AND B.PERIODICITY_ID = P.PERIODICITY_ID';
730: END IF;
731: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
732: commit;
852: -- BSC-MV Note: In this architecture if this is a summary table the it only
853: -- contains the projections. Base information is on the MV
854: --AW_INTEGRATION: In this architecture we never calculate projection in PT tables, only
855: -- in the base table. So no changes here
856: IF BSC_APPS.bsc_mv AND (NOT x_is_base) THEN
857: h_uni_table := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(x_table_name);
858: ELSE
859: h_uni_table := x_table_name;
860: END IF;
975: l_bind_vars_values(4) := h_per_end ;
976: l_num_bind_vars := 4;
977: END IF;
978: --AW_INTEGRATION: Base table does not have periodicity_id
979: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
980: h_sql := h_sql||' AND PERIODICITY_ID = :5';
981: l_bind_vars_values(5) := x_periodicity;
982: l_num_bind_vars := 5;
983: END IF;
1028: l_bind_vars_values(4) := (h_per_end) ;
1029: l_num_bind_vars := 4;
1030: END IF;
1031: -- AW_INTEGRATION: Base table does not have peridicity_id
1032: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1033: h_sql := h_sql||' AND PERIODICITY_ID = :5';
1034: l_bind_vars_values(5) := (x_periodicity);
1035: l_num_bind_vars := 5;
1036: END IF;
1077: l_bind_vars_values(3) := (h_per_end) ;
1078: l_num_bind_vars := 3;
1079: END IF;
1080: -- AW_INTEGRATION: Base table does not have periodicity_id
1081: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1082: h_sql := h_sql||' AND PERIODICITY_ID = :4';
1083: l_bind_vars_values(4) := (x_periodicity);
1084: l_num_bind_vars := 4;
1085: END IF;
1097: end if;
1098: h_sql:=h_sql||' */';
1099: h_sql:=h_sql||'INTO BSC_TMP_PROJECTIONS ('||h_lst_select||'YEAR, TYPE, PERIOD, ';
1100: -- AW_INTEGRATION: Base table does not have periodicity_id
1101: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1102: h_sql := h_sql||'PERIODICITY_ID, ';
1103: END IF;
1104: h_sql := h_sql||h_lst_data||')'||
1105: ' SELECT '||h_lst_keys_p||'P.YEAR, P.TYPE, P.PERIOD, ';
1103: END IF;
1104: h_sql := h_sql||h_lst_data||')'||
1105: ' SELECT '||h_lst_keys_p||'P.YEAR, P.TYPE, P.PERIOD, ';
1106: -- AW_INTEGRATION: Base table does not have periodicity_id
1107: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1108: h_sql := h_sql||'P.PERIODICITY_ID, ';
1109: END IF;
1110: h_sql := h_sql||h_lst_data_proj||
1111: ' FROM BSC_TMP_PROJ_CALC P, BSC_TMP_TOT_PLAN TP, BSC_TMP_TOT_REAL TR, BSC_TMP_PLAN_PROJECTIONS PP'||
1157: l_bind_vars_values(3) := (h_per_end) ;
1158: l_num_bind_vars := 3;
1159: END IF;
1160: -- AW_INTEGRATION: Base table does not have periodicity_id
1161: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1162: h_sql := h_sql||' AND P.PERIODICITY_ID = :4';
1163: l_bind_vars_values(4) := (x_periodicity);
1164: l_num_bind_vars := 4;
1165: END IF;
1196: ' AND';
1197: END IF;
1198: h_sql := h_sql||' B.YEAR = P.YEAR AND B.TYPE = P.TYPE AND B.PERIOD = P.PERIOD';
1199: -- AW_INTEGRATION: Base table does not have periodicity_id
1200: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1201: h_sql := h_sql||' AND B.PERIODICITY_ID = P.PERIODICITY_ID';
1202: END IF;
1203: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1204: commit;
1295: --BSC-MV Note: In this architecture if this is a summary table the
1296: -- the custom projection TYPE=90 is in the MV.
1297: --AW_INTEGRATION: In this architecture we never calculate projection on PT tables,
1298: -- only on base tables, so no changes here
1299: IF BSC_APPS.bsc_mv AND (NOT x_is_base) THEN
1300: h_src_table := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(x_table_name);
1301: ELSE
1302: h_src_table := x_table_name;
1303: END IF;
1321: 'AND')||
1322: ' AND ';
1323: END IF;
1324: --AW_INTEGRATION: Base table does not have periodicity_id
1325: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1326: h_sql := h_sql||'T.PERIODICITY_ID = B.PERIODICITY_ID AND ';
1327: END IF;
1328: h_sql := h_sql||'T.YEAR = B.YEAR'||
1329: ' AND T.PERIOD = B.PERIOD'||
1347: l_bind_vars_values(3) := x_period;
1348: l_num_bind_vars := 3;
1349: END IF;
1350: -- AW_INTEGRATION: Base table does not have periodicity_id
1351: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
1352: h_sql := h_sql||' AND T.PERIODICITY_ID = :4';
1353: l_bind_vars_values(4) := x_periodicity;
1354: l_num_bind_vars := 4;
1355: END IF;
1560:
1561: -- If we are in Summary tables architecture or AW we merge to the base table here
1562: -- If it is MV architecture we meger to the base table later when the projection
1563: -- have been rolled up to higher periodicities
1564: IF (NOT BSC_APPS.bsc_mv) OR x_aw_flag THEN
1565: IF NOT Merge_Projection(x_table_name,
1566: x_key_columns,
1567: x_num_key_columns,
1568: x_data_columns,
1701: -- BSC-MV Note: If this procedure is called, then the summary table has a
1702: -- corresponding projection table. The zero codes will be calculated on the projection
1703: -- table for all the periodicities. PERIODICITY_ID and PERIOD_TYPE_ID will be
1704: -- considered as key columns.
1705: IF BSC_APPS.bsc_mv THEN
1706: OPEN c_pt_name(x_table_name);
1707: FETCH c_pt_name INTO h_ref_table;
1708: CLOSE c_pt_name;
1709: ELSE
1726: -- we need to re-calculate the zero code on keys needing zero.
1727: -- Keys needing zero code may not be configured in bsc_db_calculations for this table,
1728: -- for this reason we need to look in the origin tables until the base table looking
1729: -- for the keys that calcualted zero code.
1730: IF NOT BSC_APPS.bsc_mv THEN
1731: -- Only for summary tables architecture
1732: SELECT count(table_name)
1733: INTO h_count
1734: FROM bsc_db_calculations
1843: h_lst_groupby := h_lst_groupby||', YEAR, TYPE, PERIOD';
1844: END IF;
1845:
1846: --BSC-MV Note: Add periodicity_id and period_type_id
1847: IF BSC_APPS.bsc_mv THEN
1848: h_lst_keys := h_lst_keys||', PERIODICITY_ID, PERIOD_TYPE_ID';
1849: h_lst_select := h_lst_select||', PERIODICITY_ID, PERIOD_TYPE_ID';
1850: IF h_lst_groupby IS NULL THEN
1851: h_lst_groupby := 'PERIODICITY_ID, PERIOD_TYPE_ID';
1965: ELSE
1966: -- EDW periodicity
1967: h_init_period := 1;
1968: h_end_period := BSC_INTEGRATION_APIS.Get_Number_Of_Periods(x_current_fy, x_periodicity, h_calendar_id);
1969: IF BSC_APPS.CheckError('BSC_INTEGRATION_APIS.Get_Number_Of_Periods') THEN
1970: RAISE e_unexpected_error;
1971: END IF;
1972:
1973: FOR h_i IN h_init_period..h_end_period LOOP
2090: END IF;
2091: ELSE
2092: --AW_INTEGRATION: In this architecture we do not calculate projections in PT tables
2093: -- only on base tables. So we know that the code does not get here. No changes here.
2094: IF BSC_APPS.bsc_mv THEN
2095: h_ref_table := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(x_table_name);
2096: ELSE
2097: h_ref_table := x_table_name;
2098: END IF;
2116: h_lst_select := h_lst_select||', ';
2117: END IF;
2118:
2119: -- AW_INTEGRATION: Base table does not have periodicity_id
2120: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2121: h_lst_table_keys := h_lst_table_keys||h_ref_table||'.PERIODICITY_ID, ';
2122: h_lst_table_keys_a := h_lst_table_keys_a||'A.PERIODICITY_ID, ';
2123: h_lst_select := h_lst_select||'PERIODICITY_ID, ';
2124:
2162: h_sql := h_sql||'('||
2163: ' SELECT DISTINCT '||h_lst_keys_nc||
2164: ' FROM '||h_ref_table;
2165: -- AW_INTEGRATION: Base table does not have periodicity_id
2166: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2167: h_sql := h_sql||' WHERE PERIODICITY_ID = :1';
2168: END IF;
2169: h_sql := h_sql||' ) A, ';
2170: END IF;
2170: END IF;
2171: h_sql := h_sql||'bsc_tmp_all_periods'||
2172: ' WHERE bsc_tmp_all_periods.period > :2';
2173: -- AW_INTEGRATION: Base table does not have periodicity_id
2174: IF (BSC_APPS.bsc_mv) AND (NOT x_aw_flag) AND (h_lst_keys_nc IS NOT NULL) THEN
2175: l_bind_vars_values(1) := (x_periodicity);
2176: l_bind_vars_values(2) := (x_current_fy);
2177: l_num_bind_vars := 2;
2178: ELSE
2201: h_sql := h_sql||'('||
2202: ' SELECT DISTINCT '||h_lst_keys_nc||
2203: ' FROM '||h_ref_table;
2204: -- AW_INTEGRATION: Base table does not have periodicity_id
2205: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2206: h_sql := h_sql||' WHERE PERIODICITY_ID = :2';
2207: END IF;
2208: h_sql := h_sql||' ) A, ';
2209: END IF;
2209: END IF;
2210: h_sql := h_sql||'bsc_tmp_all_periods'||
2211: ' WHERE bsc_tmp_all_periods.period > :3';
2212: -- AW_INTEGRATION: Base table does not have periodicity_id
2213: IF (BSC_APPS.bsc_mv) AND (NOT x_aw_flag) AND (h_lst_keys_nc IS NOT NULL) THEN
2214: l_bind_vars_values(1) := (x_current_fy);
2215: l_bind_vars_values(2) := (x_periodicity);
2216: l_bind_vars_values(3) := (x_current_period);
2217: l_num_bind_vars := 3;
2290: l_bind_vars_values(2) := 0 ;
2291: l_num_bind_vars := 2 ;
2292:
2293: -- BSC-MV Note: Add condition on periodicity_id
2294: IF BSC_APPS.bsc_mv THEN
2295: h_sql := h_sql||' AND PERIODICITY_ID = :3';
2296: l_bind_vars_values(3) := x_periodicity;
2297: l_num_bind_vars := 3;
2298: END IF;
2305: l_bind_vars_values(3) := 0 ;
2306: l_num_bind_vars := 3 ;
2307:
2308: -- BSC-MV Note: Add condition on periodicity_id
2309: IF BSC_APPS.bsc_mv THEN
2310: h_sql := h_sql||' AND PERIODICITY_ID = :4';
2311: l_bind_vars_values(4) := x_periodicity;
2312: l_num_bind_vars := 4;
2313: END IF;
2384: -- which always is false.
2385: NULL;
2386: ELSE
2387: -- AW_INTEGRATION: Need to set projection column to 'N' and change_vector to x_change_vector value
2388: IF BSC_APPS.bsc_mv AND x_aw_flag THEN
2389: h_lst_set := h_lst_set||', projection = ''N'', change_vector = '||x_change_vector_value;
2390: END IF;
2391:
2392: h_sql := 'UPDATE '||x_table_name||
2400:
2401: -- BSC-MV Note: Add condition on periodicity_id
2402: -- AW_INTEGRATION: If the base table is for AW then there is no higher periodicities
2403: -- and there is no PERIODICITY_ID column.
2404: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2405: h_sql := h_sql||' AND PERIODICITY_ID = :5';
2406: l_bind_vars_values(5) := x_periodicity;
2407: l_num_bind_vars := 5;
2408: END IF;
2435:
2436: IF h_lst_set IS NOT NULL THEN
2437: -- AW_INTEGRATION: Need to set projection column to 'N' and change_vector to x_change_vector_value
2438: -- Fix bug#4653405: AW_INTEGRATION: we cannot set projection = 'N' here, it remains in Y
2439: IF BSC_APPS.bsc_mv AND x_aw_flag THEN
2440: h_lst_set := h_lst_set||', change_vector = '||x_change_vector_value;
2441: END IF;
2442:
2443: l_bind_vars_values.delete ;
2450: l_num_bind_vars := 2 ;
2451:
2452: -- BSC-MV Note: Add condition on periodicity_id
2453: -- AW_INTEGRATION: If the base table is for AW then there is not periodicity_id
2454: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2455: h_sql := h_sql||' AND PERIODICITY_ID = :3';
2456: l_bind_vars_values(3) := x_periodicity;
2457: l_num_bind_vars := 3;
2458: END IF;
2466: l_num_bind_vars := 3 ;
2467:
2468: -- BSC-MV Note: Add condition on periodicity_id
2469: -- AW_INTEGRATION: If the base table is for AW then there is not periodicity_id
2470: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2471: h_sql := h_sql||' AND PERIODICITY_ID = :4';
2472: l_bind_vars_values(4) := x_periodicity;
2473: l_num_bind_vars := 4;
2474: END IF;
2752: h_lst_keys_a := h_lst_keys_a||', ';
2753: h_lst_keys_b := h_lst_keys_b||', ';
2754: END IF;
2755:
2756: IF BSC_APPS.bsc_mv AND (NOT x_aw_flag) THEN
2757: h_lst_keys_temp := h_lst_keys_temp||'PERIODICITY_ID, ';
2758: h_cond_join := h_cond_join||'A.PERIODICITY_ID = B.PERIODICITY_ID AND ';
2759: h_lst_keys_a := h_lst_keys_a||'A.PERIODICITY_ID, ';
2760: h_lst_keys_b := h_lst_keys_b||'B.PERIODICITY_ID, ';
2862: h_start_year := x_current_fy - h_previous_years;
2863: h_end_year := h_start_year + h_num_of_years - 1;
2864:
2865: BSC_INTEGRATION_MV_GEN.Refresh_MVs(x_table_name, TO_CHAR(h_start_year)||'-'||TO_CHAR(h_end_year));
2866: IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Refresh_MVs') THEN
2867: RAISE e_unexpected_error;
2868: END IF;
2869:
2870: -- Delete from x_table all rows existing in the materialized view
2893:
2894: --AD_DDL has some issues creating the view. It could be because the materialized views
2895: --were not created using AD_DDL?
2896: --So, we create the view directly. This is not so bad because the views are created on APPS schema
2897: --BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_VIEW, h_edw_uv_name);
2898: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
2899:
2900: -- Get current period for the table.
2901: -- This is the maximun period reported in the materialized view