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_COLS

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 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 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 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: