[Home] [Help]
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;
534: END IF;
734: -- Analyze the BSC_TMP_XMD_Y
735: -- Bug#3740230: We cannot analyze. It is causing Loader hangs truncating this table
736: -- Bug#3756654: Oracle 8i does not support gathering stacts on temporary tables
737: --IF BSC_IM_UTILS.get_db_version <> '8i' THEN
738: -- BSC_BIA_WRAPPER.Analyze_Table('BSC_TMP_XMD_Y');
739: --END IF;
740:
741: -- Update the base table
742: h_sql := 'UPDATE /*+ORDERED USE_NL(B)*/ BSC_TMP_PROJ_CALC B'||
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;
861:
1206: -- Analyze the BSC_TMP_PROJECTIONS_Y
1207: -- Bug#3740230: We cannot analyze. It is causing Loader hangs truncating this table
1208: -- Bug#3756654: Oracle 8i does not support gathering stacts on temporary tables
1209: --IF BSC_IM_UTILS.get_db_version <> '8i' THEN
1210: -- BSC_BIA_WRAPPER.Analyze_Table('BSC_TMP_PROJECTIONS_Y');
1211: --END IF;
1212:
1213: -- Update the projection table BSC_TMP_PROJ_CALC
1214: h_sql := 'UPDATE /*+ORDERED USE_NL(B)*/ BSC_TMP_PROJ_CALC B'||
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;
1304:
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;
2099: