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_DBGEN_BSC_READER dependencies on BSC_DB_TABLES

Line 567: FROM BSC_SYS_MEASURES M, BSC_DB_TABLES_COLS C, BSC_DB_MEASURE_COLS_VL COLS

563: NVL(BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :2 ),''N'') AS PAVGL,
564: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :3) AS PAVGLTOTAL,
565: BSC_APPS.GET_PROPERTY_VALUE(M.S_COLOR_FORMULA, :4) AS PAVGLCOUNTER,
566: M.MEASURE_ID, nvl(cols.measure_type, 1) measure_type, m.source
567: FROM BSC_SYS_MEASURES M, BSC_DB_TABLES_COLS C, BSC_DB_MEASURE_COLS_VL COLS
568: WHERE M.MEASURE_COL(+) = C.COLUMN_NAME
569: AND COLS.measure_col(+) = c.column_name
570: AND C.COLUMN_TYPE = ''A''
571: AND C.TABLE_NAME LIKE ''BSC_S%'||p_fact||'_'||p_dim_set||'%'||'''

Line 1113: select table_name from bsc_db_Tables_rels

1109: END;
1110:
1111: FUNCTION get_lowest_s_table(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return VARCHAR2 IS
1112: CURSOR cSTable(p_fact_pattern varchar2, p_s_pattern varchar2) IS
1113: select table_name from bsc_db_Tables_rels
1114: where table_name like p_fact_pattern
1115: and source_table_name not like p_s_pattern;
1116: l_s_tablename VARCHAR2(300);
1117: BEGIn

Line 1819: select distinct dim_level_id, level_table_name, level_pk_col from bsc_db_tables_cols cols, bsc_sys_dim_levels_b lvl

1815: p_table_name varchar2,
1816: p_table_type VARCHAR2) return BSC_DBGEN_STD_METADATA.tab_clsLevel is
1817: l_level BSC_DBGEN_STD_METADATA.clsLevel ;
1818: cursor cLevels(p_s_table VARCHAR2) IS
1819: select distinct dim_level_id, level_table_name, level_pk_col from bsc_db_tables_cols cols, bsc_sys_dim_levels_b lvl
1820: where
1821: cols.table_name like p_s_table
1822: and cols.column_type='P'
1823: and cols.column_name = lvl.level_pk_col;

Line 1857: select count(1) into l_count from bsc_db_tables_cols where table_name=p_b_table and column_name=p_column;

1853: --
1854: function column_exists_in_table (p_b_table in varchar2, p_column in varchar2) return boolean is
1855: l_count number;
1856: begin
1857: select count(1) into l_count from bsc_db_tables_cols where table_name=p_b_table and column_name=p_column;
1858: if (l_count>0) then
1859: return true;
1860: end if;
1861: return false;

Line 1868: from bsc_db_tables_cols

1864: -- used to see if an BSCIC column is from a B table
1865: function is_BSCIC_column_from_b_table(p_s_table in varchar2, p_b_table in varchar2, p_column in varchar2) return boolean is
1866: cursor cFormula is
1867: select source_formula
1868: from bsc_db_tables_cols
1869: where table_name=p_s_table
1870: and column_type='A'
1871: and column_name=p_column;
1872: l_column_name varchar2(400);

Line 1886: select count(1) into l_count from bsc_db_tables_rels

1882:
1883: function is_b_table_a_source(p_s_table in varchar2, p_b_table in varchar2) return boolean is
1884: l_count number;
1885: begin
1886: select count(1) into l_count from bsc_db_tables_rels
1887: where table_name = p_s_table and source_table_name=p_b_table;
1888: if l_count>0 then
1889: return true;
1890: end if;

Line 1907: From bsc_db_tables_cols s_table,

1903: , measures.MEASURE_GROUP_ID
1904: , measures.PROJECTION_ID
1905: , NVL(measures.MEASURE_TYPE, 1) MEASURE_TYPE
1906: , sysm.MEASURE_ID
1907: From bsc_db_tables_cols s_table,
1908: bsc_db_tables_cols b_table,
1909: BSC_DB_MEASURE_COLS_VL measures,
1910: BSC_SYS_MEASURES sysm
1911: where s_table.table_name = p_s_table

Line 1908: bsc_db_tables_cols b_table,

1904: , measures.PROJECTION_ID
1905: , NVL(measures.MEASURE_TYPE, 1) MEASURE_TYPE
1906: , sysm.MEASURE_ID
1907: From bsc_db_tables_cols s_table,
1908: bsc_db_tables_cols b_table,
1909: BSC_DB_MEASURE_COLS_VL measures,
1910: BSC_SYS_MEASURES sysm
1911: where s_table.table_name = p_s_table
1912: and b_table.table_name = p_base_table

Line 1923: bsc_db_tables_cols s_table,

1919: select distinct s_table.column_name, s_table.source_formula,
1920: measures.MEASURE_GROUP_ID, measures.PROJECTION_ID, NVL(measures.MEASURE_TYPE, 1) MEASURE_TYPE,
1921: sysm.MEASURE_ID
1922: from
1923: bsc_db_tables_cols s_table,
1924: bsc_db_tables_cols b_table,
1925: BSC_DB_MEASURE_COLS_VL measures,
1926: BSC_SYS_MEASURES sysm
1927: where s_table.table_name =p_s_table

Line 1924: bsc_db_tables_cols b_table,

1920: measures.MEASURE_GROUP_ID, measures.PROJECTION_ID, NVL(measures.MEASURE_TYPE, 1) MEASURE_TYPE,
1921: sysm.MEASURE_ID
1922: from
1923: bsc_db_tables_cols s_table,
1924: bsc_db_tables_cols b_table,
1925: BSC_DB_MEASURE_COLS_VL measures,
1926: BSC_SYS_MEASURES sysm
1927: where s_table.table_name =p_s_table
1928: and b_table.table_name = p_base_table

Line 1938: bsc_db_tables_cols s_table,

1934: select distinct s_table.column_name, s_table.source_formula,
1935: measures.MEASURE_GROUP_ID, measures.PROJECTION_ID, NVL(measures.MEASURE_TYPE, 1) MEASURE_TYPE,
1936: sysm.MEASURE_ID
1937: from
1938: bsc_db_tables_cols s_table,
1939: bsc_db_tables_cols b_table,
1940: BSC_DB_MEASURE_COLS_VL measures,
1941: BSC_SYS_MEASURES sysm
1942: where s_table.table_name =p_s_table

Line 1939: bsc_db_tables_cols b_table,

1935: measures.MEASURE_GROUP_ID, measures.PROJECTION_ID, NVL(measures.MEASURE_TYPE, 1) MEASURE_TYPE,
1936: sysm.MEASURE_ID
1937: from
1938: bsc_db_tables_cols s_table,
1939: bsc_db_tables_cols b_table,
1940: BSC_DB_MEASURE_COLS_VL measures,
1941: BSC_SYS_MEASURES sysm
1942: where s_table.table_name =p_s_table
1943: and b_table.table_name(+) = p_base_table

Line 1955: BSC_DB_TABLES_RELS rels

1951: -- there can be multiple Base tables feeding this kpi
1952: -- this may be because of different lowest level periodicities or different measures from diff. tables
1953: CURSOR cLowestStable IS
1954: SELECT table_name FROM
1955: BSC_DB_TABLES_RELS rels
1956: WHERE table_name like 'BSC_S%'||p_fact||'_'||p_dim_set||'%'
1957: AND source_table_name not like 'BSC_S%'
1958: AND p_base_table IN (select table_name from bsc_db_tables_rels rels2 connect by table_name=prior source_table_name start with table_name = rels.table_name);
1959:

Line 1958: AND p_base_table IN (select table_name from bsc_db_tables_rels rels2 connect by table_name=prior source_table_name start with table_name = rels.table_name);

