eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UPDATE_BASE dependencies on BSC_DB_WEEK_MAPS

Line 87: -- This is the special case that use bsc_db_week_maps table to make the

83: x_per_base_table := x_current_fy;
84:
85: ELSIF h_periodicity_type_base_table = 7 AND h_periodicity_type_input_table = 11 THEN
86: -- The base table is Weekly52 and the input table is Month Week
87: -- This is the special case that use bsc_db_week_maps table to make the
88: -- transformation
89: BEGIN
90: SELECT week52
91: INTO x_per_base_table

Line 92: FROM bsc_db_week_maps

88: -- transformation
89: BEGIN
90: SELECT week52
91: INTO x_per_base_table
92: FROM bsc_db_week_maps
93: WHERE year = x_current_fy AND month = x_per_input_table AND
94: week = x_subper_input_table AND calendar_id = h_calendar_id;
95: EXCEPTION
96: WHEN NO_DATA_FOUND THEN

Line 1875: -- This is the special case that use bsc_db_week_maps table to make the

1871: h_lst_select := h_lst_select||x_in_tbl||'.YEAR, '||x_in_tbl||'.TYPE, 0';
1872:
1873: ELSIF h_periodicity_type_base_table = 7 AND h_periodicity_type_input_table = 11 THEN
1874: -- The base table is Weekly52 and the input table is Month Week
1875: -- This is the special case that use bsc_db_week_maps table to make the
1876: -- transformation
1877: h_lst_from := h_lst_from||', BSC_DB_WEEK_MAPS';
1878: l_parallel_hint:=l_parallel_hint||' parallel (BSC_DB_WEEK_MAPS)';
1879:

Line 1877: h_lst_from := h_lst_from||', BSC_DB_WEEK_MAPS';

1873: ELSIF h_periodicity_type_base_table = 7 AND h_periodicity_type_input_table = 11 THEN
1874: -- The base table is Weekly52 and the input table is Month Week
1875: -- This is the special case that use bsc_db_week_maps table to make the
1876: -- transformation
1877: h_lst_from := h_lst_from||', BSC_DB_WEEK_MAPS';
1878: l_parallel_hint:=l_parallel_hint||' parallel (BSC_DB_WEEK_MAPS)';
1879:
1880: h_lst_select := h_lst_select||x_in_tbl||'.YEAR, '||x_in_tbl||'.TYPE, BSC_DB_WEEK_MAPS.WEEK52';
1881:

Line 1878: l_parallel_hint:=l_parallel_hint||' parallel (BSC_DB_WEEK_MAPS)';

1874: -- The base table is Weekly52 and the input table is Month Week
1875: -- This is the special case that use bsc_db_week_maps table to make the
1876: -- transformation
1877: h_lst_from := h_lst_from||', BSC_DB_WEEK_MAPS';
1878: l_parallel_hint:=l_parallel_hint||' parallel (BSC_DB_WEEK_MAPS)';
1879:
1880: h_lst_select := h_lst_select||x_in_tbl||'.YEAR, '||x_in_tbl||'.TYPE, BSC_DB_WEEK_MAPS.WEEK52';
1881:
1882: IF h_lst_where IS NOT NULL THEN

Line 1880: h_lst_select := h_lst_select||x_in_tbl||'.YEAR, '||x_in_tbl||'.TYPE, BSC_DB_WEEK_MAPS.WEEK52';

1876: -- transformation
1877: h_lst_from := h_lst_from||', BSC_DB_WEEK_MAPS';
1878: l_parallel_hint:=l_parallel_hint||' parallel (BSC_DB_WEEK_MAPS)';
1879:
1880: h_lst_select := h_lst_select||x_in_tbl||'.YEAR, '||x_in_tbl||'.TYPE, BSC_DB_WEEK_MAPS.WEEK52';
1881:
1882: IF h_lst_where IS NOT NULL THEN
1883: h_lst_where := h_lst_where||' AND ';
1884: END IF;

Line 1886: x_in_tbl||'.YEAR = BSC_DB_WEEK_MAPS.YEAR AND '||

1882: IF h_lst_where IS NOT NULL THEN
1883: h_lst_where := h_lst_where||' AND ';
1884: END IF;
1885: h_lst_where := h_lst_where||
1886: x_in_tbl||'.YEAR = BSC_DB_WEEK_MAPS.YEAR AND '||
1887: x_in_tbl||'.'||x_in_per_fld||' = BSC_DB_WEEK_MAPS.MONTH AND '||
1888: x_in_tbl||'.'||x_in_subper_fld||' = BSC_DB_WEEK_MAPS.WEEK AND '||
1889: 'BSC_DB_WEEK_MAPS.CALENDAR_ID = :2';
1890: l_bind_var_per := h_calendar_id;

Line 1887: x_in_tbl||'.'||x_in_per_fld||' = BSC_DB_WEEK_MAPS.MONTH AND '||

1883: h_lst_where := h_lst_where||' AND ';
1884: END IF;
1885: h_lst_where := h_lst_where||
1886: x_in_tbl||'.YEAR = BSC_DB_WEEK_MAPS.YEAR AND '||
1887: x_in_tbl||'.'||x_in_per_fld||' = BSC_DB_WEEK_MAPS.MONTH AND '||
1888: x_in_tbl||'.'||x_in_subper_fld||' = BSC_DB_WEEK_MAPS.WEEK AND '||
1889: 'BSC_DB_WEEK_MAPS.CALENDAR_ID = :2';
1890: l_bind_var_per := h_calendar_id;
1891: ELSE

Line 1888: x_in_tbl||'.'||x_in_subper_fld||' = BSC_DB_WEEK_MAPS.WEEK AND '||

1884: END IF;
1885: h_lst_where := h_lst_where||
1886: x_in_tbl||'.YEAR = BSC_DB_WEEK_MAPS.YEAR AND '||
1887: x_in_tbl||'.'||x_in_per_fld||' = BSC_DB_WEEK_MAPS.MONTH AND '||
1888: x_in_tbl||'.'||x_in_subper_fld||' = BSC_DB_WEEK_MAPS.WEEK AND '||
1889: 'BSC_DB_WEEK_MAPS.CALENDAR_ID = :2';
1890: l_bind_var_per := h_calendar_id;
1891: ELSE
1892: -- Other periodicities changes

Line 1889: 'BSC_DB_WEEK_MAPS.CALENDAR_ID = :2';

1885: h_lst_where := h_lst_where||
1886: x_in_tbl||'.YEAR = BSC_DB_WEEK_MAPS.YEAR AND '||
1887: x_in_tbl||'.'||x_in_per_fld||' = BSC_DB_WEEK_MAPS.MONTH AND '||
1888: x_in_tbl||'.'||x_in_subper_fld||' = BSC_DB_WEEK_MAPS.WEEK AND '||
1889: 'BSC_DB_WEEK_MAPS.CALENDAR_ID = :2';
1890: l_bind_var_per := h_calendar_id;
1891: ELSE
1892: -- Other periodicities changes
1893: h_edw_flag := BSC_UPDATE_UTIL.Get_Periodicity_EDW_Flag(x_base_percode);