APPS.BSC_MO_INPUT_TABLE_PKG dependencies on BSC_DB_TABLES_COLS

Line 23: FROM bsc_db_tables_cols

19:
20:
21: FUNCTION get_measures_for_table(p_table_pattern in varchar2) return BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField IS
22: l_stmt varchar2(1000):='SELECT distinct column_Name, source
23: FROM bsc_db_tables_cols
24: WHERE column_type = :1
25: AND table_name like :2
26: AND column_name not like :3';
27: cv CurTyp;

Line 97: SELECT source_column FROM bsc_db_tables_cols

93: SELECT table_name FROM bsc_db_tables_rels
94: WHERE source_table_name = l_src AND table_name LIKE l_tbl;
95:
96: CURSOR cColumns(l_table IN VARCHAR2, l_column IN VARCHAR2, l_column_type IN VARCHAR2) IS
97: SELECT source_column FROM bsc_db_tables_cols
98: WHERE table_name = l_table AND UPPER(column_name) = l_column AND column_type = l_column_type;
99:
100: BEGIN
101:

Line 130: FROM bsc_db_tables_cols

126: EXIT WHEN l_counter = KpiTable.keys.last;
127: l_counter := KpiTable.keys.next(l_counter);
128: END LOOP;
129: l_stmt := 'SELECT DISTINCT table_name AS SOURCE_TABLE_NAME
130: FROM bsc_db_tables_cols
131: WHERE table_name IN (
132: SELECT r.source_table_name
133: FROM bsc_db_tables_rels r, bsc_db_tables t
134: WHERE r.table_name LIKE :1 AND

Line 226: FROM BSC_DB_TABLES_COLS cols, bsc_db_measure_cols_vl dbcols

222: SELECT COLUMN_TYPE, COLUMN_NAME, SOURCE_COLUMN, SOURCE_FORMULA
223: --BSC Autogen
224: , SOURCE
225: , measure_group_id
226: FROM BSC_DB_TABLES_COLS cols, bsc_db_measure_cols_vl dbcols
227: WHERE cols.TABLE_NAME = pTable
228: AND cols.column_name = dbcols.measure_col(+);
229: cColsRow cCols%ROWTYPE;
230:

Line 2639: bsc_db_tables_cols cols

2635:
2636: CURSOR cKeys IS
2637: SELECT column_name
2638: FROM
2639: bsc_db_tables_cols cols
2640: WHERE
2641: cols.table_name = p_table
2642: AND cols.column_type = 'P'
2643: ORDER BY cols.column_name;

Line 2648: bsc_db_tables_cols cols,

2644:
2645: CURSOR cData(p_owner varchar2) IS
2646: SELECT cols.column_name, nvl(cols.source, 'BSC'), nvl(dbcols.measure_group_id, -1)
2647: FROM
2648: bsc_db_tables_cols cols,
2649: all_tab_columns tabcols,
2650: bsc_sys_measures sysm,
2651: bsc_db_measure_cols_vl dbcols
2652: WHERE

Line 2664: bsc_db_Tables_cols cols,

2660: ORDER BY cols.column_name;
2661:
2662: CURSOR cZeroCode (p_column in varchar2) IS
2663: select source_column, nvl(calculation_type, 0) from
2664: bsc_db_Tables_cols cols,
2665: bsc_db_calculations calc
2666: where
2667: cols.table_name = calc.table_name (+)
2668: and cols.table_name = p_table