1954: SELECT table_name FROM
1955: BSC_DB_TABLES_RELS rels
1956: WHERE table_name like 'BSC_S%'||p_fact||'_'||p_dim_set||'%'
1957: AND source_table_name not like 'BSC_S%'
1958: AND p_base_table IN (select table_name from bsc_db_tables_rels rels2 connect by table_name=prior source_table_name start with table_name = rels.table_name);
1959:
1960:
1961: l_lowest_s_table VARCHAR2(100);
1962: Begin

Line 2016: SELECT periodicity_id from bsc_db_tables where table_name=p_table;

2012:
2013: function get_periodicity_for_table(
2014: p_table varchar2) return NUMBER is
2015: CURSOR cTablePer IS
2016: SELECT periodicity_id from bsc_db_tables where table_name=p_table;
2017: l_per NUMBER;
2018: Begin
2019: OPEN cTablePer;
2020: FETCH cTablePer into l_per;

Line 2117: from bsc_db_Tables_rels rels,

2113: p_dim_set in number,
2114: p_targets in boolean) return dbms_sql.varchar2_table is
2115: CURSOR cBTables(p_prefix VARCHAR2) IS
2116: select distinct rels.table_name
2117: from bsc_db_Tables_rels rels,
2118: bsc_db_tables src
2119: where
2120: rels.source_table_name = src.table_name
2121: and src.table_type=0

Line 2118: bsc_db_tables src

2114: p_targets in boolean) return dbms_sql.varchar2_table is
2115: CURSOR cBTables(p_prefix VARCHAR2) IS
2116: select distinct rels.table_name
2117: from bsc_db_Tables_rels rels,
2118: bsc_db_tables src
2119: where
2120: rels.source_table_name = src.table_name
2121: and src.table_type=0
2122: and rels.table_name like 'BSC_B%'

Line 2126: BSC_DB_TABLES_RELS rels

2122: and rels.table_name like 'BSC_B%'
2123: connect by rels.table_name=prior rels.source_table_name
2124: start with rels.table_name in -- lowest level S tables
2125: ( SELECT table_name FROM
2126: BSC_DB_TABLES_RELS rels
2127: WHERE table_name like p_prefix||p_fact||'_'||p_dim_set||'%'
2128: AND source_table_name not like 'BSC_S%'
2129: ) ;
2130:

Line 2228: Discussed this with Venu, he asked me to change the code to first check bsc_db_tables.

2224: end;
2225:
2226: /* Changed Aug 11, 2005 by Arun
2227: Bug 4549520
2228: Discussed this with Venu, he asked me to change the code to first check bsc_db_tables.
2229: If its null, then we goto bsc_sys_calendars
2230: */
2231:
2232: function get_current_year_for_fact(

Line 2261: from bsc_db_tables

2257: function get_current_period_for_table(
2258: p_table_name varchar2) return number is
2259: cursor cPeriod is
2260: select current_period
2261: from bsc_db_tables
2262: where table_name=p_table_name;
2263: l_period number;
2264: begin
2265: open cPeriod;

Line 2277: , bsc_db_tables dbtbl

2273: cursor cPeriod is
2274: select current_year
2275: from bsc_sys_calendars_b cal
2276: , bsc_sys_periodicities per
2277: , bsc_db_tables dbtbl
2278: where dbtbl.table_name = p_table_name
2279: and dbtbl.periodicity_id = per.periodicity_id
2280: and per.calendar_id = cal.calendar_id;
2281: l_year number;

Line 2763: select periodicity_id from bsc_db_tables where table_name in

2759:
2760:
2761: function get_target_per_for_b_table(p_fact in varchar2, p_dim_set in number, p_b_table in varchar2) return dbms_sql.varchar2_table is
2762: cursor cTgtPeriodicities is
2763: select periodicity_id from bsc_db_tables where table_name in
2764: (
2765: select distinct table_name from bsc_db_tables_rels rels
2766: where
2767: rels.table_name like 'BSC_S%'||p_fact||'_'||p_dim_set||'%'

Line 2765: select distinct table_name from bsc_db_tables_rels rels

2761: function get_target_per_for_b_table(p_fact in varchar2, p_dim_set in number, p_b_table in varchar2) return dbms_sql.varchar2_table is
2762: cursor cTgtPeriodicities is
2763: select periodicity_id from bsc_db_tables where table_name in
2764: (
2765: select distinct table_name from bsc_db_tables_rels rels
2766: where
2767: rels.table_name like 'BSC_S%'||p_fact||'_'||p_dim_set||'%'
2768: and rels.source_table_name not like 'BSC_S%'||p_fact||'_'||p_dim_set||'%'
2769: connect by prior rels.table_name=rels.source_table_name

Line 2814: select distinct table_name from bsc_db_tables_rels

2810: --BSC_DBGEN_STD_METADATA.tab_clsLevel
2811: is
2812: --Find Summary Table fed by this B table
2813: cursor cSummary(p_pattern in varchar2) is
2814: select distinct table_name from bsc_db_tables_rels
2815: where instr(table_name, p_pattern)=1
2816: and source_table_name not like p_pattern||'%'
2817: connect by source_table_name = prior table_name
2818: start with source_table_name = p_b_table_name;

Line 2828: FROM bsc_db_tables_rels rels

2824: (
2825: SELECT table_name child_lvl
2826: , source_Table_name parent_lvl
2827: , LEVEL lvl
2828: FROM bsc_db_tables_rels rels
2829: START WITH source_table_name = p_parent_level
2830: CONNECT BY source_table_name = PRIOR table_name
2831: )
2832: SELECT parent_lvl, child_lvl, lvl

Line 2844: select source_table_name,table_name , -1 from bsc_db_Tables_rels

2840: FROM tree
2841: WHERE child_lvl = p_child_level
2842: )
2843: union
2844: select source_table_name,table_name , -1 from bsc_db_Tables_rels
2845: where table_name=p_parent_level
2846: order by lvl ;
2847:
2848: cursor cCols (p_table_name in varchar2, p_col_type1 in varchar2, p_col_type2 in varchar2) is

Line 2849: select column_name, source_column source_column_name from bsc_db_Tables_cols

2845: where table_name=p_parent_level
2846: order by lvl ;
2847:
2848: cursor cCols (p_table_name in varchar2, p_col_type1 in varchar2, p_col_type2 in varchar2) is
2849: select column_name, source_column source_column_name from bsc_db_Tables_cols
2850: where table_name = p_table_name
2851: and column_type in(p_col_type1, p_col_type2);
2852:
2853:

Line 2949: select properties from bsc_db_tables where table_name=p_table_name;

2945:
2946:
2947: procedure set_table_property(p_table_name in varchar2, p_property_name in varchar2, p_property_value in varchar2) is
2948: cursor get_old_value is
2949: select properties from bsc_db_tables where table_name=p_table_name;
2950: l_old_value varchar2(4000);
2951: l_final_value varchar2(4000);
2952: l_pos number;
2953: l_property_value varchar2(4000);

Line 2962: update bsc_db_tables

2958: close get_old_value;
2959: l_property_value := p_property_name||BSC_DBGEN_STD_METADATA.BSC_ASSIGNMENT||
2960: p_property_value||BSC_DBGEN_STD_METADATA.BSC_PROPERTY_SEPARATOR;
2961: if (l_old_value is null) then
2962: update bsc_db_tables
2963: set properties = l_property_value
2964: where table_name = p_table_name;
2965: return;
2966: end if;

Line 2973: update bsc_db_tables

2969: if l_pos = 0 then -- check if first value
2970: l_pos := instr(l_old_value, p_property_name||BSC_DBGEN_STD_METADATA.BSC_ASSIGNMENT);
2971: end if;
2972: if l_pos =0 then -- this value does not exist, so append it
2973: update bsc_db_tables
2974: set properties = properties||l_property_value
2975: where table_name = p_table_name;
2976: return;
2977: end if;

Line 2992: update bsc_db_tables

2988: length(BSC_DBGEN_STD_METADATA.BSC_PROPERTY_SEPARATOR) );
2989: end if;
2990: -- now add the rest of the string back
2991:
2992: update bsc_db_tables
2993: set properties = l_final_value
2994: where table_name = p_table_name;
2995: return;
2996: Exception when others then